Login - EndHive
Remember meRe: login Error on Hive 0.13.0
hive-user mailing list archives
Message view
Bala Krishna Gangisetty &b...@&
Re: login Error on Hive 0.13.0
Incase of derby metastore, it is locked only for one hive cli connection at
a time. It seems another hive cli session is being opened while there is
already one opened hive cli session. Terminate any opened hive cli sessions
and try launching it again.
On Wed, May 28, 2014 at 1:44 PM, Rahul Channe &&wrote:
& I am trying to login to HIVE and getting following error
& user@localhost:~$ hive
& 14/05/28 16:42:04 WARN conf.HiveConf: DEPRECATED:
& hive.metastore.ds.retry.* no longer has any effect.
& hive.hmshandler.retry.* instead
& Logging initialized using configuration in
& jar:file:/home/user/apache-hive-0.13.0-bin/lib/hive-common-0.13.0.jar!/hive-log4j.properties
& Exception in thread "main" java.lang.RuntimeException:
& java.lang.RuntimeException: Unable to instantiate
& org.apache.hadoop.hive.metastore.HiveMetaStoreClient
& org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:344)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
& sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
& sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
& Caused by: java.lang.RuntimeException: Unable to instantiate
& org.apache.hadoop.hive.metastore.HiveMetaStoreClient
& org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1412)
& org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&init&(RetryingMetaStoreClient.java:62)
& org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
& org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2444)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2456)
& org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:338)
... 7 more
& Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
& sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
& sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
& org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1410)
... 12 more
& Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test
& connection to the given database. JDBC url =
& jdbc:derby:;databaseName=/user/hive/warehouse/metastore_create=true,
& username = APP. Terminating connection pool (set lazyInit to true if you
& expect to start your database after your app). Original Exception: ------
& java.sql.SQLException: Failed to start database
& '/user/hive/warehouse/metastore_db' with class loader
& sun.misc.Launcher$AppClassLoader@de6f34, see the next exception for
& details.
& org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
at org.apache.derby.impl.jdbc.EmbedConnection.&init&(Unknown
at org.apache.derby.impl.jdbc.EmbedConnection40.&init&(Unknown
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:615)
at java.sql.DriverManager.getConnection(DriverManager.java:167)
& com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
at com.jolbox.bonecp.BoneCP.&init&(BoneCP.java:416)
& com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
& org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
& org.datanucleus.store.rdbms.RDBMSStoreManager.&init&(RDBMSStoreManager.java:298)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
& sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
& sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
& org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
& org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
& org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
& org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
& org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
& org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
& org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
& sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
& sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
& javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
& javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
& javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
& org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:309)
& org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:338)
& org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:247)
& org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:222)
& org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
& org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
& org.apache.hadoop.hive.metastore.RawStoreProxy.&init&(RawStoreProxy.java:58)
& org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
& org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:498)
& org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:476)
& org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:524)
& org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:398)
& org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.&init&(HiveMetaStore.java:357)
& org.apache.hadoop.hive.metastore.RetryingHMSHandler.&init&(RetryingHMSHandler.java:54)
& org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
& org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4948)
& org.apache.hadoop.hive.metastore.HiveMetaStoreClient.&init&(HiveMetaStoreClient.java:171)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
& sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
& sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
& org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1410)
& org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&init&(RetryingMetaStoreClient.java:62)
& org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
& org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2444)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2456)
& org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:338)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
& sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
& sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
& Caused by: java.sql.SQLException: Failed to start database
& '/user/hive/warehouse/metastore_db' with class loader
& sun.misc.Launcher$AppClassLoader@de6f34, see the next exception for
& details.
& org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
& org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
... 72 more
& Caused by: java.sql.SQLException: Another instance of Derby may have
& already booted the database /user/hive/warehouse/metastore_db.
& org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
& org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
& org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
... 69 more
& Caused by: ERROR XSDB6: Another instance of Derby may have already booted
& the database /user/hive/warehouse/metastore_db.
& org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
& org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown
& org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
& org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown
& org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
& org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
& org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
& org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
& org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
& org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
& org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
& org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
Unnamed multipart/alternative (inline, None, 0 bytes)
(inline, None, 12649 bytes)
(inline, Quoted Printable, 17663 bytes)(ERROR:15) & 访客不能直接访问}