question [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server in Support Questions

[Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server

yagoaparecidoti — Thu, 23 Nov 2023 15:00:00 GMT

hi community cloudera,

we are verifying a strange behavior of an Impala connection controller on nifi, when the processor starts the connection, it displays the error below:

[Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Connection or outbound has closed

communication between hosts is ok, ports communicating without problem.

when we start and stop the processor the connection occurs without problem, this shows that the error is intermittent.

has anyone experienced this type of problem?

Re: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server

vaishaakb — Wed, 06 Dec 2023 15:01:23 GMT

@yagoaparecidoti Welcome to the Cloudera Community.

I understand that this connection failure between Impala JDBC Driver and NiFi is randomly disrupted.

Q. Are the other queries from Impala running fine?
Q. Version of NiFi and CDH/CDP?
Q. Is this specific only to the connection between NIFI and the Impala driver?
Q. May I know the size of the cluster?
Q. What are the values set for the following:
idle_session_timeout
idle_query_timeout
fe_service_threads and
idle_client_poll_time_s
Q. Do you also have TLS-enabled in the client communication?

Re: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server

yagoaparecidoti — Tue, 19 Dec 2023 20:07:49 GMT

hi @vaishaakb ,

1. Impala-shell queries work without any problems
2. Nifi version 2.2.6.4 on CDP Public Cloud
3. the problem is in the impala connection controller on the nifi to the impala which is on another datahub
4.
idle_session_timeout = no value
idle_query_timeout = no value
fe_service_threads = 64
idle_client_poll_time_s = this parameter does not exist in Impala
5. the environment is Kerberos and TLS enabled

Re: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server

hadoopranger — Thu, 08 Aug 2024 04:46:37 GMT

@yagoaparecidoti did you get a solution having the same issue

Re: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server

yagoaparecidoti — Thu, 08 Aug 2024 12:10:52 GMT

hi @hadoopranger,

unfortunately there is no solution for this specific error, I had to use another connection method using another jdbc controller.