I’m looking for a way to manually clear the lock_owner_ and lock_exp_time_ from act_ru_job for a particular lock_owner_. Is this possible with the ProcessEngine or the ManagementService? I did not find a command which clears them. The “ClearProcessInstanceLockTimesCmd” command only clears the process lock_owner and time from act_ru_execution but the jobs are still locked in act_ru_job.
The main issue is that when a flowable engine crashes the lock is not cleared and another async executor will execute the job when the lock_time expires, but in our case, this is 30 minutes. It is not really possible to lower this value because there are jobs that may run for around 30 minutes.
Currently, we have a logic that runs “ClearProcessInstanceLockTimesCmd” when a flowable engine (app instance - it is running on Cloud Foundry) crashes, but this is not enough to unlock the job because this command does not remove the lock_owners from act_ru_job.
Basically, I’m looking for the equivalent of the following query that is implemented by a Command that can be executed from the processEngine, because we want to refrain from using jdbc:
update act_ru_job set lock_owner_ = null, lock_exp_time_ = null where lock_onwer_ = ?;