New Contributor
Posts: 3
Registered: ‎02-08-2015

CDH 5.5 The Hive Metastore canary failed to create a database.

[ Edited ]



After upgrading from CDH 5.3.2 to CDH 5.5.1 Hive Metastore Canary is showing this issue: "The Hive Metastore canary failed to create a database."  


this error is because the DB already exist:  ERROR org.apache.hadoop.hive.metastore.RetryingHMSHandler: [pool-3-thread-173]: AlreadyExistsException(message:Database cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_b3ffe0a47d5dfb87a9df54853d0c8b1d already exists)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(


But the real problem is that the current database can't be dropped because the use of encryption zone:


ERROR org.apache.hadoop.hive.metastore.RetryingHMSHandler: [pool-3-thread-173]: MetaException(message:Unable to drop cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_b3ffe0a47d5dfb87a9df54853d0c8b1d.cm_test_table because it is in an encryption zone and trash is enabled. Use PURGE option to skip trash.)


Looking at hive known issues, it looks like there is no current solution to this problem


I think a manual drop won't solve the problem as this is a scheduled test so I want to confirm if disabling the hive canary test could be done as a workaround while the problem is officially solved or if there is another workaround to this.