SQLITE_NOTICE_RECOVER_ROLLBACK
SQLiteINFOCommonLoggingofficial confidence
Hot journal rollback in progress (log notice)
Production Risk
None — informational.
What this means
SQLITE_NOTICE_RECOVER_ROLLBACK (539) is passed to the sqlite3_log() callback when SQLite recovers a hot rollback journal after a crash. It is informational and indicates automatic recovery.
Why it happens
- 1Application crashed or exited uncleanly while a rollback-mode journal was active.
- 2A -journal file was found on database open and is being rolled back.
How to reproduce
First database open after crash in rollback journal mode.
trigger — this will error
trigger — this will error
# Log message: "recovered from hot journal ..." # No action needed; SQLite rolls back the journal automatically
expected output
Log: "recovered from hot journal /path/my.db-journal"
Fix
Sources
Official documentation ↗
sqlite3.h — SQLITE_NOTICE_RECOVER_ROLLBACK = 539
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev