Cloudera Community
Shab
user rank
Explorer

Re: The Hive Metastore canary failed to create a d...

by Explorer in Support Questions
‎10-10-2021 07:36 PM
‎10-10-2021 07:36 PM
Thanks @smruti . Will try this and update with results. ... View more

Re: The Hive Metastore canary failed to create a d...

by Explorer in Support Questions
‎10-10-2021 06:31 AM
‎10-10-2021 06:31 AM
@smruti  'hive.metastore.client.socket.timeout' value is currently set to 60. Should I change it to 5? Or should I go ahead with the 'hive.metastore.event.listeners' setting you had suggested, as we do use Sentry in our cluster. What do you suggest should I set the value to in this case? ... View more

Re: The Hive Metastore canary failed to create a d...

by Explorer in Support Questions
‎10-09-2021 09:58 PM
‎10-09-2021 09:58 PM
Thanks@smruti for your reply. I am getting these error alerts ("HIVEMETASTORE_CANARY_HEALTH has become bad: The Hive Metastore canary failed to create a database.") but when I look at the logs I see only these warnings that I had pasted in my initial question. I get these alerts 4 to 5 times a day, although it recovers in about 5 minutes every time. I checked the service monitor logs but I did not find any timeout errors there as well. Could these warnings be setting off alerts? If yes then can we stop that from happening?   ... View more

The Hive Metastore canary failed to create a datab...

by Explorer in Support Questions
‎10-05-2021 06:16 AM
‎10-05-2021 06:16 AM
Hello all, I know this has been asked a lot of times before but I have not been able to resolve this issue using those fixes. I get this error twice or thrice every day. Someone please help.     3:44:45.647 PM WARN Configuration [pool-8-thread-192]: org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@464eba80:an attempt to override final parameter: hive.exec.dynamic.partition.mode; Ignoring. 3:44:45.647 PM WARN Configuration [pool-8-thread-192]: org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@464eba80:an attempt to override final parameter: hive.compactor.initiator.on; Ignoring. 3:44:45.648 PM WARN HiveConf [pool-8-thread-192]: HiveConf of name hive.sentry.conf.url does not exist 3:44:45.648 PM WARN HiveConf [pool-8-thread-192]: HiveConf of name hive.enforce.bucketing does not exist   Thanks, Shaban ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎12-27-2021 07:05 AM
Community Statistics
Member Since ‎09-28-2021 09:38 PM
Last Visited ‎12-27-2021 07:05 AM
Posts 4