[
https://issues.apache.org/jira/browse/HIVE-13499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15238795#comment-15238795
]
Thejas M Nair commented on HIVE-13499:
--------------------------------------
It looks like the derby connection can't be obtained. Maybe thats because the
changing is causing concurrent connections to derby ?
Hive.log snippet from
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7556/failed/TestJdbcWithMiniHS2/hive.log
{code}
2016-04-12T09:21:10,732 ERROR [BoneCP-pool-watch-thread[]]: bonecp.BoneCP
(BoneCP.java:obtainInternalConnection(292)) - Failed to acquire connection to
jdbc:derby:/home/hiveptest/23.20.195.28-hiveptest-2/apache-github-source-source/itests/hive-unit/target/tmp/1460472945587-0/test_metastore-1;create=true.
Sleeping for 7000 ms. Attempts left: 5
java.sql.SQLException: Failed to create database
'/home/hiveptest/23.20.195.28-hiveptest-2/apache-github-source-source/itests/hive-unit/target/tmp/1460472945587-0/test_metastore-1',
see the next exception for details.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
~[derby-10.10.2.0.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:571)
~[?:1.7.0_45]
at java.sql.DriverManager.getConnection(DriverManager.java:187)
~[?:1.7.0_45]
at
com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
~[bonecp-0.8.0.RELEASE.jar:?]
at com.jolbox.bonecp.BoneCP.obtainInternalConnection(BoneCP.java:269)
[bonecp-0.8.0.RELEASE.jar:?]
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:242)
[bonecp-0.8.0.RELEASE.jar:?]
at
com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
[bonecp-0.8.0.RELEASE.jar:?]
at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
[bonecp-0.8.0.RELEASE.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[?:1.7.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[?:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [?:1.7.0_45]
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Failed to create
database
'/home/hiveptest/23.20.195.28-hiveptest-2/apache-github-source-source/itests/hive-unit/target/tmp/1460472945587-0/test_metastore-1',
see the next exception for details.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) ~[derby-10.10.2.0.jar:?]
... 20 more
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: The database directory
'/home/hiveptest/23.20.195.28-hiveptest-2/apache-github-source-source/itests/hive-unit/target/tmp/1460472945587-0/test_metastore-1'
exists. However, it does not contain the expected 'service.properties' file.
Perhaps Derby was brought down in the middle of creating this database. You may
want to delete this directory and try creating the database again.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
... 17 more
Caused by: org.apache.derby.iapi.error.StandardException: The database
directory
'/home/hiveptest/23.20.195.28-hiveptest-2/apache-github-source-source/itests/hive-unit/target/tmp/1460472945587-0/test_metastore-1'
exists. However, it does not contain the expected 'service.properties' file.
Perhaps Derby was brought down in the middle of creating this database. You may
want to delete this directory and try creating the database again.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.services.monitor.StorageFactoryService.access$900(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at java.security.AccessController.doPrivileged(Native Method)
~[?:1.7.0_45]
at
org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
~[derby-10.10.2.0.jar:?]
at
org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown
Source) ~[derby-10.10.2.0.jar:?]
at
org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown
Source) ~[derby-10.10.2.0.jar:?]
... 17 more
{code}
> TestJdbcWithMiniHS2.testConcurrentStatements is hanging
> -------------------------------------------------------
>
> Key: HIVE-13499
> URL: https://issues.apache.org/jira/browse/HIVE-13499
> Project: Hive
> Issue Type: Bug
> Components: Tests
> Reporter: Thejas M Nair
> Attachments: HIVE-13499.temp.patch
>
>
> After HIVE-13149 went in , TestJdbcWithMiniHS2.testConcurrentStatements has
> been hanging, causing delays in the unit test run.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
