Cannot delete a row required by a rowid scan

SQLITE_CONSTRAINT_PINNED (2835) is returned when an attempt is made to DELETE a row while the row is "pinned" by a recursive trigger or a row value change that is being processed.

1. 1Recursive trigger scenario where a trigger attempts to delete a row that is currently being iterated.
2. 2Row is pinned by an ongoing UPDATE and cannot be deleted simultaneously.

Complex trigger chains involving DELETE on rows that are concurrently being modified.

-- A recursive trigger that tries to delete the triggering row
-- SQLite protects against this with SQLITE_CONSTRAINT_PINNED

sqlite3.IntegrityError: constraint failed

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev