SQLITE_NOTICE_RECOVER_WAL
SQLiteINFOCommonLoggingofficial confidence

WAL file recovery in progress (log notice)

Production Risk

None — informational notice.

What this means

SQLITE_NOTICE_RECOVER_WAL (283) is passed to the sqlite3_log() callback when SQLite is recovering a WAL file after a crash. It is informational and indicates normal crash recovery.

Why it happens
  1. 1Application restarted after an unclean shutdown with uncommitted WAL frames.
  2. 2Normal WAL crash recovery on database open.
How to reproduce

First database open after a crash when a WAL file is present.

trigger — this will error
trigger — this will error
# Register logger in C to see this code:
# sqlite3_config(SQLITE_CONFIG_LOG, myLogger, NULL);
# On open: "recovered N frames from WAL file ..."

expected output

Log: "recovered 42 frames from WAL file my.db-wal"

Fix

Sources
Official documentation ↗

sqlite3.h — SQLITE_NOTICE_RECOVER_WAL = 283

WAL mode

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

← All SQLite errors