What does HRESULT 0x87AF0108 (SQLITE_E_READONLY_RECOVERY) mean?

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite could not complete database recovery because required files or directories were read-only.

Previous	Next
SQLITE_E_LOCKED_SHAREDCACHE	SQLITE_E_IOERR_READ

SQLITE_E_READONLY_RECOVERY

SQLITE_E_READONLY_RECOVERY is the extended SQLite read-only result for a recovery operation. SQLite needs to write recovery state but the database environment is not writable.

What to check

Check permissions on the database directory as well as the file, because recovery can require journal or WAL sidecar updates.
Check mount state and whether the database was restored to read-only media or a snapshot path.
Restore to a designated writable working location when recovery cannot safely occur in place.

PRAGMA journal_mode;

SQLite: Result and Error Codes

SQLite: Write-Ahead Logging

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