🗃️

SQLite Result Codes

SQLite 3.52105 codes

Result codes with Python & C fix examples

Showing 105 of 105 errors

Code	Message	Severity	Tier
SQLITE_ERROR	SQL logic error	ERROR	Common	→
SQLITE_BUSY	database is locked	ERROR	Notable	→
SQLITE_LOCKED	database table is locked	ERROR	Notable	→
SQLITE_READONLY	attempt to write a readonly database	ERROR	Common	→
SQLITE_IOERR	disk I/O error	ERROR	Critical	→
SQLITE_CORRUPT	database disk image is malformed	ERROR	Critical	→
SQLITE_FULL	database or disk is full	ERROR	Notable	→
SQLITE_CANTOPEN	unable to open database file	ERROR	Common	→
SQLITE_SCHEMA	database schema has changed	ERROR	Common	→
SQLITE_TOOBIG	string or blob too big	ERROR	Common	→
SQLITE_CONSTRAINT	constraint failed	ERROR	Common	→
SQLITE_CONSTRAINT_PRIMARYKEY	UNIQUE constraint failed (primary key)	ERROR	Common	→
SQLITE_CONSTRAINT_UNIQUE	UNIQUE constraint failed	ERROR	Common	→
SQLITE_CONSTRAINT_FOREIGNKEY	FOREIGN KEY constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_NOTNULL	NOT NULL constraint failed	ERROR	Common	→
SQLITE_CONSTRAINT_CHECK	CHECK constraint failed	ERROR	Common	→
SQLITE_BUSY_SNAPSHOT	cannot start a transaction within a transaction (WAL snapshot conflict)	ERROR	Notable	→
SQLITE_IOERR_WRITE	disk I/O error (write failure)	ERROR	Critical	→
SQLITE_CORRUPT_VTAB	database disk image is malformed (virtual table)	ERROR	Notable	→
SQLITE_CANTOPEN_NOTEMPDIR	unable to open a temporary database file for storing temporary tables	ERROR	Notable	→
SQLITE_READONLY_ROLLBACK	attempt to write a readonly database (hot journal present)	ERROR	Critical	→
SQLITE_MISMATCH	datatype mismatch	ERROR	Common	→
SQLITE_MISUSE	bad parameter or other API misuse	ERROR	Common	→
SQLITE_AUTH	not authorized	ERROR	Notable	→
SQLITE_NOTADB	file is not a database	ERROR	Common	→
SQLITE_OK	Successful result	SUCCESS	Common	→
SQLITE_INTERNAL	Internal logic error in SQLite	FATAL	Critical	→
SQLITE_PERM	Access permission denied	ERROR	Notable	→
SQLITE_ABORT	Callback routine requested an abort	WARNING	Notable	→
SQLITE_NOMEM	malloc() failed — out of memory	FATAL	Critical	→
SQLITE_INTERRUPT	Operation terminated by sqlite3_interrupt()	WARNING	Notable	→
SQLITE_NOTFOUND	Unknown opcode or table/row not found	ERROR	Notable	→
SQLITE_PROTOCOL	Database locking protocol error	ERROR	Notable	→
SQLITE_EMPTY	Internal use only (not used by SQLite)	INFO	Common	→
SQLITE_NOLFS	Large file support is disabled	ERROR	Notable	→
SQLITE_FORMAT	Auxiliary database format error (not used)	INFO	Common	→
SQLITE_RANGE	Bind or column index out of range	ERROR	Notable	→
SQLITE_NOTICE	Notification from sqlite3_log()	INFO	Common	→
SQLITE_WARNING	Warning from sqlite3_log()	WARNING	Common	→
SQLITE_ROW	sqlite3_step() has another row ready	SUCCESS	Common	→
SQLITE_DONE	sqlite3_step() finished executing	SUCCESS	Common	→
SQLITE_ERROR_MISSING_COLLSEQ	Missing collating sequence	ERROR	Notable	→
SQLITE_ABORT_ROLLBACK	Statement aborted due to ROLLBACK	WARNING	Notable	→
SQLITE_BUSY_RECOVERY	Busy: another connection is recovering WAL	WARNING	Notable	→
SQLITE_BUSY_SNAPSHOT	Busy: WAL snapshot is out of date	WARNING	Notable	→
SQLITE_BUSY_TIMEOUT	Busy: timeout waiting for lock	ERROR	Notable	→
SQLITE_LOCKED_SHAREDCACHE	Locked due to shared-cache contention	WARNING	Notable	→
SQLITE_READONLY_RECOVERY	Read-only: WAL recovery required by another connection	WARNING	Notable	→
SQLITE_READONLY_CANTLOCK	Read-only: unable to obtain shared lock	WARNING	Notable	→
SQLITE_READONLY_ROLLBACK	Read-only: rollback journal prevents read	WARNING	Notable	→
SQLITE_CANTOPEN_ISDIR	Cannot open — path is a directory	ERROR	Notable	→
SQLITE_CANTOPEN_FULLPATH	Cannot open — full path resolution failed	ERROR	Notable	→
SQLITE_CANTOPEN_SYMLINK	Cannot open — symlinks not allowed	ERROR	Notable	→
SQLITE_CORRUPT_VTAB	Virtual table content is corrupt	ERROR	Critical	→
SQLITE_CORRUPT_SEQUENCE	sqlite_sequence table is corrupt	ERROR	Critical	→
SQLITE_CORRUPT_INDEX	Index is inconsistent with table	ERROR	Critical	→
SQLITE_CONSTRAINT_CHECK	CHECK constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_FOREIGNKEY	FOREIGN KEY constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_NOTNULL	NOT NULL constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_PRIMARYKEY	PRIMARY KEY constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_UNIQUE	UNIQUE constraint failed	ERROR	Notable	→
SQLITE_CONSTRAINT_ROWID	Rowid is not unique	ERROR	Notable	→
SQLITE_CONSTRAINT_DATATYPE	Strict table datatype constraint failed	ERROR	Notable	→
SQLITE_NOTICE_RECOVER_WAL	WAL file recovery in progress (log notice)	INFO	Common	→
SQLITE_NOTICE_RECOVER_ROLLBACK	Hot journal rollback in progress (log notice)	INFO	Common	→
SQLITE_WARNING_AUTOINDEX	Query using automatic index (log warning)	WARNING	Common	→
SQLITE_OK_LOAD_PERMANENTLY	Extension loaded permanently into SQLite	SUCCESS	Common	→
SQLITE_IOERR_READ	I/O error during file read	FATAL	Critical	→
SQLITE_IOERR_SHORT_READ	I/O error: short read (unexpected EOF)	ERROR	Critical	→
SQLITE_IOERR_WRITE	I/O error during file write	FATAL	Critical	→
SQLITE_IOERR_FSYNC	I/O error during fsync()	FATAL	Critical	→
SQLITE_IOERR_TRUNCATE	I/O error during file truncation	FATAL	Critical	→
SQLITE_IOERR_DELETE	I/O error deleting journal file	ERROR	Notable	→
SQLITE_IOERR_NOMEM	I/O subsystem out of memory	FATAL	Critical	→
SQLITE_IOERR_LOCK	I/O error obtaining file lock	ERROR	Notable	→
SQLITE_IOERR_MMAP	I/O error during memory-mapped file access	ERROR	Notable	→
SQLITE_IOERR_BEGIN_ATOMIC	I/O error starting atomic write	ERROR	Notable	→
SQLITE_IOERR_COMMIT_ATOMIC	I/O error committing atomic write	FATAL	Critical	→
SQLITE_IOERR_ROLLBACK_ATOMIC	I/O error rolling back atomic write	FATAL	Critical	→
SQLITE_IOERR_SHMMAP	I/O error memory-mapping WAL shared memory	ERROR	Notable	→
SQLITE_IOERR_SEEK	I/O error during file seek	FATAL	Critical	→
SQLITE_IOERR_DELETE_NOENT	I/O error deleting non-existent file	INFO	Common	→
SQLITE_IOERR_CORRUPTFS	I/O error — filesystem is corrupt	FATAL	Critical	→
SQLITE_LOCKED_VTAB	Virtual table is locked	WARNING	Notable	→
SQLITE_READONLY_DBMOVED	Read-only: database file has been moved	ERROR	Notable	→
SQLITE_READONLY_CANTINIT	Read-only: unable to initialise shared memory	ERROR	Notable	→
SQLITE_READONLY_DIRECTORY	Read-only: journal directory is not writable	ERROR	Notable	→
SQLITE_CONSTRAINT_COMMITHOOK	Commit hook requested rollback	WARNING	Notable	→
SQLITE_CONSTRAINT_TRIGGER	Constraint raised by a trigger	ERROR	Notable	→
SQLITE_CONSTRAINT_VTAB	Virtual table constraint violation	ERROR	Notable	→
SQLITE_CONSTRAINT_PINNED	Cannot delete a row required by a rowid scan	ERROR	Notable	→
SQLITE_AUTH_USER	Authorisation denied by user	ERROR	Notable	→
SQLITE_OK_SYMLINK	File is a symlink (success with note)	SUCCESS	Common	→
SQLITE_ERROR_RETRY	Internal retry signal (not user-facing)	INFO	Common	→
SQLITE_ERROR_SNAPSHOT	Snapshot is out of date	ERROR	Notable	→
SQLITE_NOTICE_RBU	RBU update notice from sqlite3_log()	INFO	Common	→
SQLITE_IOERR_DATA	I/O error: data integrity check failed	FATAL	Critical	→
SQLITE_IOERR_DIR_FSYNC	I/O error syncing the journal directory	FATAL	Critical	→
SQLITE_IOERR_UNLOCK	I/O error releasing file lock	ERROR	Notable	→
SQLITE_IOERR_RDLOCK	I/O error checking reserved read lock	ERROR	Notable	→
SQLITE_IOERR_ACCESS	I/O error checking file existence/access	ERROR	Notable	→
SQLITE_IOERR_CLOSE	I/O error closing file descriptor	WARNING	Notable	→
SQLITE_IOERR_SHMOPEN	I/O error opening WAL shared-memory file	ERROR	Notable	→
SQLITE_IOERR_SHMSIZE	I/O error resizing WAL shared-memory file	ERROR	Notable	→
SQLITE_IOERR_GETTEMPPATH	I/O error finding a temporary directory	ERROR	Notable	→