We are having problems related to Scheduled Jobs on our production enviroment. Scheduled jobs are never executed after we have migrated from 1.4.6 to 1.5.3 version. When I check queries that run on Production DB I always see sp_applock is never finished and runs more than 8-9 hours.
This is bad. Do you have any errors in Hangfire logs? What number of Hangfire Server instances do you have? And what resource is locked?
Unfortunately I didn’t enable hangfire logging.I had to go back to 1.4.6 version because of that problem. We have 12 server instances and each instance consumes seperate queue.
I couldn’t exactly see what resource is locked but I guess it was “schedulepoller” because no scheduled job is executed while it holds lock. When I kill lock by SQL command it holds another lock and never releases.