-
Bug Report
-
Resolution: Duplicate
-
L3 - Default
-
None
-
7.10.0
-
None
-
- camunda spring boot 3.2.1
- spring boot 2.1.6.RELEASE
- mssql jdbc 7.2.1.jre11
We got this error with version :
- camunda 7.10
- camunda spring boot 3.2.1
- spring boot 2.1.6.RELEASE
- mssql jdbc 7.2.1.jre11
org.camunda.bpm.engine.ProcessEngineException: ENGINE-03083 Exception while executing Batch Database Operations with message ' ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. '. Flush summary: [ INSERT VariableInstanceEntity[cf5a8013-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5a8016-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5a8018-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5a801a-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5a801c-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5af550-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b1c61-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b1c62-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b1c64-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b1c65-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b6a89-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b6a8f-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b91a0-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b91a1-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b91a3-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5b91a4-91df-11e9-a83e-005056ba6ed3] INSERT VariableInstanceEntity[cf5c54f8-91df-11e9-a83e-005056ba6ed3] INSERT EventSubscriptionEntity[cf5b6a8b-91df-11e9-a83e-005056ba6ed3] INSERT EventSubscriptionEntity[cf5c7c0a-91df-11e9-a83e-005056ba6ed3] DELETE MessageEntity[cf15133a-91df-11e9-a83e-005056ba6ed3] UPDATE VariableInstanceEntity[12898ead-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d707c5-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72ed6-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72ed7-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72eda-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72edc-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72ede-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[11d72ee0-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b6b2e-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b6b2f-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b9241-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b9247-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b9248-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b9249-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7b924a-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[ce7bb95d-91df-11e9-a83e-005056ba6ed3] DELETE VariableInstanceEntity[cf1476f6-91df-11e9-a83e-005056ba6ed3] DELETE ByteArrayEntity[12252768-91df-11e9-a83e-005056ba6ed3] DELETE ByteArrayEntity[ce7c2e92-91df-11e9-a83e-005056ba6ed3] DELETE ByteArrayEntity[ce7c7cb4-91df-11e9-a83e-005056ba6ed3] DELETE_BULK deleteByteArrayNoRevisionCheck cf3c236b-91df-11e9-a83e-005056ba6ed3 UPDATE ExecutionEntity[0e452e87-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[11d72ed8-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[ce7b6b2d-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[ce7af5fb-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[11d8195c-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[11d72ed9-91df-11e9-a83e-005056ba6ed3] DELETE ExecutionEntity[11d6e0b3-91df-11e9-a83e-005056ba6ed3] UPDATE HistoricActivityInstanceEventEntity[11d6e0b4-91df-11e9-a83e-005056ba6ed3] UPDATE HistoricActivityInstanceEventEntity[SubProcess_164wi1g:11d8195d-91df-11e9-a83e-005056ba6ed3] ] at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationsException(EnginePersistenceLogger.java:692) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:361) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:324) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:296) at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:207) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:136) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:115) at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:45) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:43) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:69) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:50) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:43) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:91) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:60) at org.springframework.cloud.sleuth.instrument.async.TraceRunnable.run(TraceRunnable.java:67) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:255) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushOperations(DbSqlSession.java:90) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:356) ... 18 more Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:146) at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114) at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:253) ... 20 more Caused by: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2083) at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:122) ... 24 more
It's a multi-instance call activity without any asynchronous option.
This is the controller panel for Smart Panels app
- duplicates
-
CAM-10126 Database batch processing swallows Optimistic Locking Exception
- Closed