selenium test fails when create/delete a workspace
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
- duplicates
-
NXP-12930 Improve concurrent update detection and behavior
- Resolved