I would like to ask is it possible somehow to set limit to resets of one expired flowable job? I am asking this because I have issues sometimes when service task from bpmn diagram runs longer than already defined lock time of async job excetuor(30 minutes). When locktime expires, reset expired jobs thread detect this expired job and reschedule it again and another job acquisition thread acquire this job and try to re-execute it again which I would like to avoid. Another issue which I notice is slow running service task hold db locks in database(PostgreSQL) and rescheduled job is blocked and can’t continue with the execution due to blocked SQL query
update ACT_RU_EXECUTION set LOCK_TIME_ = $1 where ID_ = $2 and (LOCK_TIME_ is null OR LOCK_TIME_ < $3) , this issue after several expired jobs leads to increase in db locks. I have plan to refactor this service task but I would like to ask you is there any generic solutions of this problem.