This should be hive env issue, you can try those sqls directly in hive cli to see if could work.
For the exception, maybe you could use other database instead of derby as hive metastore, such as mysql. Thanks, Dong Li 2016-06-16 14:17 GMT+08:00 Punit Naik <[email protected]>: > So what is the fix for that? I am not running any extra services except > the prerequisites for Kylin. > > On Thu, Jun 16, 2016 at 11:36 AM, Dong Li <[email protected]> wrote: > >> Seems your hive does not work correctly: >> >> Caused by: ERROR XSDB6: Another instance of Derby may have already booted >> the database /home/test/metastore_db. >> >> >> Thanks, >> Dong Li >> >> 2016-06-16 13:59 GMT+08:00 Punit Naik <[email protected]>: >> >>> Hi >>> >>> I ran sample.sh and then tried to build the 'kylin_sales-cube' that was >>> generated. But when I did that I got the following error: >>> >>> OS command error exit with 1 -- hive -e "USE default; >>> DROP TABLE IF EXISTS >>> kylin_intermediate_kylin_sales_cube_desc_20120101000000_20160713063000; >>> >>> CREATE EXTERNAL TABLE IF NOT EXISTS >>> kylin_intermediate_kylin_sales_cube_desc_20120101000000_20160713063000 >>> ( >>> DEFAULT_KYLIN_SALES_PART_DT date >>> ,DEFAULT_KYLIN_SALES_LEAF_CATEG_ID bigint >>> ,DEFAULT_KYLIN_SALES_LSTG_SITE_ID int >>> ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_META_CATEG_NAME string >>> ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_CATEG_LVL2_NAME string >>> ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_CATEG_LVL3_NAME string >>> ,DEFAULT_KYLIN_SALES_LSTG_FORMAT_NAME string >>> ,DEFAULT_KYLIN_SALES_PRICE decimal(19,4) >>> ,DEFAULT_KYLIN_SALES_SELLER_ID bigint >>> ) >>> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177' >>> STORED AS SEQUENCEFILE >>> LOCATION >>> '/kylin/kylin_metadata/kylin-036465c8-0669-491a-8197-f81d65d5a6b6/kylin_intermediate_kylin_sales_cube_desc_20120101000000_20160713063000'; >>> >>> SET dfs.replication=2; >>> SET dfs.block.size=33554432; >>> SET hive.exec.compress.output=true; >>> SET hive.auto.convert.join.noconditionaltask=true; >>> SET hive.auto.convert.join.noconditionaltask.size=300000000; >>> SET >>> mapreduce.map.output.compress.codec=org.apache.hadoop.io.compress.SnappyCodec; >>> SET >>> mapreduce.output.fileoutputformat.compress.codec=org.apache.hadoop.io.compress.SnappyCodec; >>> SET hive.merge.mapfiles=true; >>> SET hive.merge.mapredfiles=true; >>> SET mapred.output.compression.type=BLOCK; >>> SET hive.merge.size.per.task=256000000; >>> SET hive.support.concurrency=false; >>> SET mapreduce.job.split.metainfo.maxsize=-1; >>> >>> INSERT OVERWRITE TABLE >>> kylin_intermediate_kylin_sales_cube_desc_20120101000000_20160713063000 >>> SELECT >>> KYLIN_SALES.PART_DT >>> ,KYLIN_SALES.LEAF_CATEG_ID >>> ,KYLIN_SALES.LSTG_SITE_ID >>> ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME >>> ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME >>> ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME >>> ,KYLIN_SALES.LSTG_FORMAT_NAME >>> ,KYLIN_SALES.PRICE >>> ,KYLIN_SALES.SELLER_ID >>> FROM DEFAULT.KYLIN_SALES as KYLIN_SALES >>> INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT >>> ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT >>> INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS >>> ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND >>> KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID >>> WHERE (KYLIN_SALES.PART_DT >= '2012-01-01' AND KYLIN_SALES.PART_DT < >>> '2016-07-13') >>> ; >>> >>> " >>> >>> Logging initialized using configuration in >>> jar:file:/home/test/fcstack/apache-hive-0.14.0-bin/lib/hive-common-0.14.0.jar!/hive-log4j.properties >>> SLF4J: Class path contains multiple SLF4J bindings. >>> SLF4J: Found binding in >>> [jar:file:/home/test/fcstack/hadoop-2.4.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] >>> SLF4J: Found binding in >>> [jar:file:/home/test/fcstack/apache-hive-0.14.0-bin/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] >>> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >>> explanation. >>> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] >>> Exception in thread "main" java.lang.RuntimeException: >>> java.lang.RuntimeException: Unable to instantiate >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient >>> at >>> org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444) >>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672) >>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at org.apache.hadoop.util.RunJar.main(RunJar.java:212) >>> Caused by: java.lang.RuntimeException: Unable to instantiate >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient >>> at >>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1449) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:63) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:73) >>> at >>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2661) >>> at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2680) >>> at >>> org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:425) >>> ... 7 more >>> Caused by: java.lang.reflect.InvocationTargetException >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1447) >>> ... 12 more >>> Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test >>> connection to the given database. JDBC url = >>> jdbc:derby:;databaseName=metastore_db;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 'metastore_db' with class >>> loader sun.misc.Launcher$AppClassLoader@3351e824, see the next exception >>> for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) >>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) >>> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) >>> 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:571) >>> at java.sql.DriverManager.getConnection(DriverManager.java:187) >>> at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) >>> at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) >>> at >>> com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) >>> at >>> org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) >>> at >>> org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) >>> at >>> org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) >>> at >>> org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) >>> at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) >>> at >>> javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:340) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:369) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:266) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:233) >>> at >>> org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) >>> at >>> org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:560) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:538) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:591) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:429) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5554) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:178) >>> at >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:73) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1447) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:63) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:73) >>> at >>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2661) >>> at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2680) >>> at >>> org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:425) >>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672) >>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at org.apache.hadoop.util.RunJar.main(RunJar.java:212) >>> Caused by: java.sql.SQLException: Failed to start database 'metastore_db' >>> with class loader sun.misc.Launcher$AppClassLoader@3351e824, see the next >>> exception for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> ... 72 more >>> Caused by: java.sql.SQLException: Another instance of Derby may have >>> already booted the database /home/test/metastore_db. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >>> Source) >>> ... 69 more >>> Caused by: ERROR XSDB6: Another instance of Derby may have already booted >>> the database /home/test/metastore_db. >>> at org.apache.derby.iapi.error.StandardException.newException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown >>> Source) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) >>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown >>> Source) >>> ... 69 more >>> ------ >>> >>> NestedThrowables: >>> java.sql.SQLException: Unable to open a test connection to the given >>> database. JDBC url = jdbc:derby:;databaseName=metastore_db;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 'metastore_db' with class >>> loader sun.misc.Launcher$AppClassLoader@3351e824, see the next exception >>> for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) >>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) >>> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) >>> 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:571) >>> at java.sql.DriverManager.getConnection(DriverManager.java:187) >>> at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) >>> at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) >>> at >>> com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) >>> at >>> org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) >>> at >>> org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) >>> at >>> org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) >>> at >>> org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) >>> at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) >>> at >>> javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:340) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:369) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:266) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:233) >>> at >>> org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) >>> at >>> org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:560) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:538) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:591) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:429) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5554) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:178) >>> at >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:73) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1447) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:63) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:73) >>> at >>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2661) >>> at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2680) >>> at >>> org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:425) >>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672) >>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at org.apache.hadoop.util.RunJar.main(RunJar.java:212) >>> Caused by: java.sql.SQLException: Failed to start database 'metastore_db' >>> with class loader sun.misc.Launcher$AppClassLoader@3351e824, see the next >>> exception for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> ... 72 more >>> Caused by: java.sql.SQLException: Another instance of Derby may have >>> already booted the database /home/test/metastore_db. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >>> Source) >>> ... 69 more >>> Caused by: ERROR XSDB6: Another instance of Derby may have already booted >>> the database /home/test/metastore_db. >>> at org.apache.derby.iapi.error.StandardException.newException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown >>> Source) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) >>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown >>> Source) >>> ... 69 more >>> ------ >>> >>> at >>> org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:436) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:788) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) >>> at >>> javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:340) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:369) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:266) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:233) >>> at >>> org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) >>> at >>> org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:560) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:538) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:591) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:429) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5554) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:178) >>> at >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:73) >>> ... 17 more >>> Caused by: java.sql.SQLException: Unable to open a test connection to the >>> given database. JDBC url = >>> jdbc:derby:;databaseName=metastore_db;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 'metastore_db' with class >>> loader sun.misc.Launcher$AppClassLoader@3351e824, see the next exception >>> for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) >>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) >>> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) >>> 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:571) >>> at java.sql.DriverManager.getConnection(DriverManager.java:187) >>> at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) >>> at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) >>> at >>> com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) >>> at >>> org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) >>> at >>> org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) >>> at >>> org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) >>> at >>> org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) >>> at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) >>> at >>> javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) >>> at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:340) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:369) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:266) >>> at >>> org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:233) >>> at >>> org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) >>> at >>> org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56) >>> at >>> org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:560) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:538) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:591) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:429) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) >>> at >>> org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5554) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:178) >>> at >>> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:73) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1447) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:63) >>> at >>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:73) >>> at >>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2661) >>> at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2680) >>> at >>> org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:425) >>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672) >>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at org.apache.hadoop.util.RunJar.main(RunJar.java:212) >>> Caused by: java.sql.SQLException: Failed to start database 'metastore_db' >>> with class loader sun.misc.Launcher$AppClassLoader@3351e824, see the next >>> exception for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> ... 72 more >>> Caused by: java.sql.SQLException: Another instance of Derby may have >>> already booted the database /home/test/metastore_db. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >>> Source) >>> ... 69 more >>> Caused by: ERROR XSDB6: Another instance of Derby may have already booted >>> the database /home/test/metastore_db. >>> at org.apache.derby.iapi.error.StandardException.newException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown >>> Source) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) >>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown >>> Source) >>> ... 69 more >>> ------ >>> >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at com.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192) >>> at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:422) >>> at >>> com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) >>> at >>> org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) >>> at >>> org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>> at >>> org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) >>> at >>> org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) >>> at >>> org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) >>> at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356) >>> at >>> org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) >>> ... 46 more >>> Caused by: java.sql.SQLException: Failed to start database 'metastore_db' >>> with class loader sun.misc.Launcher$AppClassLoader@3351e824, see the next >>> exception for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) >>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) >>> at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) >>> 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:571) >>> at java.sql.DriverManager.getConnection(DriverManager.java:187) >>> at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) >>> at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) >>> ... 58 more >>> Caused by: java.sql.SQLException: Failed to start database 'metastore_db' >>> with class loader sun.misc.Launcher$AppClassLoader@3351e824, see the next >>> exception for details. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> ... 72 more >>> Caused by: java.sql.SQLException: Another instance of Derby may have >>> already booted the database /home/test/metastore_db. >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown >>> Source) >>> at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >>> Source) >>> ... 69 more >>> Caused by: ERROR XSDB6: Another instance of Derby may have already booted >>> the database /home/test/metastore_db. >>> at org.apache.derby.iapi.error.StandardException.newException(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown >>> Source) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown >>> Source) >>> at >>> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown >>> Source) >>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) >>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) >>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown >>> Source) >>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown >>> Source) >>> at >>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown >>> Source) >>> at >>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown >>> Source) >>> ... 69 more >>> >>> Can anyone please help? >>> >>> -- >>> Thank You >>> >>> Regards >>> >>> Punit Naik >>> >> >> > > > -- > Thank You > > Regards > > Punit Naik >
