SQLITE_NOTICE
SQLiteINFOCommonLoggingofficial confidence
Notification from sqlite3_log()
Production Risk
None — informational only.
What this means
SQLITE_NOTICE (27) is an informational code passed to the sqlite3_log() error-logger callback to indicate routine notifications such as WAL autocheckpoints and database recovery.
Why it happens
- 1WAL auto-checkpoint completed.
- 2Database recovered from a journal after a crash.
- 3Informational message from an extension or VFS.
How to reproduce
sqlite3_log() callback; not returned by API functions — only seen in log output.
trigger — this will error
trigger — this will error
# In C, register a logger: # sqlite3_config(SQLITE_CONFIG_LOG, myLogCallback, 0); # SQLITE_NOTICE will appear for WAL checkpoints and recovery events
expected output
Log message: "recovered N frames from WAL file ..." with code SQLITE_NOTICE.
Fix 1
Fix 2
Version notes
Sources
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev