Hi ,
We are using Postgres as Hive Meta Store. When we try to drop a table , It
hangs. Below is the small dump
Can any one help me in this regard
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.cache.level2.type value null from jpox.properties with SOFT
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.plugin.pluginRegistryBundleCheck value null from
jpox.properties with LOG
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.option.ConnectionURL value null from jpox.properties with
jdbc:postgresql://10.1.0.33:5488/metastore_XXX
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.autoStartMechanismMode value null from jpox.properties with
checked
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.validateConstraints value null from jpox.properties with false
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.autoCreateSchema value null from jpox.properties with true
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.cache.level2 value null from jpox.properties with false
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.option.ConnectionUserName value null from jpox.properties with
postgres
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.option.DetachAllOnCommit value null from jpox.properties with
true
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.connectionPoolingType value null from jpox.properties with DBCP
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.storeManagerType value null from jpox.properties with rdbms
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.option.ConnectionDriverName value null from jpox.properties with
org.postgresql.Driver
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.transactionIsolation value null from jpox.properties with
read-committed
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.validateColumns value null from jpox.properties with false
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.option.NonTransactionalRead value null from jpox.properties with
true
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.validateTables value null from jpox.properties with false
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
javax.jdo.PersistenceManagerFactoryClass value null from jpox.properties
with org.datanucleus.jdo.JDOPersistenceManagerFactory
10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding
datanucleus.identifierFactory value null from jpox.properties with
datanucleus
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
datanucleus.autoStartMechanismMode = checked
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.identifierFactory
= datanucleus
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
datanucleus.transactionIsolation = read-committed
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.validateTables =
false
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.option.ConnectionURL = jdbc:postgresql://
10.1.0.33:5488/metastore_yoda
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.option.DetachAllOnCommit = true
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.option.NonTransactionalRead = true
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
datanucleus.validateConstraints = false
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.option.ConnectionDriverName = org.postgresql.Driver
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.option.ConnectionUserName = postgres
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.validateColumns =
false
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.cache.level2 =
false
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
datanucleus.plugin.pluginRegistryBundleCheck = LOG
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.cache.level2.type
= SOFT
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
javax.jdo.PersistenceManagerFactoryClass =
org.datanucleus.jdo.JDOPersistenceManagerFactory
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.autoCreateSchema
= true
10/11/29 06:02:07 DEBUG metastore.ObjectStore: datanucleus.storeManagerType
= rdbms
10/11/29 06:02:07 DEBUG metastore.ObjectStore:
datanucleus.connectionPoolingType = DBCP
10/11/29 06:02:07 INFO metastore.ObjectStore: ObjectStore, initialize called
10/11/29 06:02:07 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.core.resources" but it cannot be resolved.
10/11/29 06:02:07 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.core.runtime" but it cannot be resolved.
10/11/29 06:02:07 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.text" but it cannot be resolved.
10/11/29 06:02:08 INFO metastore.ObjectStore: Initialized ObjectStore
10/11/29 06:02:08 INFO metastore.HiveMetaStore: 0: get_table : db=default
tbl=erer
10/11/29 06:02:09 INFO hive.log: DDL: struct erer { i32 a}
10/11/29 06:02:09 DEBUG lazy.LazySimpleSerDe: LazySimpleSerDe initialized
with: columnNames=[a] columnTypes=[int] separator=...@e4600c0] nullstring=\N
lastColumnTakesRest=false
10/11/29 06:02:09 INFO metastore.HiveMetaStore: 0: get_table : db=default
tbl=erer
10/11/29 06:02:09 INFO metastore.HiveMetaStore: 0: drop_table : db=default
tbl=erer
10/11/29 06:02:09 INFO metastore.HiveMetaStore: 0: get_table : db=default
tbl=erer
*10/11/29 06:02:09 DEBUG metastore.ObjectStore: Executing
listMPartitions ====> IT HANGS HERE*
