Yoan Bozhilov 0799454a1f fix(taskprocessing): claim tasks atomically with SKIP LOCKED + composite index ...

Replace the worker retry/ignore-list claim-loop with a single atomic
SELECT ... FOR UPDATE SKIP LOCKED claim (SQLite bounded-retry fallback),
preserving the no-duplicate guarantee while removing the thundering-herd
contention that throttled backlog draining. Add a (status,type,last_updated)
index via the table-creating migration + db:add-missing-indices listener.

Signed-off-by: Yoan Bozhilov <bygadd@gmail.com>
Assisted-by: Claude Code:claude-opus-4-8

2026-06-15 16:37:34 +02:00

..

Version13000Date20170705121758.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version13000Date20170718121200.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version13000Date20170814074715.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version13000Date20170919121250.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version13000Date20170926101637.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180129121024.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180404140050.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180516101403.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180518120534.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180522074438.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180710092004.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version14000Date20180712153140.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version15000Date20180926101451.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version15000Date20181015062942.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version15000Date20181029084625.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version16000Date20190207141427.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version16000Date20190212081545.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version16000Date20190427105638.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version16000Date20190428150708.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version17000Date20190514105811.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version18000Date20190920085628.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version18000Date20191014105105.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version18000Date20191204114856.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version19000Date20200211083441.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version20000Date20201109081915.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version20000Date20201109081918.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version20000Date20201109081919.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version20000Date20201111081915.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version21000Date20201120141228.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version21000Date20201202095923.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version21000Date20210119195004.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version21000Date20210309185126.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version21000Date20210309185127.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version22000Date20210216080825.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version23000Date20210721100600.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version23000Date20210906132259.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version23000Date20210930122352.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version23000Date20211203110726.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version23000Date20211213203940.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20211210141942.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20211213081506.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20211213081604.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20211222112246.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20211230140012.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20220131153041.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version24000Date20220202150027.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version24000Date20220404230027.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version24000Date20220425072957.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version25000Date20220515204012.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version25000Date20220602190540.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version25000Date20220905140840.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version25000Date20221007010957.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version27000Date20220613163520.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version27000Date20230309104325.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version27000Date20230309104802.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20230616104802.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20230728104802.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20230803221055.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20230906104802.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20231004103301.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20231103104802.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version28000Date20231126110901.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version28000Date20240828142927.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version29000Date20231126110901.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version29000Date20231213104850.php

refactor(psalm): Modernize migration doc

2026-02-12 11:25:55 +01:00

Version29000Date20240124132201.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version29000Date20240124132202.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version29000Date20240131122720.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version30000Date20240429122720.php

fix(taskprocessing): claim tasks atomically with SKIP LOCKED + composite index

2026-06-15 16:37:34 +02:00

Version30000Date20240708160048.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version30000Date20240717111406.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version30000Date20240814180800.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version30000Date20240815080800.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version30000Date20240906095113.php

refactor(psalm): Modernize migration doc

2026-02-12 11:25:55 +01:00

Version31000Date20240101084401.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version31000Date20240814184402.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version31000Date20250213102442.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version32000Date20250620081925.php

feat(migration-attributes): add DataCleansing

2025-09-03 13:32:40 -01:00

Version32000Date20250731062008.php

refactor(psalm): Modernize migration doc

2026-02-12 11:25:55 +01:00

Version32000Date20250806110519.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20250819110529.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251013110519.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251023110529.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251023120529.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251106131209.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251124110529.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251126152410.php

chore: Apply new coding standard to all files

2026-06-01 13:46:39 +02:00

Version33000Date20251209123503.php

perf: swap around root_id and mount_path_hash in index

2026-04-23 14:13:58 +02:00

Version33000Date20260126120000.php

chore: add missing Override attribute to core code

2026-04-28 21:29:28 +02:00

Version34000Date20260318095645.php

fix(bg_jobs): store job argument as a text, increase length cap from 4000 to 32000

2026-03-18 15:50:38 +01:00

Version34000Date20260415161745.php

perf: swap around root_id and mount_path_hash in index

2026-04-23 14:13:58 +02:00

Version34000Date20260518163022.php

fix(db): ensure no autoincrement for Oracle

2026-05-29 09:14:49 +02:00

Version34000Date20260521110333.php

fix(db): ensure no autoincrement for Oracle

2026-05-29 09:14:49 +02:00

Version35000Date20260527162338.php

feat(task-streaming): set preferStreaming default value to false, allow setting it with the OCS API

2026-06-12 10:34:11 +02:00