Hello we are facing the same issues.
We found that some SQL processes in Orchestrator MS SQL database are sleeping and locking tables/rows.
We have temporary fixed problem by manually killing blocking process, but the issue reappeared.
The first time we have found UPDATE statement which was blocking other processes
(@state nvarchar(6),@jobName nvarchar(26),@jobGroup nvarchar(21),@oldState nvarchar(14))UPDATE quartz.QRTZ_TRIGGERS SET TRIGGER_STATE = @state WHERE SCHED_NAME = 'UiPathQuartzSchedulerSystem' AND JOB_NAME = @jobName AND JOB_GROUP = @jobGroup AND TRIGGER_STATE = @oldState
Second time we found this statement
(@lockName nvarchar(14))SELECT * FROM quartz.QRTZ_LOCKS WITH (UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'UiPathQuartzSchedulerSystem' AND LOCK_NAME = @lockName
Any ideas why it might happen?