delayed_job_active_record icon indicating copy to clipboard operation
delayed_job_active_record copied to clipboard

Locking raises errors when replicated over MySQL slaves

Open bradwright opened this issue 11 years ago • 2 comments

We're getting loads of things like this in our MySQL master/slave setup:

130731 13:14:46 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `delayed_jobs` SET `locked_at` = '2013-07-31 13:14:46', `locked_by` = 'host:server-1 pid:14412' WHERE ((run_at <= '2013-07-31 13:14:46' AND (locked_at IS NULL OR locked_at < '2013-07-31 09:14:46') OR locked_by = 'host:server-1 pid:14412') AND failed_at IS NULL) ORDER BY priority ASC, run_at ASC LIMIT 1

which appears to be the same error as raised in collectiveidea/delayed_job#219. We're using 0.4.4 but the same code appears in the latest version.

bradwright avatar Jul 31 '13 13:07 bradwright

+1 0.4.4 MySQL 5.5

palexvs avatar Aug 11 '13 20:08 palexvs

Bump.

bradwright avatar Sep 20 '13 15:09 bradwright