Reply
Highlighted
New Contributor
Posts: 9
Registered: ‎09-28-2018

The Hive Metastore canary failed to create a database.

[ Edited ]

Hive is being run on Name Node 1.

When I start Hive service everything is green and up and running:

Hive Metastore Server
HiveServer2

WebHCat Server

After few minutes Hive Metastore Server becomes unavailable with bad health:

Hive Metastore Canary 

"The Hive Metastore canary failed to create a database."

 

Few more information:

  • we do not have any MySQL database, we are using OOTB configuration for Hive, so it is probably Postgre
  • I already run command Update Hive Metastore Database Schema and Update Hive Metastore Name Nodes after installation. They are grey now.

 

Please advise for further steps.

Thank you

 

New Contributor
Posts: 9
Registered: ‎09-28-2018

Re: The Hive Metastore canary failed to create a database.

Can someone please provide me steps how to resolve this or what should be the following debugging steps? Thank you
Posts: 918
Topics: 1
Kudos: 209
Solutions: 112
Registered: ‎04-22-2014

Re: The Hive Metastore canary failed to create a database.

@VeljkoC,

 

Cloudera Manager performs health tests to ensure that CDH servers are running properly.  One of these tests is creating and dropping a database in the Hive Metastore.  The health alert you are seeing indicates that that process failed.

 

Places to look for more information about the failure:

 

- Service Monitor (which issues the health check):

/var/log/cloudera-scm-firehose/mgmt-cmf-mgmt-SERVICEMONITOR*

 

you might search for the word "canary" or "hive" in that file.

 

- Hive Metastore log file

/var/log/hive/hadoop-cmf-HIVE-1-HIVEMETASTORE*

 

Check for the word "canary" or look for WARN and ERROR messages pertaining to database names that include the string "canary".

 

 

Announcements