New Contributor
Posts: 8
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

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