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.