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
  1. 1WAL auto-checkpoint completed.
  2. 2Database recovered from a journal after a crash.
  3. 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
Official documentation ↗

sqlite3.h — SQLITE_NOTICE = 27

sqlite3_log()

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

← All SQLite errors