MySQL Deadlock issue

[jamsi]

Hi folks,

Two years ago there was an issue with workers dying due to a mysql race condition aka #277 .. however I'm starting to see this issue in my delayed_jobs.log - luckily I have bluepill restarting workers when they fall over but has anyone got a solution for this? A few others in that #277 issue have expressed concern also.

This is using 3.0.5

Class#notification failed with ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `delayed_jobs` WHERE `delayed_jobs`.`id` = 648922 - 0 failed attempts

[albus522]

This will actually be an issue with https://github.com/collectiveidea/delayed_job_active_record. Please move any discussion there and make sure you are using the latest version of that gem.

[gorism]

I opened collectiveidea/delayed_job_active_record#63 to track the issue with https://github.com/collectiveidea/delayed_job_active_record