search

flowable / flowable-engine

A compact and highly efficient workflow and Business Process Management (BPM) platform for developers, system admins and business users.
https://www.flowable.org
Apache License 2.0
7.91k stars 2.61k forks source link

flowable 6.4.0 Oracle ExecutionEntityImpl.deleteExecution-Inline ORA-02292 #1962

Open daitianci opened 5 years ago

daitianci commented 5 years ago

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (CICRO.FK8A82499F4C67C41) violated - child record found (XXX.SYS_C0047638)

The error may involve org.flowable.engine.impl.persistence.entity.ExecutionEntityImpl.deleteExecution-Inline

The error occurred while setting parameters

SQL: delete from ACT_RUEXECUTION where ID = ? and REV_ = ?

Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (CICRO.FK8A82499F4C67C41) violated - child record found (XXX.SYS_C0047638)

daitianci commented 5 years ago

SYS_C0047638 is table ACT_RU_VARIABLE keys ,type Foreign,colums EXECUTIONID

tijsrademakers commented 5 years ago

Did you reproduce this with Flowable 6.4.2 as well? If so, can you explain in which context you are receiving this exception? Are you able to reproduce it in a unit test?

daitianci commented 5 years ago

Did you reproduce this with Flowable 6.4.2 as well? If so, can you explain in which context you are receiving this exception? Are you able to reproduce it in a unit test?

thank you for your help. we use loadrunner to simulate varying concurrent user load.this situation can not be reproduce in a unit test.It will be reproduce by loadrunner.I'm worried about this kind of mistake when concurrency is high.

tijsrademakers commented 5 years ago

Yes I understand, but please describe what you are testing in Loadrunner exactly, and at which point this exception is happening.