-
Task
-
Resolution: Won't Fix
-
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]