What does HRESULT 0x87AF0204 (SQLITE_E_ABORT_ROLLBACK) mean?

SQLITE_E_ABORT_ROLLBACK

SQLITE_E_ABORT_ROLLBACK is the extended SQLite abort result returned when another operation rolls back the transaction containing an active statement.

What to check for SQLITE_E_ABORT_ROLLBACK

• Find the code path that issued ROLLBACK or caused the transaction to fail before the active statement completed.
• Keep transaction ownership clear; unrelated request handlers should not share a transaction or connection without synchronization.
• Retry only after rebuilding the transaction from a known-safe application state.

PRAGMA data_version;

SQLite: Result and Error Codes

SQLite: PRAGMA statements

Diagnostic discriminator: Correlate the active statement with the transaction rollback that occurred concurrently. This extended result specifically ties SQLITE_ABORT to rollback invalidating the statement.