HRESULT 0x87AF120A (SQLITE_E_IOERR_SHMOPEN): meaning and diagnosis

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite could not open a WAL shared-memory segment.

Previous	Next
SQLITE_E_IOERR_DIR_CLOSE	SQLITE_E_IOERR_SHMSIZE

SQLITE_E_IOERR_SHMOPEN

SQLITE_E_IOERR_SHMOPEN corresponds to SQLITE_IOERR_SHMOPEN. The VFS failed in xShmMap while SQLite tried to open a new shared-memory segment for WAL processing.

What to check

Confirm that the database directory permits creation and access to the associated -shm file.
Check whether the database is being used over a network share; WAL shared-memory coordination is designed around local access.
Verify that all processes see the same database directory and are not mixing incompatible filesystem semantics.

PRAGMA journal_mode;

SQLite: Result and Error Codes

SQLite: Write-Ahead Logging

SQLite: Temporary Files

SQLite: Network Filesystem Considerations

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