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

Fix ITRemoteAutomationClientTest.testGetBlobs on h2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 9.2-SNAPSHOT
    • Fix Version/s: 2023.14, 2021.56
    • Component/s: Core

      Description

      ITRemoteAutomationClientTest.testGetBlobs fails randomly on h2 with this error:

      Timeout trying to lock table ; SQL statement:
      UPDATE "HIERARCHY" SET "SYSTEMCHANGETOKEN" = "SYSTEMCHANGETOKEN" + ? WHERE "ID" = ? 
      
      Tests run: 18, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 21.896 sec <<< FAILURE! - in org.nuxeo.ftest.server.ITRemoteAutomationClientTest
      testGetBlobs(org.nuxeo.ftest.server.ITRemoteAutomationClientTest)  Time elapsed: 6.11 sec  <<< ERROR!
      org.nuxeo.ecm.automation.client.RemoteException: Failed to invoke operation: Blob.AttachOnDocument
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.marshallers.ExceptionMarshaller._read(ExceptionMarshaller.java:83)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.marshallers.ExceptionMarshaller.readException(ExceptionMarshaller.java:49)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.Request.handleException(Request.java:215)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.Request.handleResult(Request.java:126)
      	at org.nuxeo.ecm.automation.client.jaxrs.impl.HttpConnector.execute(HttpConnector.java:143)
      	at org.nuxeo.ecm.automation.client.jaxrs.impl.HttpConnector.execute(HttpConnector.java:125)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.ConnectorHandler.execute(ConnectorHandler.java:37)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.DefaultSession.execute(DefaultSession.java:119)
      	at org.nuxeo.ecm.automation.client.jaxrs.spi.DefaultOperationRequest.execute(DefaultOperationRequest.java:174)
      	at org.nuxeo.ecm.automation.server.test.AbstractAutomationClientTest.testGetBlobs(AbstractAutomationClientTest.java:472)
      Caused by: org.nuxeo.ecm.automation.client.RemoteThrowable: Failed to invoke operation Blob.AttachOnDocument with aliases [Blob.Attach]
      	at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:188)
      	at org.nuxeo.ecm.automation.core.impl.OperationChainCompiler$OperationMethod.invoke(OperationChainCompiler.java:128)
      	at org.nuxeo.ecm.automation.core.impl.OperationChainCompiler$CompiledChainImpl.invoke(OperationChainCompiler.java:196)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:119)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:107)
      	at org.nuxeo.ecm.automation.server.jaxrs.OperationResource.execute(OperationResource.java:58)
      	at org.nuxeo.ecm.automation.server.jaxrs.ExecutableResource.doPost(ExecutableResource.java:71)
      Caused by: org.nuxeo.ecm.automation.client.RemoteThrowable: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table ; SQL statement:
      UPDATE "HIERARCHY" SET "SYSTEMCHANGETOKEN" = "SYSTEMCHANGETOKEN" + ? WHERE "ID" = ? [50200-177]
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.checkConcurrentUpdate(JDBCConnection.java:184)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.updateSimpleRows(JDBCRowMapper.java:667)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeUpdates(JDBCRowMapper.java:493)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:447)
      	at sun.reflect.GeneratedMethodAccessor51.invoke(null)
      	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:52)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.lambda$doConnectAndInvoke$0(JDBCMapperConnector.java:101)
      	at org.nuxeo.runtime.transaction.TransactionHelper.runInTransaction(TransactionHelper.java:589)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doConnectAndInvoke(JDBCMapperConnector.java:97)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:92)
      	at com.sun.proxy.$Proxy64.write(null)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:360)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:369)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:342)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.checkIn(SessionImpl.java:1150)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.checkIn(ConnectionImpl.java:284)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.checkIn(SQLSession.java:607)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLDocumentLive.checkIn(SQLDocumentLive.java:452)
      	at org.nuxeo.ecm.core.versioning.StandardVersioningService.doCheckIn(StandardVersioningService.java:339)
      	at org.nuxeo.ecm.core.versioning.VersioningComponent.doCheckIn(VersioningComponent.java:430)
      	at org.nuxeo.ecm.core.api.AbstractSession.checkIn(AbstractSession.java:1784)
      	at org.nuxeo.ecm.core.api.impl.DocumentModelImpl.checkIn(DocumentModelImpl.java:684)
      	at org.nuxeo.ecm.core.versioning.StandardVersioningService.doAutomaticVersioning(StandardVersioningService.java:482)
      	at org.nuxeo.ecm.core.versioning.VersioningComponent.doAutomaticVersioning(VersioningComponent.java:440)
      	at org.nuxeo.ecm.core.api.AbstractSession.saveDocument(AbstractSession.java:1595)
      	at org.nuxeo.ecm.automation.core.operations.blob.AttachBlob.run(AttachBlob.java:58)
      
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: