Impalad Frontend Connections

wert_1311 — Fri, 16 Sep 2022 14:46:04 GMT

Hi,

I am facing an issue with one of our Impala Daemon which continuously has error related to “The health test result for IMPALAD_FRONTEND_CONNECTIONS has become bad: There are 0 (Beeswax pool) 123 (Hive Server 2 pool) active client connections, each pool has a configured maximum of 128”

Have checked CM -> Impala -> Charts Library -> check "Active Frontend API connection" this shows too many Hive Server connections

Also checked server's network side and run netstat -an | grep ESTABLISHED | grep 25000 but I see only 2 active connections.

[root@nucleus ~]$ netstat -an | grep ESTABLISHED | grep 25000
tcp 0 0 10.20.20.41:25000 10.20.20.41:49728 ESTABLISHED

tcp 0 0 10.20.20.41:25000 10.20.20.41:49732 ESTABLISHED

Any assistance / guidance in resolving this issue is appericated.

CM / CDH - 6.3.3

Thanks

Wert.

Re: Impalad Frontend Connections

ChethanYM — Tue, 31 May 2022 10:22:57 GMT

Hi @wert_1311

It shows the number of impalad connections are hitting the limit.

You can check on these below points:

1. you can increase the value of "Impala Daemon Max Client Connections" property in the impala configs if really more number of connections are coming.

2. If you think the connections are less but the opened connections are not closing properly and causing the issue you can check the timeouts has been set properly in the Hue safety-valve advance configs.

-idle_session_timeout=3600

-idle_query_timeout=3600

Regards,

Chethan YM

question Re: Impalad Frontend Connections in Support Questions

Impalad Frontend Connections

Re: Impalad Frontend Connections