2022-04-02 06:24:32,029 [pool-3-thread-48496] WARN org.camunda.bpm.engine.jobexecutor - ENGINE-14006 Exception while executing job 2597564988: 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.insertExecution (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column 'ID_'. ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.insertExecution (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column 'ID_'. java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column 'ID_'. '. Flush summary: [ INSERT HistoricJobLogEventEntity[2597565066] INSERT HistoricActivityInstanceEventEntity[ExclusiveGateway_173is25:2597565048] INSERT HistoricActivityInstanceEventEntity[IntermediateCatchEvent_086y9lj:2597565054] INSERT HistoricActivityInstanceEventEntity[ServiceTask_1w1c5nd:2597565004] INSERT ExecutionEntity[2597565050] INSERT EventSubscriptionEntity[2597565052] DELETE MessageEntity[2597564988] UPDATE ExecutionEntity[2597564979] ] at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationsException(EnginePersistenceLogger.java:693) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:362) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:325) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:297) at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:208) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:137) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:116) at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:46) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:51) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:44) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:92) at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:61) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.insertExecution (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column 'ID_'. ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.insertExecution (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column '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:357) ... 17 common frames omitted Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.insertExecution (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column '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) ... 19 common frames omitted Caused by: java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "ACT_FK_EXE_PARENT". The conflict occurred in database "Activiti", table "App.ACT_RU_EXECUTION", column 'ID_'. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2467) 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) ... 23 common frames omitted