Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-21928

Fix 7.10 test testDeadlockDetection

    XMLWordPrintable

    Details

    • Tags:
    • Sprint:
      nxFG 9.1.9, nxFG 9.1.10
    • Story Points:
      1

      Description

      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
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day
                1d