EC
SQLITE_IOERR_COMMIT_ATOMIC
SQLiteFATALCriticalI/O Errorofficial confidence

I/O error committing atomic write

Production Risk

Critical — transaction durability cannot be guaranteed.

What this means

SQLITE_IOERR_COMMIT_ATOMIC (7690) is returned when the VFS cannot complete an atomic commit. The transaction is not durable and the database may need recovery.

Why it happens
  1. 1Hardware failure during atomic commit phase.
  2. 2VFS error completing the atomic write batch.
How to reproduce

COMMIT on a database using atomic write VFS.

trigger — this will error
trigger — this will error
# Transaction commit failed at atomic commit step
# → database may be in inconsistent state

expected output

sqlite3.DatabaseError: disk I/O error

Fix 1

Fix 2

Fix 3

Sources
Official documentation ↗

sqlite3.h — SQLITE_IOERR_COMMIT_ATOMIC = 7690

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

← All SQLite errors