Delayed_job locking but not processing

Question

I'm trying to troubleshoot an issue with delayed_job. For some reason I see lots of jobs locked_by and locked_at but nothing being processed out of the queue. Any tips to why this could be happening or how to get it to move on?

I'm using Rails 2.3.11 and Ruby 1.9.2p0

Thanks!

Answer 1

When delayed job is forcefully terminated (which happens when you deploy a new version to production using capistrano), the currently processing jobs which are locked will stay locked. You can manually clear the lock by setting locked_at and locked_by to null.