Deadlock detected while waiting for resource

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 :slight_smile: )

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

Hi Sudhanshu,

which specific patch version of Camunda are you using? (I mean the third number in 7.6.?)

Also, as you’re the enterprise customers, you can consider opening support ticket in our Jira.

Regards,
Svetlana

Hi @sdorokhova,

We are using Camunda 7.6.2. Is there any changes after this release??

Thanks,
Sudhanshu

Hi @Sudhanshu_Sekhar,

it’s better that you update to the latest available patch version. Specifically in your case, the problem can be related to this issue: https://app.camunda.com/jira/browse/CAM-7263