-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
7.14.0, 7.14.0-alpha4
-
None
Scenario:
1. Use Run with CockroachDB
2. Execute batch operations - set variable to multiple process instances
Observed:
Depending on the number of the process instances there are multiple warnings:
The retries of the jobs are decreased in the db.
2020-09-29 16:41:01.964 WARN 9680 --- [aTaskExecutor-2] org.camunda.bpm.engine.jobexecutor : ENGINE-14006 Exception while executing job cb0ad4d9-0261-11eb-9298-f875a408529c: org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is org.postgresql.util.PSQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=abcceea6 key=/Table/74/1/"cb81d9a7-0261-11eb-9298-f875a408529c"/0 pri=0.02467227 epo=0 ts=1601390457.352877824,1 min=1601390456.971546937,0 seq=60} lock=true stat=PENDING rts=1601390456.971546937,0 wto=false max=1601390456.971546937,0 at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:332) ~[spring-jdbc-5.2.7.RELEASE.jar!/:5.2.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152) ~[spring-tx-5.2.7.RELEASE.jar!/:5.2.7.RELEASE] at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44) ~[camunda-engine-spring-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.interceptor.CrdbTransactionRetryInterceptor.execute(CrdbTransactionRetryInterceptor.java:46) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:57) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:110) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:71) ~[camunda-engine-7.14.0-alpha4-ee.jar!/:7.14.0-alpha4-ee] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na] at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na] Caused by: org.postgresql.util.PSQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=abcceea6 key=/Table/74/1/"cb81d9a7-0261-11eb-9298-f875a408529c"/0 pri=0.02467227 epo=0 ts=1601390457.352877824,1 min=1601390456.971546937,0 seq=60} lock=true stat=PENDING rts=1601390456.971546937,0 wto=false max=1601390456.971546937,0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412) ~[postgresql-42.0.0.jar:42.0.0] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125) ~[postgresql-42.0.0.jar:42.0.0] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297) ~[postgresql-42.0.0.jar:42.0.0] at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:739) ~[postgresql-42.0.0.jar:42.0.0] at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:760) ~[postgresql-42.0.0.jar:42.0.0] at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:387) ~[HikariCP-3.4.5.jar!/:na] at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) ~[HikariCP-3.4.5.jar!/:na] at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:329) ~[spring-jdbc-5.2.7.RELEASE.jar!/:5.2.7.RELEASE] ... 14 common frames omitted
Expected:
A CrdbTransactionRetryException should be reported.
This is the controller panel for Smart Panels app
- causes
-
CAM-12810 LinkageError when starting spring process application on WAS 8.5
- Closed