Deadlock detected while waiting for resource

Camunda 7 Topics Discussion & Questions
1

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

2

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

3

Hi @sdorokhova,

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

Thanks,
Sudhanshu

4

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