Hi Team,
We are using Camunda 7.6 enterprise edition, with Oracle DB (Which supports READ COMMITTED ).
Now we are facing this exception: (Any suggestion is appreciated )
org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘DELETE ByteArrayEntity[f6a5d7b8-00e3-11e8-8ca1-0050568f08d2]’ with message ’
Error updating database. Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
The error may involve org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.deleteByteArray-Inline
The error occurred while setting parameters
SQL: delete from ACT_GE_BYTEARRAY where ID_ = ? and REV_ = ?
Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
'. Flush summary:
[
INSERT HistoricVariableInstanceEntity[07564e10-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[0758980a-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[0758bf1c-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[0758bf1e-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[0758bf20-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[075a93e8-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[075abafb-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[075abaff-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[07787c3a-00e4-11e8-8ca1-0050568f08d2]
INSERT HistoricVariableInstanceEntity[07791780-00e4-11e8-8ca1-0050568f08d2]
Thanks,
Sudhanshu