[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2795) Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY (`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`))

Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY (`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`)) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Key: JBPM-2795 URL: https://jira.jboss.org/browse/JBPM-2795 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Components: Runtime Engine Affects Versions: jBPM 4.3 Environment: windows xp, jdk1.6, mysql5.1 Reporter: vic chen Attachments: com.rar, ExecutionImpl.java Original Estimate: 1 day Remaining Estimate: 1 day when a case like follow: a process and it include three sub-processes(fork), when any one of sub-processes reject, the main process will go to End. it will hit exception:Cannot delete or update a parent row: a foreign key constraint fails like: 11:26:11,727 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY (`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`)) 11:26:11,727 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session it occur due to hibernate's behavior. the code:org.jbpm.pvm.internal.model.ExecutionImpl the method:end|(String state) move "end all child" to bottom but i ain't sure it really been solved.