SQLite error codes
19 codes — tap one for its meaning, causes, and fix steps.
- SQLITE_AUTHauthorization denied — an authorizer callback blocked the operation
- SQLITE_BUSYdatabase file is locked — another connection holds a shared or reserved lock
- SQLITE_BUSY_SNAPSHOTWAL snapshot conflict — a snapshot-isolated read cannot see a newer WAL frame
- SQLITE_CANTOPENunable to open the database file
- SQLITE_CONSTRAINTa constraint violation was raised — the write violates a database rule
- SQLITE_CONSTRAINT_FOREIGNKEYFOREIGN KEY constraint failed — the referenced row does not exist
- SQLITE_CONSTRAINT_UNIQUEUNIQUE constraint failed — a duplicate value was inserted
- SQLITE_CORRUPTthe database file is malformed — on-disk structure is damaged
- SQLITE_FULLthe database or disk is full — no space for the write
- SQLITE_IOERRan I/O error occurred on the disk
- SQLITE_LOCKEDa table in the database is locked — conflict within the same connection
- SQLITE_MISMATCHdatatype mismatch — the value type does not fit the affinity
- SQLITE_MISUSElibrary used incorrectly — the API was called in an invalid state
- SQLITE_NOMEMout of memory — a memory allocation failed
- SQLITE_NOTADBthe file is not a recognized SQLite database
- SQLITE_PERMaccess permission denied — the OS refused the file operation
- SQLITE_READONLYattempt to write to a read-only database
- SQLITE_READONLY_DBMOVEDread-only: the database file has been moved since it was opened
- SQLITE_TOOBIGa string or BLOB is too large — exceeds the compile-time maximum