nevermind, I have to set these properties on hive metastore to resolve issue.I was setting these in HIveServer2
On Wed, Jan 17, 2024 at 11:38 PM Sanjay Gupta <sanja...@gmail.com> wrote: > > Hi, > I get exactly same issue as described here in Docker container which > is running Hive Metastore and HS2. > > Using Hive version 3.1.3 ( inside docker container) > > https://issues.apache.org/jira/browse/HIVE-19740 > It looks like close to above issue > > I have also set following in hive-site.xml as per suggestion but still > I get same issue in log file > > <property> > <name>hive.metastore.event.db.notification.api.auth</name> > <value>false</value> > </property> > <property> > <name>hadoop.proxyuser.hive.hosts</name> > <value>*</value> > </property> > > <property> > <name>hadoop.proxyuser.hive.groups</name> > <value>*</value> > </property> > > > 2024-01-18T07:36:07,203 INFO [main] metastore.HiveMetaStoreClient: > Connected to metastore. > 2024-01-18T07:36:07,204 INFO [main] server.HiveServer2: Shutting down > HiveServer2 > 2024-01-18T07:36:07,205 INFO [main] server.HiveServer2: > Stopping/Disconnecting tez sessions. > 2024-01-18T07:36:07,205 INFO [main] metastore.HiveMetaStoreClient: > Closed a connection to metastore, current connections: 2 > 2024-01-18T07:36:07,205 WARN [main] server.HiveServer2: Error > starting HiveServer2 on attempt 3, will retry in 60000ms > java.lang.RuntimeException: Error initializing notification event poll > at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:274) > ~[hive-service-3.1.3.jar:3.1.3] > at > org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:1038) > [hive-service-3.1.3.jar:3.1.3] > at > org.apache.hive.service.server.HiveServer2.access$1600(HiveServer2.java:139) > [hive-service-3.1.3.jar:3.1.3] > at > org.apache.hive.service.server.HiveServer2$StartOptionExecutor.execute(HiveServer2.java:1307) > [hive-service-3.1.3.jar:3.1.3] > at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:1151) > [hive-service-3.1.3.jar:3.1.3] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_342] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_342] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342] > at org.apache.hadoop.util.RunJar.run(RunJar.java:308) > [hadoop-common-3.1.0.jar:?] > at org.apache.hadoop.util.RunJar.main(RunJar.java:222) > [hadoop-common-3.1.0.jar:?] > Caused by: java.io.IOException: > org.apache.thrift.TApplicationException: Internal error processing > get_current_notificationEventId > at > org.apache.hadoop.hive.metastore.messaging.EventUtils$MSClientNotificationFetcher.getCurrentNotificationEventId(EventUtils.java:75) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.ql.metadata.events.NotificationEventPoll.<init>(NotificationEventPoll.java:103) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.ql.metadata.events.NotificationEventPoll.initialize(NotificationEventPoll.java:59) > ~[hive-exec-3.1.3.jar:3.1.3] > at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:272) > ~[hive-service-3.1.3.jar:3.1.3] > ... 10 more > Caused by: org.apache.thrift.TApplicationException: Internal error > processing get_current_notificationEventId > at > org.apache.thrift.TApplicationException.read(TApplicationException.java:111) > ~[hive-exec-3.1.3.jar:3.1.3] > at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_current_notificationEventId(ThriftHiveMetastore.java:5575) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_current_notificationEventId(ThriftHiveMetastore.java:5563) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getCurrentNotificationEventId(HiveMetaStoreClient.java:2723) > ~[hive-exec-3.1.3.jar:3.1.3] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_342] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_342] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342] > at > org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212) > ~[hive-exec-3.1.3.jar:3.1.3] > at com.sun.proxy.$Proxy25.getCurrentNotificationEventId(Unknown Source) ~[?:?] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_342] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_342] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342] > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:2773) > ~[hive-exec-3.1.3.jar:3.1.3] > at com.sun.proxy.$Proxy25.getCurrentNotificationEventId(Unknown Source) ~[?:?] > at > org.apache.hadoop.hive.metastore.messaging.EventUtils$MSClientNotificationFetcher.getCurrentNotificationEventId(EventUtils.java:73) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.ql.metadata.events.NotificationEventPoll.<init>(NotificationEventPoll.java:103) > ~[hive-exec-3.1.3.jar:3.1.3] > at > org.apache.hadoop.hive.ql.metadata.events.NotificationEventPoll.initialize(NotificationEventPoll.java:59) > ~[hive-exec-3.1.3.jar:3.1.3] > at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:272) > ~[hive-service-3.1.3.jar:3.1.3] > ... 10 more -- Thanks Sanjay Gupta
