Lock In Lab Intern, rank 1 of 9

INC-05 sev 2 5 Sep 2026, filed under Builder

437 rows processed, zero results saved

What we saw

A batch job ran an AI check over 437 rows. The stats said 437 verdicts written. The database had none.

How we found it

Writing a row, then reading it back from a separate database session. The value wasn't there.

Cause

A JSON column was reassigned after a call that committed internally. The ORM didn't see the change as a change, so it issued no UPDATE. Nothing errored.

Fix

Explicitly marked the column as modified before committing (in SQLAlchemy, flag_modified).

The rule now

Verify by writing and re-reading from another session, not by reasoning and not by trusting your own counters.