Hi Joram,
I tried to terminate the process instance from flowable admin, the url for the same is as below.
https://dlmoattst.wdf.sap.corp/flowable-ui/admin/#/process-definitions
Terminating a process instance from flowable admin was stuck and was throwing below error.
Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
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_ = ?, IS_ACTIVE_ = ?, SUPER_EXEC_ = ? where ID_ = ? and REV_ = ?
Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
Regards,
Preeti Shirur