In VoltDB Community edition When I am uploading a CSV file (size: 550Mb)for more than 7 times and then performing basic aggregation operations, it’s showing query timeout. But then I tried to increase the query timeout through the web interface and still, it’s showing error as “query specific timeout is 10s” What should I do if I want to resolve this issue?
How to increase query specific timeout in VoltDB
254 views Asked by Kunal Mali At
1
What does your configuration / deployment file look like? To increase the query timeout, the following code should be somewhere in your deployment.xml file:
Where 30000 is 30 seconds, for example. The cluster-wide query timeout is set when you first initialize the database with voltdb init. You could re-initialize with force a new deployment file with the above section in it:
Or you could keep the cluster running and simply use:
The section Query Timeout in this part of the docs contains more information as well:
https://docs.voltdb.com/AdminGuide/HostConfigDBOpts.php
Full disclosure: I work at VoltDB.