[HIVE-583] spurious 'default database not found'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Metastore
• Hadoop Flags: Reviewed
• Release Note: HIVE-583. Fix spurious 'default database not found'. (Prasad Chakka via zshao)
• Assignee: Prasad Chakka
• Reporter: Prasad Chakka
• Created: 26/Jun/09 00:52
• Updated: 17/Dec/11 00:07
• Resolved: 28/Jun/09 22:49

Description

occasionally this exception is thrown which doesn't make sense since that db exists.

09/06/25 16:52:58 INFO metastore.ObjectStore: Initialized ObjectStore
09/06/25 16:53:15 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=tmp_hipal_37888
09/06/25 16:53:51 ERROR JPOX.Transaction: Operation rollback failed on resource: org.jpox.store.rdbms.ConnectionFactoryImpl$EmulatedXAResource@4f62198b, error code UNKNOWN and transaction: [JPOX Transaction, Transaction ID=Xid=���, enlisted resources=[org.jpox.store.rdbms.ConnectionFactoryImpl$EmulatedXAResource@4f62198b]]
09/06/25 16:53:51 ERROR metastore.ObjectStore: NoSuchObjectException(message:There is no database named default)
at org.apache.hadoop.hive.metastore.ObjectStore.getMDatabase(ObjectStore.java:309)
at org.apache.hadoop.hive.metastore.ObjectStore.convertToMTable(ObjectStore.java:597)
at org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:475)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:308)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:251)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:251)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:748)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:96)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:307)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:213)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:176)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:216)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:273)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:166)
at org.apache.hadoop.mapred.JobShell.run(JobShell.java:194)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at org.apache.hadoop.mapred.JobShell.main(JobShell.java:220)