Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-13971

HistoricIncidentQueryTest#testQueryByInvalidActivityId failed on stage old-engine-mariadb-galera on 7.15 CE daily pipeline

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • None

      org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest#testQueryByInvalidActivityId on stage old-engine-mariadb-galera on 7.15 CE daily pipeline:

      [2021-09-17T02:00:47.049Z] [ERROR] Tests run: 40, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 239.382 s <<< FAILURE! - in org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest
      [2021-09-17T02:00:47.049Z] [ERROR] testQueryByInvalidActivityId(org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest)  Time elapsed: 88.678 s  <<< ERROR!
      [2021-09-17T02:00:47.049Z] org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:257)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.executeSelectList(DbSqlSession.java:107)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:99)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:182)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:174)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:166)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findJobsByQueryCriteria(JobManager.java:259)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.JobQueryImpl.executeList(JobQueryImpl.java:355)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.util.ProcessEngineTestRule.executeAvailableJobs(ProcessEngineTestRule.java:280)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.util.ProcessEngineTestRule.executeAvailableJobs(ProcessEngineTestRule.java:255)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest.startProcessInstances(HistoricIncidentQueryTest.java:734)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest.startProcessInstance(HistoricIncidentQueryTest.java:723)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.history.HistoricIncidentQueryTest.testQueryByInvalidActivityId(HistoricIncidentQueryTest.java:374)
      [2021-09-17T02:00:47.049Z] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [2021-09-17T02:00:47.049Z] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      [2021-09-17T02:00:47.049Z] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      [2021-09-17T02:00:47.049Z] 	at java.lang.reflect.Method.invoke(Method.java:498)
      [2021-09-17T02:00:47.049Z] 	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
      [2021-09-17T02:00:47.049Z] 	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
      [2021-09-17T02:00:47.049Z] 	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
      [2021-09-17T02:00:47.049Z] 	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
      [2021-09-17T02:00:47.049Z] 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
      [2021-09-17T02:00:47.049Z] 	at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
      [2021-09-17T02:00:47.049Z] 	at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
      [2021-09-17T02:00:47.049Z] 	at org.camunda.bpm.engine.test.ProcessEngineRule$1.evaluate(ProcessEngineRule.java:172)
      [2021-09-17T02:00:47.049Z] 	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
      [2021-09-17T02:00:47.049Z] 	at org.junit.rules.ExpectedException$ExpectedExceptionStatement.evaluate(ExpectedException.java:258)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      [2021-09-17T02:00:47.050Z] 	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
      [2021-09-17T02:00:47.050Z] 	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
      [2021-09-17T02:00:47.050Z] Caused by: org.apache.ibatis.exceptions.PersistenceException: 
      [2021-09-17T02:00:47.050Z] ### Error querying database.  Cause: java.sql.SQLException: (conn:6) Lock wait timeout exceeded; try restarting transaction
      [2021-09-17T02:00:47.050Z] ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
      [2021-09-17T02:00:47.050Z] ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectJobByQueryCriteria-Inline
      [2021-09-17T02:00:47.050Z] ### The error occurred while setting parameters
      [2021-09-17T02:00:47.050Z] ### SQL: select distinct RES.*                from ACT_RU_JOB RES                  WHERE  RES.RETRIES_ > 0          order by RES.ID_ asc     LIMIT ? OFFSET ?
      [2021-09-17T02:00:47.050Z] ### Cause: java.sql.SQLException: (conn:6) Lock wait timeout exceeded; try restarting transaction
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
      [2021-09-17T02:00:47.050Z] 	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$executeSelectList$1(DbSqlSession.java:107)
      [2021-09-17T02:00:47.050Z] 	at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:254)
      [2021-09-17T02:00:47.050Z] 	... 55 more
      [2021-09-17T02:00:47.050Z] Caused by: java.sql.SQLException: (conn:6) Lock wait timeout exceeded; try restarting transaction
      [2021-09-17T02:00:47.050Z] 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:179)
      [2021-09-17T02:00:47.050Z] 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
      [2021-09-17T02:00:47.050Z] 	at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:247)
      [2021-09-17T02:00:47.050Z] 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
      [2021-09-17T02:00:47.050Z] 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:153)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
      [2021-09-17T02:00:47.050Z] 	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
      [2021-09-17T02:00:47.050Z] 	... 58 more
      [2021-09-17T02:00:47.050Z] Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
      [2021-09-17T02:00:47.050Z] Query is: select distinct RES.*
      [2021-09-17T02:00:47.051Z]     
      [2021-09-17T02:00:47.051Z]      
      [2021-09-17T02:00:47.051Z]     from ACT_RU_JOB RES
      [2021-09-17T02:00:47.051Z]      
      [2021-09-17T02:00:47.051Z]      
      [2021-09-17T02:00:47.051Z]      WHERE  RES.RETRIES_ > 0 
      [2021-09-17T02:00:47.051Z]    
      [2021-09-17T02:00:47.051Z]     order by RES.ID_ asc
      [2021-09-17T02:00:47.051Z]     LIMIT ? OFFSET ?, parameters [2147483647,0]
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:145)
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:222)
      [2021-09-17T02:00:47.051Z] 	at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
      [2021-09-17T02:00:47.051Z] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      [2021-09-17T02:00:47.051Z] 	at java.lang.reflect.Method.invoke(Method.java:498)
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.internal.failover.AbstractMastersListener.invoke(AbstractMastersListener.java:361)
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.internal.failover.FailoverProxy.executeInvocation(FailoverProxy.java:216)
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.internal.failover.FailoverProxy.invoke(FailoverProxy.java:209)
      [2021-09-17T02:00:47.051Z] 	at com.sun.proxy.$Proxy20.executeQuery(Unknown Source)
      [2021-09-17T02:00:47.051Z] 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:212)
      [2021-09-17T02:00:47.051Z] 	... 67 more
      [2021-09-17T02:00:47.051Z] 
      

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              tassilo.weidner Tassilo Weidner
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: