How to increase query specific timeout in VoltDB

Question

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?

Answer 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:

<systemsettings>
   <query timeout="30000"/>
</systemsettings>

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:

voltdb init --force --config=new_deployment_file.xml

Or you could keep the cluster running and simply use:

voltadmin update new_deployment_file.xml

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.