Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Could not create a hive database

Rising Star

Hi ,

I am getting canary error which is causing metastore health become bad initialy and then shutdown it .

 

2017-03-15 02:19:19,131 WARN com.cloudera.cmf.cdh5client.hive.MetastoreClientImpl: Could not create a hive database cloudera_manager_metastore_canary_test_db_hive_HIVEMETASTORE_6a416ede107a3bf0f7d7514a8f2e996d com.cloudera.cdh5client.hive.shaded.org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

 

how can i troublshoot this error ? what could be the cause for this ?

3 REPLIES 3

Champion

@MSharma

 

I've already answer to the similar question in the below link, pls have a look

 

https://community.cloudera.com/t5/Cloudera-Manager-Installation/The-Hive-Metastore-canary-failed-to-...

 

 

Rising Star
we are having this JAR file
mysql-connector-java-5.1.28-bin.jar
in
CDH- 5.7

also this error is intermittent not always .. do i have to download put the latest mysql jar file.

Champion

@MSharma

 

It is depends upon your version

 

Pls check the Note section on the below link

 

https://www.cloudera.com/documentation/enterprise/5-7-x/topics/cm_ig_mysql.html#cmig_topic_5_5_3

 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.