Process 16117 waits for ShareLock on transaction 620143457; blocked by process 16129. Hint: See server log for query details. Where: while updating tuple (4,44) in relation “act_ru_execution”### The error may exist in org/flowable/db/mapping/entity/Execution.xml### The error may involve org.flowable.engine.impl.persistence.entity.ExecutionEntityImpl.updateExecution-Inline
The error occurred while setting parameters
SQL: update ACT_RU_EXECUTION SET REV_ = ? where ID_ = ? and REV_ = ?
Cause: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 16129 waits for ShareLock on transaction 618845631; blocked by process 16117.
This is an intermediate issue, process seems to be getting launched but when trying to complete a task under the process, error: no process instance found… any reason/ workaround for this issue?
After restart of service, new workflows started to work, but the old which were created during this deadlock are in bad state, no action can be done on that… how can we delete/cancle those??