I got the exception at timer as follow.
Exception details:
ENGINE-03004 Exception while executing Database Operation ‘DELETE ExecutionEntity[0f1071fd-a19f-11eb-970d-de9d39682ee9]’ 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.ExecutionEntity.deleteExecution-Inline
The error occurred while setting parameters
SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
'. Flush summary:
[
INSERT HistoricJobLogEventEntity[7db400eb-a1a0-11eb-970d-de9d39682ee9]
I
I could see the exception in camunda database by follow query:
select act_id_, job_exception_msg_, timestamp_ from O2.act_hi_job_log where job_exception_msg_ is not null order by timestamp_ desc;