SQLITE_NOTICEINFOTier 1 — Safe⚠️ MEDIUM confidence

Notification from sqlite3_log()

Category: LoggingVersions: 3.7.15+

🔴 Production Risk Error

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

# In C, register a logger:
# sqlite3_config(SQLITE_CONFIG_LOG, myLogCallback, 0);
# SQLITE_NOTICE will appear for WAL checkpoints and recovery events

Log message: "recovered N frames from WAL file ..." with code SQLITE_NOTICE.

Fix 1

Why this works

No fix needed — SQLITE_NOTICE is informational.

Fix 2

Why this works

Review the message text for any action items (e.g., unexpected recovery).

Version notes

Sources

📚 Official docs: https://www.sqlite.org/rescode.html#notice

🔧 Source ref: sqlite3.h — SQLITE_NOTICE = 27

📖 Further reading: sqlite3_log()

Confidence assessment

⚠️ MEDIUM confidence

Stable.