What does HRESULT 0x87AF011B (SQLITE_E_NOTICE_RECOVER_WAL) mean?

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite recovered a database using its write-ahead log after an unclean shutdown.

Previous	Next
SQLITE_E_CONSTRAINT_CHECK	SQLITE_E_WARNING_AUTOINDEX

SQLITE_E_NOTICE_RECOVER_WAL

SQLITE_E_NOTICE_RECOVER_WAL is an SQLite notice, not a normal statement failure. SQLite recovered database state from the write-ahead log after an unclean shutdown or interrupted process.

What to check

Treat the notice as evidence of an unclean stop and investigate the underlying crash, power interruption, or forced process termination.
Verify application health and make a consistent backup after recovery completes.
Do not delete the -wal or -shm files merely because the database opened successfully.

PRAGMA wal_checkpoint(PASSIVE);

SQLite: Result and Error Codes

SQLite: Write-Ahead Logging

SQLite: Online Backup API

Looking for a different code? Search another status or error code.