We started seeing a foreign-key constraint error when sending Messages to the REST API. The message triggers a Task boundary event which will complete the Task.
Here is the message:
{"type": "ProcessEngineException", "message": "ENGINE-03083 Exception while executing Batch Database Operations with message ‘\n### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #15) failed. 14 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (process_engine.ACT_RU_TASK, CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES ACT_RU_EXECUTION (ID_))[\n###](file://n%23%23%23) Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #15) failed. 14 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (process_engine.ACT_RU_TASK, CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES ACT_RU_EXECUTION (ID_))[\njava.sql.BatchUpdateException](file://njava.sql.BatchUpdateException): Cannot delete or update a parent row: a foreign key constraint fails (process_engine.ACT_RU_TASK, CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES ACT_RU_EXECUTION (ID_))[\ncom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException](file://ncom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException): Cannot delete or update a parent row: a foreign key constraint fails (process_engine.ACT_RU_TASK, CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES ACT_RU_EXECUTION (ID_))[\n](file://n)’. Flush summary: [\n](file://n) [\n INSERT HistoricJobLogEventEntity[c7aaf5c0-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c5026ac7-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c502dff8-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c5032e19-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c503a34a-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c503f16b-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c7a7e878-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricVariableUpdateEventEntity[c7a85da9-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionOutputInstanceEntity[c7a7e876-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionOutputInstanceEntity[c7a7e877-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInstanceEntity[c7a7e870-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInputInstanceEntity[c7a7e871-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInputInstanceEntity[c7a7e872-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInputInstanceEntity[c7a7e873-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInputInstanceEntity[c7a7e874-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricDecisionInputInstanceEntity[c7a7e875-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricActivityInstanceEventEntity[BoundaryEvent_03gr5jb:c7aa326a-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT HistoricActivityInstanceEventEntity[WaitingForAssignmentTimeout:c7aaa79e-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT ExecutionEntity[c7aaa79b-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT TimerEntity[c7aaf5bf-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT EventSubscriptionEntity[c7aaa79c-b85d-11e9-a609-0242c0a84201][\n](file://n) INSERT EventSubscriptionEntity[c7aaa79d-b85d-11e9-a609-0242c0a84201][\n](file://n) DELETE EventSubscriptionEntity[2580116a-b85d-11e9-a609-0242c0a84201][\n](file://n) UPDATE VariableInstanceEntity[6a2bfb84-b85c-11e9-a609-0242c0a84201][\n](file://n) UPDATE VariableInstanceEntity[6a2bfb86-b85c-11e9-a609-0242c0a84201][\n](file://n) UPDATE VariableInstanceEntity[6ab3540c-b85c-11e9-a609-0242c0a84201][\n](file://n) UPDATE VariableInstanceEntity[6ab3540e-b85c-11e9-a609-0242c0a84201][\n](file://n) UPDATE VariableInstanceEntity[9b0ccc5f-b85c-11e9-a609-0242c0a84201][\n](file://n) DELETE VariableInstanceEntity[25bd8fa5-b85d-11e9-a609-0242c0a84201][\n](file://n) DELETE VariableInstanceEntity[25bdb6b7-b85d-11e9-a609-0242c0a84201][\n](file://n) DELETE VariableInstanceEntity[777cd5e6-b85d-11e9-a609-0242c0a84201][\n](file://n) DELETE TaskEntity[2580116c-b85d-11e9-a609-0242c0a84201][\n](file://n) UPDATE ExecutionEntity[6a2bd465-b85c-11e9-a609-0242c0a84201][\n](file://n) DELETE ExecutionEntity[25801169-b85d-11e9-a609-0242c0a84201][\n](file://n) UPDATE HistoricActivityInstanceEventEntity[ManuallyAssignTimeout:2580116b-b85d-11e9-a609-0242c0a84201][\n](file://n) UPDATE HistoricTaskInstanceEventEntity[2580116c-b85d-11e9-a609-0242c0a84201][\n](file://n) DELETE_BULK deleteAuthorizationsForResourceId {resourceId=2580116c-b85d-11e9-a609-0242c0a84201, resourceType=7}\n UPDATE HistoricVariableInstanceEntity[25bdb6b7-b85d-11e9-a609-0242c0a84201][\n](file://n) UPDATE HistoricVariableInstanceEntity[6ab3540e-b85c-11e9-a609-0242c0a84201][\n](file://n) UPDATE HistoricVariableInstanceEntity[9b0ccc5f-b85c-11e9-a609-0242c0a84201][\n]"}](file://n]%22%7d)