1. The schema the guards depend on ok job.dedupe_key exists ok publish_attempt.unresolved exists ok publish_attempt.released exists ok article.image_error exists ok job.dedupe_key carries a UNIQUE index, not just an index 2. pushUnique is enforced by the database, not only by the SELECT ok the first push is accepted ok the second push is declined ok exactly one job exists for the key ok a racing INSERT is refused by the index 3. A finished job releases its claim ok complete() nulls the dedupe key ok the same work can be queued again afterwards 4. A stale key from an older version is repaired, not fatal ok the work is queued rather than silently refused forever ok the stale row gave up its key 5. A job that exceeded its attempts is retired ok it is marked failed rather than looping ok and it lets go of its key so the work can be re-queued 6. Editing an approved article withdraws the approval ok the status falls back to in_review ok reviewed_by is cleared despite status being reassigned in the same statement ok reviewed_at is cleared too 7. The publish claim is atomic ok the first claim wins ok the second claim loses ok the article is left in publishing 8. A delivered request blocks a second send ok nothing blocks a first publish ok an unresolved attempt blocks the next one ok a plain rejection does not block ok a successful attempt blocks a second publish 9. Releasing a block keeps the evidence ok one attempt was released ok and it no longer blocks ok the CMS response is preserved, not rewritten ok the release is recorded ok the message says who released it ok releasing again changes nothing 10. Manual competitor classifications survive a re-analysis ok the human classification survived ok and is still marked manual ok while the metrics were refreshed Search Console URL normalisation ok PHP and MySQL normalise every URL identically ok four spellings of one URL produce one key ok stale performance rows are deleted on refresh ok every row in a run carries the same stamp so staleness is detectable An edit cannot be lost to an in-flight publish ok the save route refuses a publish in progress ok the save route refuses an article still being written ok the edit form is hidden in exactly those states 41 passed, 0 failed