Distrubuted Lock on Sql Server is Never Released


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.