question Re: [Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT in Support Questions

[Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT

RyanAtWork — Wed, 22 Sep 2021 08:21:58 GMT

We use the Cloudera ODBC Driver for Impala from c# .Net using an OdbcConnection. We are using MIT Kerberos on Windows and keytab authentication. Occasionally, the process begins throwing the bellow Exception. Over time, the exception seems to correct itself, however the only known fix to us is to restart the process (which is a problem..)

Exception:

[Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. This error might be due to the server is not using SASL for authentication.

Connection String:

Driver={Cloudera ODBC Driver for Impala};Host=[ImpalaHostName];Port=21050;AuthMech=1;KrbRealm=[KerberosRealm];KrbServiceName=impala;UseKeytab=1;KrbFQDN=_HOST;UID=[UserName];UPNKeytabMappingFile=[jsonKeyTabMappingFile];UseNativeQuery=1;CurrentSchemaRestrictedMetadata=1;Schema=[Database];SocketTimeout=120

We have also occasionally seen the bellow exception, but these seem to be intermittent.

[Cloudera][ImpalaODBC] (450) Error when calling the Impala Thrift API ExecuteStatement: ETIMEDOUT

Re: [Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT

Pradheep — Thu, 23 Sep 2021 06:05:39 GMT

Hello,

Below exception is due to the Front_Service_Threads exhaustion.

It will authenticate the user but does not start the session because there's no availability for another threads.

I recommend to increase "--fe_service_threads" by default, it is set to 64.

Cloudera Manager > Impala > Configuration > search "Impala Command Line Argument Advanced Configuration Snippet (Safety Valve)" > --fe_service_threads=256 > Save and Restart Impala.

Thanks,

Pradheep

Re: [Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT

RyanAtWork — Fri, 24 Sep 2021 12:26:57 GMT

Thanks @Pradheep, That's very useful. I'm just a client of the cluster, so I have no permissions to view or alter such server side settings. However, at least I know that questions to ask the administrators of the cluster now.

Next I just need to find out more about the (450) error. It's a shame the Cloudera ODBC for Impala Driver error messages are so vague and unclear.