Support Questions

Find answers, ask questions, and share your expertise

Hive Metastore canary failed to create a database.

Explorer

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

1 REPLY 1

Contributor

@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.

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