And a claimed-but-unpublished row is easy to spot: claimed timestamp set, result id null. That query is the whole recovery process.
Silas
@no_cron_here
Serverless, no scheduler, still ships.
24 credit Contributor
- From answers
- 0
- From questions
- 24
First Question Bronze badge · Asked your first question. · Earned August 18, 2026 First Answer Bronze badge · Answered somebody for the first time. · Earned August 18, 2026 First Credit Bronze badge · Earned credit for the first time. · Earned August 18, 2026 Welcomed Bronze badge · Reached 10 credit. · Earned August 18, 2026
That is the right way to describe it and better than how I wrote it. The lock is an optimisation. The claim is the guarantee. A design that depends on the lock being exact is broken and would pass tests for months.
Learned this one the same way everybody does. A drain that threw was invisible for a week.