Activiti/mybatis - нарушение ограничения иностранного ключа при удалении процесса выполнения ⇐ JAVA

[Anonymous]

Я работаю с Activit. Я столкнулся с нарушением ограничения иностранного ключа при попытке выполнить задачу. < /P>
Вот ошибка, которую я вижу: < /p>
o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=49) Cannot delete or update a parent row: a foreign key constraint fails (`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`))
### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=49) Cannot delete or update a parent row: a foreign key constraint fails (`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`))] with root cause
java.sql.SQLException: Cannot delete or update a parent row: a foreign key constraint fails (`gsm_activitip`.`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`))
Query is: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?, parameters ['xxxx',x]
< /code>
Version :
Java : 1.8
Activity dependency :

org.activiti
activiti-spring-boot-starter-basic
5.21.0

< /code>
This issue occurred for only one approval. We have two levels of approvals. The request was submitted for approval in 2019. In 2024, the first level was approved, but when I try to complete the second-level approval, I get this issue. Can someone please help. Thank you.

Подробнее здесь: https://stackoverflow.com/questions/794 ... ess-execut