Statement aborted due to ROLLBACK

SQLITE_ABORT_ROLLBACK (516) is an extended result code indicating that a prepared statement was aborted because the transaction it was part of was rolled back. The statement result is invalid and should be discarded.

1. 1Concurrent thread or connection issued ROLLBACK while a statement was executing.
2. 2Application logic rolled back the transaction mid-execution.
3. 3Trigger or ON CONFLICT clause caused an implicit rollback.

Multithreaded or multi-connection SQLite usage with shared transactions.

import sqlite3
conn = sqlite3.connect('test.db', check_same_thread=False)
conn.execute('BEGIN')
conn.execute('CREATE TABLE IF NOT EXISTS t(x)')
conn.execute('INSERT INTO t VALUES(1)')
# From another thread or connection:
conn.execute('ROLLBACK')
# Any pending statement now returns SQLITE_ABORT_ROLLBACK

sqlite3.OperationalError: abort due to ROLLBACK

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