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

OLEs on batch operation execution in Spring boot based applications reduce job retries

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.2, 7.15.0-alpha2, 7.15.0
    • 7.14.0, 7.14.0-alpha4
    • engine
    • 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

              hariharan.parasuraman Hariharan Parasuraman
              yana.vasileva Yana Vasileva
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: