question Re: Impala jdbc connection drops intermittently in Support Questions

Impala jdbc connection drops intermittently

hadoopranger — Wed, 07 Aug 2024 13:19:31 GMT

Connecting to impala using one of the BI tools with jdbc string on port 21050

The connection is successful but drops intermittently for some time with below error

java.net.SocketException: Connection or outbound has closed

The firewall is open, there is no network issue between two servers

Re: Impala jdbc connection drops intermittently

AyazHussain — Thu, 08 Aug 2024 05:37:43 GMT

Please check if you are using impala LB for the connection string or impala daemon.

Re: Impala jdbc connection drops intermittently

hadoopranger — Thu, 08 Aug 2024 05:45:51 GMT

yes there is impala daemon used in connection string, how to tackle this error if it is caused due to daemon in connection string

Re: Impala jdbc connection drops intermittently

kbanik — Wed, 20 Nov 2024 16:19:36 GMT

@hadoopranger Consider tuning parameters like idle_session_timeout and idle_query_timeout which is suspected to be closing the session considering you don't have LB in place.

You can also set it to 0 where session will never expire until closed manually.

Moreover, consider increasing value of fe_service_threads to allow more concurrent client connections which should help you avoiding similar client connection issue in future.

For more info, refer: https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/impala-reference/topics/impala-recommended-configs.html