Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive server2 failing frequently

hive server2 failing frequently

Contributor

Hello All,

 

Hive server2 is failing in our CDH cluster.

 

I checked the logs, I see below error.

 

NoSuchObjectException(message:There is no database named cloudera_manager_metastore_canary_test_db_hive_hivemetastore_73c584a02e481c3d81791498cf98cd3f)

                at org.apache.hadoop.hive.metastore.ObjectStore.getMDatabase(ObjectStore.java:549)

                at org.apache.hadoop.hive.metastore.ObjectStore.getJDODatabase(ObjectStore.java:593)

                at org.apache.hadoop.hive.metastore.ObjectStore$1.getJdoResult(ObjectStore.java:583)

                at org.apache.hadoop.hive.metastore.ObjectStore$1.getJdoResult(ObjectStore.java:575)

                at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:2389)

                at org.apache.hadoop.hive.metastore.ObjectStore.getDatabaseInternal(ObjectStore.java:575)

                at org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:559)

                at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:606)

                at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:98)

                at com.sun.proxy.$Proxy0.getDatabase(Unknown Source)

                at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_database_core(HiveMetaStore.java:933)

                at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_database(HiveMetaStore.java:907)

                at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:606)

                at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102)

                at com.sun.proxy.$Proxy5.get_database(Unknown Source)

                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_database.getResult(ThriftHiveMetastore.java:8547)

                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_database.getResult(ThriftHiveMetastore.java:8531)

                at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

                at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)

                at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)

                at java.security.AccessController.doPrivileged(Native Method)

                at javax.security.auth.Subject.doAs(Subject.java:415)

                at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)

                at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)

                at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

                at java.lang.Thread.run(Thread.java:745)

 

 

Can you please suggest?

 

Thanks,

Priya