delayed_job_active_record
delayed_job_active_record copied to clipboard
Locking raises errors when replicated over MySQL slaves
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.
+1 0.4.4 MySQL 5.5
Bump.