My Oracle Support Banner

After Mammoth Upgrade Hive Metastore Server is in Bad Health with "The Hive Metastore canary failed to create a database." (Doc ID 2523601.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.10.0 and later
Linux x86-64


After Mammoth upgrade, the Hive Metastore Server goes into bad health with:

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

1. Hive Metadata Server logs show:

cmd=create_database: Database(name:cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_##, description:Cloudera Manager Metastore Canary Test Database
WARN org.apache.hadoop.hive.metastore.ObjectStore: Failed to get database cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_##, returning NoSuchObjectException"

2. Service Monitor logs show warnings like:

Could not drop hive table CM_TEST_TABLE for database: cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_##
Caused by: Read timed out"



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.