Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

CDH 5.7.0 Hive metastore canary failed to create a database

CDH 5.7.0 Hive metastore canary failed to create a database

Contributor

Helo,

 

I'm having this issue listed above

 

In the logs it says:

 

message: version information not found in metastore.

3 REPLIES 3
Highlighted

Re: CDH 5.7.0 Hive metastore canary failed to create a database

Super Guru

This would normally indicate a problem in the Metastore.

I recommend checking the Hive Metastore logs for stack traces, further error messages, etc.

 

Please make sure that the Metastore is configured to point to the correct host/database and possibly try running "upgrade Hive Metastore Database Schema" from Cloudera Manager --> Hive --> Actions

 

Regards,

 

Ben

Re: CDH 5.7.0 Hive metastore canary failed to create a database

Contributor

helo,

 

Sorry for the late response. That option is currently not available to choose. it says "is not currently available for execution) when I try to click on it.

Re: CDH 5.7.0 Hive metastore canary failed to create a database

Champion

seems like the topic is duplicated. Pls refer the steps mentioned in the below link.

 

Note: This link refers to Mysql as metastore. Pls do the necessary change for postgres (or) other db as needed

 

https://community.cloudera.com/t5/Cloudera-Manager-Installation/The-Hive-Metastore-canary-failed-to-...

 

Don't have an account?
Coming from Hortonworks? Activate your account here