-
Type: Bug
-
Status: Open
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: QualifiedToSchedule
These tests are randomly failing on 7.10:
- org.nuxeo.ecm.core.storage.sql.TestSQLBackend.testDeadlockDetection
- org.nuxeo.ecm.core.storage.sql.TestSQLBackendArrayColumns.testDeadlockDetection
- org.nuxeo.ecm.core.storage.sql.TestSQLBackendNoProxies.testDeadlockDetection
- org.nuxeo.ecm.core.storage.sql.TestSQLBackendSequenceId.testDeadlockDetection
- org.nuxeo.ecm.core.storage.sql.TestSQLBackendSoftDelete.testDeadlockDetection
org.nuxeo.ecm.core.api.NuxeoException: Cannot connect to database: test at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.openConnections(JDBCConnection.java:140) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.connect(JDBCMapper.java:1388) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:65) at com.sun.proxy.$Proxy299.close(Unknown Source) at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.close(SoftRefCachingMapper.java:55) at org.nuxeo.ecm.core.storage.sql.SessionImpl.closeSession(SessionImpl.java:249) at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.closeAllSessions(RepositoryImpl.java:413) at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.close(RepositoryImpl.java:392) at org.nuxeo.ecm.core.storage.sql.SQLBackendTestCase.closeRepository(SQLBackendTestCase.java:120) at org.nuxeo.ecm.core.storage.sql.SQLBackendTestCase.tearDown(SQLBackendTestCase.java:109) 06:14:50,096 [test-1] WARN [GeronimoConnectionEventListener] connectionErrorOccurred called with null java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "misc" ("id", "lifecyclepolicy", "lifecyclestate") VALUES (2, NULL, 's1') was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893) at org.tranql.connector.jdbc.StatementHandle.executeBatch(StatementHandle.java:155) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:561) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:478) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:447) at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doInvoke(JDBCMapperConnector.java:24) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:67) at com.sun.proxy.$Proxy299.write(Unknown Source) at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:352) at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:358) at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:331) at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:310) at org.nuxeo.ecm.core.storage.sql.TestSQLBackend$DeadlockTestJob.job(TestSQLBackend.java:1113) at org.nuxeo.ecm.core.storage.sql.LockStepJob.run(LockStepJob.java:55) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 9367 waits for ShareLock on transaction 282006900; blocked by process 9372. Process 9372 waits for ShareLock on transaction 282006899; blocked by process 9367. Hint: See server log for query details. Where: while inserting index tuple (0,2) in relation "misc_pk" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ... 19 more