3 ms·

orphan_jobs.sql: SELECT job_id FROM `{{.JobQueue}}` WHERE status = 'grabbed' AND grabber_id != CONNECTION_ID() LIMIT 1000 can it break when MySQL's th

by mtve 9y ago

orphan_jobs.sql: SELECT job_id FROM `{{.JobQueue}}` WHERE status = 'grabbed' AND grabber_id != CONNECTION_ID() LIMIT 1000 can it break when MySQL's thread ID is reused, and some new client will get the same CONNECTION_ID as a previous failed worker?