10-11-2018 05:33 AM - edited 10-11-2018 05:33 AM
Hive is being run on Name Node 1.
When I start Hive service everything is green and up and running:
Hive Metastore Server
After few minutes Hive Metastore Server becomes unavailable with bad health:
"The Hive Metastore canary failed to create a database."
Few more information:
Please advise for further steps.
10-17-2018 09:49 AM
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):
you might search for the word "canary" or "hive" in that file.
- Hive Metastore log file
Check for the word "canary" or look for WARN and ERROR messages pertaining to database names that include the string "canary".