Locking raises errors when replicated over MySQL slaves #69

bradwright opened this Issue Jul 31, 2013 · 2 comments

2 participants


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.


MySQL 5.5



@bradwright bradwright referenced this issue in alphagov/signonotron2 Jan 8, 2014

[Discuss] Use sidekiq instead of delayed job #145

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment