[ https://issues.apache.org/jira/browse/JCLOUDS-1029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ignasi Barrera resolved JCLOUDS-1029. ------------------------------------- Resolution: Fixed Fix Version/s: 2.0.0 > JDBC tests hang the build > ------------------------- > > Key: JCLOUDS-1029 > URL: https://issues.apache.org/jira/browse/JCLOUDS-1029 > Project: jclouds > Issue Type: Bug > Components: jclouds-labs > Affects Versions: 2.0.0 > Reporter: Ignasi Barrera > Labels: jdbc > Fix For: 2.0.0 > > > This is becoming a real issue, as more than 50% of the recent jclouds-labs and jclouds-labs-pull-requests Jenkins builds hang when running the JDBC tests. > [~rcoedo] could you have a look at this and at JCLOUDS-1009? > Here is an example stacktrace. Once it appears, the build hangs. > {code} > Test suite progress: tests succeeded: 59, failed: 0, skipped: 2. > 0 [pool-8-thread-2] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - transaction rollback: serialization failure > 0 [pool-8-thread-1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - transaction rollback: serialization failure > unable to delete container jenkins-blobstore-5256680054079839105, ignoring... > unable to delete container jenkins-blobstore7, ignoring... > javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet > at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) > at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) > at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:524) > at org.jclouds.jdbc.repository.ContainerRepository.findContainerByName(ContainerRepository.java:40) > at org.jclouds.jdbc.repository.ContainerRepository.deleteContainerByName(ContainerRepository.java:52) > at org.jclouds.jdbc.service.JdbcService.deleteContainerByName(JdbcService.java:90) > at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:70) > at org.jclouds.jdbc.strategy.JdbcStorageStrategy.deleteContainer(JdbcStorageStrategy.java:167) > at org.jclouds.blobstore.config.LocalBlobStore.deleteAndVerifyContainerGone(LocalBlobStore.java:740) > at org.jclouds.blobstore.config.LocalBlobStore.deleteContainer(LocalBlobStore.java:208) > 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 com.google.inject.internal.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:37) > at com.sun.proxy.$Proxy48.deleteContainer(Unknown Source) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest.deleteContainerOrWarnIfUnable(BaseBlobStoreIntegrationTest.java:188) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest.access$1100(BaseBlobStoreIntegrationTest.java:69) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest$11.run(BaseBlobStoreIntegrationTest.java:514) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet > at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:92) > at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) > at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) > at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) > at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) > at org.hibernate.loader.Loader.doQuery(Loader.java:910) > at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) > at org.hibernate.loader.Loader.doList(Loader.java:2554) > at org.hibernate.loader.Loader.doList(Loader.java:2540) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) > at org.hibernate.loader.Loader.list(Loader.java:2365) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) > at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) > at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) > at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300) > at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) > at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) > at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495) > ... 21 more > Caused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) > at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) > ... 37 more > Caused by: org.hsqldb.HsqlException: transaction rollback: serialization failure > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.Session.executeCompiledStatement(Unknown Source) > at org.hsqldb.Session.execute(Unknown Source) > ... 40 more > javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet > at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) > at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) > at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:524) > at org.jclouds.jdbc.repository.ContainerRepository.findContainerByName(ContainerRepository.java:40) > at org.jclouds.jdbc.service.JdbcService.findContainerByName(JdbcService.java:85) > at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:70) > at org.jclouds.jdbc.strategy.JdbcStorageStrategy.containerExists(JdbcStorageStrategy.java:92) > at org.jclouds.blobstore.config.LocalBlobStore.deleteAndVerifyContainerGone(LocalBlobStore.java:741) > at org.jclouds.blobstore.config.LocalBlobStore.deleteContainer(LocalBlobStore.java:208) > 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 com.google.inject.internal.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:37) > at com.sun.proxy.$Proxy48.deleteContainer(Unknown Source) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest.deleteContainerOrWarnIfUnable(BaseBlobStoreIntegrationTest.java:188) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest.access$1100(BaseBlobStoreIntegrationTest.java:69) > at org.jclouds.blobstore.integration.internal.BaseBlobStoreIntegrationTest$11.run(BaseBlobStoreIntegrationTest.java:514) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet > at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:92) > at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) > at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) > at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) > at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) > at org.hibernate.loader.Loader.doQuery(Loader.java:910) > at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) > at org.hibernate.loader.Loader.doList(Loader.java:2554) > at org.hibernate.loader.Loader.doList(Loader.java:2540) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) > at org.hibernate.loader.Loader.list(Loader.java:2365) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) > at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) > at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) > at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300) > at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) > at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) > at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495) > ... 20 more > Caused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) > at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) > ... 36 more > Caused by: org.hsqldb.HsqlException: transaction rollback: serialization failure > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.Session.executeCompiledStatement(Unknown Source) > at org.hsqldb.Session.execute(Unknown Source) > ... 39 more > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)