Forum: Building VoltDB Applications

Post: count(*) giving "overflowed output/network buffer" error

count(*) giving "overflowed output/network buffer" error
gambitg
Sep 14, 2010
A simple count(*) of the key_value table in the key_value example is giving the error:
Output from SQL stmt overflowed output/network buffer of 10mb. Try a "limit" clause or a stronger predicate.

This is through a stored procedure.

I know it is multi-partitioned query and performance will be impacted but surprised to see it hitting the buffer limits. Any work arounds to get to count(*) of huge tables ?

Thanks.
re: count(*) giving "overflowed output/network buffer" error
tcallaghan
Sep 16, 2010
As a current workaround, you can call the @Statistics system procedure to get rowcounts for a table by partition, see this page for more information.

Do you need "select count(*) from " functionality as part of your application?

-Tim
FYI, I have created a Jira
tcallaghan
Sep 16, 2010
FYI, I have created a Jira ticket for this issue. You can view it at http://issues.voltdb.com/browse/ENG-732
Reply
gambitg
Sep 17, 2010
No, I don't need it as part of my scheduled production functionality. But I can see the value in debugging production issues and ofcourse for development.

Thanks for opening a ticket.