HRESULT 0x87AF0008 (SQLITE_E_READONLY): meaning and diagnosis

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite attempted to write to a database that is read-only in the current environment.

Previous	Next
SQLITE_E_NOMEM	SQLITE_E_INTERRUPT

SQLITE_E_READONLY

SQLITE_E_READONLY corresponds to SQLite SQLITE_READONLY. The database cannot accept the requested write in its current configuration or filesystem environment.

What to check

Verify filesystem permissions for the database and the directory that must hold journal or WAL sidecar files.
Check whether the connection was intentionally opened read-only or whether PRAGMA query_only was enabled.
For a mounted or copied database, verify the intended writable target instead of changing permissions on an original evidence or backup copy.

PRAGMA query_only;

SQLite: Result and Error Codes

SQLite: PRAGMA statements

SQLite: Write-Ahead Logging

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