OXYGENHUB
# b6dfcb61cf5e oxygenhub / crates / hub / migrations-pg / 0094_job_handback.sql
365 B · SQL · last changed Runners hand jobs back, and the queue takes them first (closes #312, refs andymccall/oxygenflow#76) 11 days ago source blame history raw
1
-- Jobs a runner handed back (oxygenflow#76, oxygenhub#312): drained before
2
-- it left, or its lease lapsed. Queued again ahead of new work; NULL if it
3
-- never was.
4
ALTER TABLE flow_jobs ADD COLUMN handed_back_ms BIGINT;
5
-- How many times; past a few it ends as an error rather than bounce on.
6
ALTER TABLE flow_jobs ADD COLUMN handbacks BIGINT NOT NULL DEFAULT 0;