Hive Metastore canary failed to create a database.

[#1]

Hi,

We are facing below error for hive metaserver. Please find the logs.

1:21:02.464 PM ERROR RetryClientInvocationHandler
[pool-5-thread-47]: failed to execute syncNotifications
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)

1:21:02.465 PM ERROR SentrySyncHMSNotificationsPostEventListener
[pool-5-thread-47]: Failed to sync requested HMS notifications up to the event ID: 35354
java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy27.syncNotifications(Unknown Source)
at org.apache.sentry.binding.metastore.SentrySyncHMSNotificationsPostEventListener.syncNotificationEvents(SentrySyncHMSNotificationsPostEventListener.java:153)
at org.apache.sentry.binding.metastore.SentrySyncHMSNotificationsPostEventListener.onCreateDatabase(SentrySyncHMSNotificationsPostEventListener.java:108)

Does anyone have idea on that.Please share.

Thanks.

pdev

[#2]

@pdev 

Add the following to the "Hive Metastore Server Advanced Configuration Snippet (Safety Valve) for hive-site.xml", beneath the Hive Metastore Server Advanced configuration, save, and restart the Hive Metastore Server:

<property>
<name>hive.metastore.event.listeners</name>
<description>This will stop HMS blocking by Sentry</description>
<value></value>
</property>

@Note Test the properties in Test environment once it works then consider to add in Prod.