OXYGENHUB
◆ v0.9.7 oxygenhub / crates / hub / migrations / 0094_job_handback.sql
367 B · SQL · last changed Runners hand jobs back, and the queue takes them first (closes #312, refs andymccall/oxygenflow#76) 10 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 INTEGER;
5
-- How many times; past a few it ends as an error rather than bounce on.
6
ALTER TABLE flow_jobs ADD COLUMN handbacks INTEGER NOT NULL DEFAULT 0;