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
  1. 1Application crashed or exited uncleanly while a rollback-mode journal was active.
  2. 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

← All SQLite errors