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

Oracle/PostgreSQL deadlock on create/delete document

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.7-SNAPSHOT
    • Fix Version/s: 5.8
    • Component/s: Core VCS
    • Environment:
      Oracle

      Description

      selenium test fails when create/delete a workspace

      http://qa.nuxeo.org/jenkins/job/FT-nuxeo-master-selenium-dm-tomcat-multiosdb/Slave=MULTIDB_LINUX,dbprofile=oracle11g/

      the fulltextUpdaterWork try to update the fulltext of document that another request try to delete.

      2013-02-16 02:47:39,114 WARN  [org.nuxeo.ecm.platform.ui.web.restAPI.SystemLogRestlet] ----- Selenium createWSToDelete
      2013-02-16 02:47:51,200 WARN  [org.nuxeo.ecm.platform.ui.web.restAPI.SystemLogRestlet] ----- Selenium deleteWorkspace
      2013-02-16 02:48:03,543 WARN  [org.nuxeo.ecm.platform.ui.web.restAPI.SystemLogRestlet] ----- Selenium verifyDeletedDocumentContent
      2013-02-16 02:48:21,981 WARN  [org.nuxeo.ecm.platform.ui.web.restAPI.SystemLogRestlet] ----- Selenium searchUsers
      2013-02-16 02:48:25,246 WARN  [com.sun.jersey.api.core.ResourceConfig] Class org.nuxeo.opensocial.webengine.gadgets.GadgetStreamWriter is ignored as an instance is registered in the set of singletons
      2013-02-16 02:48:28,923 WARN  [org.nuxeo.ecm.platform.ui.web.restAPI.SystemLogRestlet] ----- Selenium searchGroup
      2013-02-16 02:48:32,618 ERROR [org.nuxeo.ecm.core.work.AbstractWork] Exception during work: FulltextUpdaterWork(RUNNING, Progress(?%, 39/39), Saving)
      org.nuxeo.ecm.core.api.ClientException: Failed to save session
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1866)
      	at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at org.nuxeo.ecm.core.api.TransactionalCoreSessionWrapper.invoke(TransactionalCoreSessionWrapper.java:133)
      	at $Proxy43.save(Unknown Source)
      	at org.nuxeo.ecm.core.storage.sql.FulltextUpdaterWork.work(FulltextUpdaterWork.java:176)
      	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:162)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      	at java.lang.Thread.run(Thread.java:662)
      Caused by: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "FULLTEXT" ("ID", "JOBID", "FULLTEXT", "SIMPLETEXT", "BINARYTEXT", "FULLTEXT_TITLE", "SIMPLETEXT_TITLE", "BINARYTEXT_TITLE", "FULLTEXT_DESCRIPTION", "SIMPLETEXT_DESCRIPTION", "BINARYTEXT_DESCRIPTION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:151)
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1862)
      	... 10 more
      Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "FULLTEXT" ("ID", "JOBID", "FULLTEXT", "SIMPLETEXT", "BINARYTEXT", "FULLTEXT_TITLE", "SIMPLETEXT_TITLE", "BINARYTEXT_TITLE", "FULLTEXT_DESCRIPTION", "SIMPLETEXT_DESCRIPTION", "BINARYTEXT_DESCRIPTION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:597)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:494)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:464)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:466)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:342)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:318)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:301)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.save(ConnectionImpl.java:176)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:149)
      	... 11 more
      Caused by: java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource
      
      	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:582)
      	... 19 more
      Caused by: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10096)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10200)
      	... 21 more
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: