06-05-2017 10:37 PM - edited 06-05-2017 10:39 PM
Using JDBC41 with SQuirrelSQL. idle query and session time outs are both 0.
The only way I could successfully override queue wait timeout was through "Impala Command Line Argument Advanced Configuration Snippet (Safety Valve)"
I0606 05:29:50.303781 16258 coordinator.cc:1053] Coordinator waiting for fragment instances to finish, 1 remaining I0606 05:29:50.304183 16457 coordinator.cc:1536] Fragment instance completed: id=b94622231741ddac:7c95396f00000000 host=[IP]:22000 remaining=0 I0606 05:29:50.304210 16258 coordinator.cc:1058] All fragment instances finished successfully. I0606 05:29:50.304275 16544 fragment-mgr.cc:99] PlanFragment completed. instance_id=b94622231741ddac:7c95396f00000000 I0606 05:29:50.505412 16258 impala-hs2-server.cc:679] CloseOperation(): query_id=b94622231741ddac:7c95396f00000000 I0606 05:29:50.505429 16258 impala-server.cc:906] UnregisterQuery(): query_id=b94622231741ddac:7c95396f00000000 I0606 05:29:50.505434 16258 impala-server.cc:992] Cancel(): query_id=b94622231741ddac:7c95396f00000000 I0606 05:29:50.505439 16258 coordinator.cc:1351] Cancel() query_id=b94622231741ddac:7c95396f00000000 I0606 05:29:50.505450 16258 coordinator.cc:1417] CancelFragmentInstances() query_id=b94622231741ddac:7c95396f00000000, tried to cancel 0 fragment instances I0606 05:30:50.113565 16258 impala-server.cc:1673] Connection from client [IP]:[PORT] closed, closing 2 associated session(s) I0606 05:30:50.122779 16258 status.cc:114] Session closed
Why would the session close after only 1 minute idle and how can this be resolved?
02-19-2019 02:32 PM
We are facing the same issue, our queries running for more than 1 minute through JDBC connection are failing with query state as session closed and error on the application as "ThriftTransportException" or "SQLException Cant retrieve next row"
Did you figure out the fix for this ?
It would be great if you can throw some light on this?