question Re: Status: Waiting for catalog update from the StateStore in Support Questions

Status: Waiting for catalog update from the StateStore

yash808 — Fri, 16 Sep 2022 10:13:36 GMT

I am a Cloudera noob. I first tried to install Impala with CLoudera Manager and failed miserably. Did the same without Cloudera manager by following the link below.

http://hadoop4beginner.blogspot.in/2015/05/impala-installation-in-ubuntu.html

Have done everything in that link and finally when I tried to run a query from inside the impala shell, I get the following message.

"Query: create database sample
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore."

Please help. Thanks in advance.

Re: Status: Waiting for catalog update from the StateStore

yash808 — Tue, 12 Apr 2016 22:56:40 GMT

updating the link

hadoop4beginner.blogspot.in/2015/05/impala-installation-in-ubuntu.html

Re: Status: Waiting for catalog update from the StateStore

yash808 — Tue, 12 Apr 2016 23:01:29 GMT

Also, when I use the following command for the first time, the service starts properly.

sudo service impala-catalog start

After a few seconds when I check the status it says

* Impala Catalog Server is dead and pid file exists

Could this have anything to do with my problem?

Re: Status: Waiting for catalog update from the StateStore

lidaling — Sat, 08 Oct 2016 05:52:42 GMT

I have the same problem .

I check the catalog server log and found that the MySQL driver hive using is not consistent to The MySQL-server.

Fix it ,and all is ok.

Re: Status: Waiting for catalog update from the StateStore

skollcaku — Fri, 21 Jul 2017 12:03:10 GMT

Hi,

I am new to this CDH distribution and it happens I have the same issue here...

Did you resolve this problem and how exactly?

Thanks,

Skender

Re: Status: Waiting for catalog update from the StateStore

csguna — Sat, 22 Jul 2017 04:42:25 GMT

@skollcaku @yash808 @lidaling

if you are not using cloudera manager then fire this command to see your status of the statestore

Check 1  - see if you have software installed in Host that you are trying 

sudo yum install --assumeyes impala-state-store

sudo yum install --assumeyes impala-catalog

Check 2 
sudo service impala-state-store status 

if it is in failed state - check the logs /var/log/impala/

if it is in stop state 

start by firing this command 

sudo service impala-state-store start

then 

check the status again 


sudo service impala-state-store status

if you are using CM please let me know the version of CM/CDH plus your OS version / Kernel version

meantime check the instance to see if it is all green / red - I mean the Impala daemons (State store , catalog , impala daemon )

Let me know if that works

Re: Status: Waiting for catalog update from the StateStore

NguyenBac — Wed, 13 Dec 2017 08:00:18 GMT

I just restart catalog server and statestore server. Then it works

Re: Status: Waiting for catalog update from the StateStore

csguna — Thu, 14 Dec 2017 06:35:20 GMT

@NguyenBac I am glad that it worked

Re: Status: Waiting for catalog update from the StateStore

peenuts — Fri, 16 Feb 2018 06:56:59 GMT

Restart of hive metastore server and hive server worked for me.

Re: Status: Waiting for catalog update from the StateStore

dewdrop — Mon, 26 Mar 2018 18:47:09 GMT

seems like both services - impala-state-store and impala-catalog are down, restarting them worked for me

sudo service impala-state-store start

sudo service impala-catalog start

Re: Status: Waiting for catalog update from the StateStore

Susa — Mon, 03 Feb 2020 05:57:37 GMT

How you restart could you please tell step wise

Re: Status: Waiting for catalog update from the StateStore

Susa — Mon, 03 Feb 2020 06:14:41 GMT

[quickstart.cloudera:21000] > history;
[1]: help;
[2]: version;
[3]: history;
[4]: exit;
[5]: profile;
[6]: help;
[7]: profile;
[8]: history;
[9]: version;
[10]: profile;
[11]: CREATE DATABASE IF NOT EXISTS my_database;
[12]: history;
[quickstart.cloudera:21000] > sudo service impala-state-store start;
Query: sudo service impala-state-store start
Query submitted at: 2020-02-02 22:11:26 (Coordinator: http://quickstart.cloudera:25000)
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.

[quickstart.cloudera:21000] > sudo service impala-catalog start
>

[quickstart.cloudera:21000] > sudo service impala-catalog start;
Query: sudo service impala-catalog start
Query submitted at: 2020-02-02 22:11:48 (Coordinator: http://quickstart.cloudera:25000)
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.

Hi ,

I'm getting an error when fire both the below commands. kindly help

sudo service impala-state-store start;

sudo service impala-catalog start;

ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.