kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dong Li <lid...@apache.org>
Subject Re: kylin_sales_cube build error
Date Thu, 16 Jun 2016 06:46:02 GMT
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 <naik.punit44@gmail.com>:

> 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 <lidong@apache.org> 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 <naik.punit44@gmail.com>:
>>
>>> 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
>

Mime
View raw message