Forum: Building VoltDB Applications

Post: No response received in the allotted time (set to 120000 ms).

No response received in the allotted time (set to 120000 ms).
guotong1988
Jan 27, 2016
I insert 100 000 000 row into 3 node VoltDB cluster.
I start 10000 thread to run sql which is average cost 1.6s
And the console print
No response received in the allotted time (set to 120000 ms).

or

 Ad Hoc Planner task queue is full. Try again.

How to solve this ?
In addition , do I need to let the clients be connected to different node? Currently I let the clients connect to the same node.


by the way ,the sql is like
select * from (
select *
  from vehiclepass
 where plateinfo = 'A60N72'
   and passtime >= '2015-12-01 00:00:00'
   and passtime < '2015-12-08 00:00:00')
  as temptable
limit 20
what could I do to speed up the concurrency ?
pzhao
Jan 27, 2016
guotong1988,
It appears you've already saturated Ad Hoc Planner task queue. I agree with your thinking, try letting your client connect to all nodes in the cluster. If you don't have any indices, I'd suggest at least 2, one for plateinfo and passtime. Please take a look at best practices for index optimization. Additionally, I'd try to simplify the query to not include the subquery:
select *
from vehiclepass as temptable
where plateinfo = 'A60N72'
and passtime >= '2015-12-01 00:00:00'
and passtime < '2015-12-08 00:00:00'
limit 20;

Peter Zhao