HRESULT 0x87AF130A (SQLITE_E_IOERR_SHMSIZE): meaning and diagnosis

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite could not enlarge the WAL shared-memory file.

Previous	Next
SQLITE_E_IOERR_SHMOPEN	SQLITE_E_IOERR_SHMLOCK

SQLITE_E_IOERR_SHMSIZE

SQLITE_E_IOERR_SHMSIZE corresponds to SQLITE_IOERR_SHMSIZE. SQLite failed in xShmMap while enlarging the -shm file during WAL transaction processing; SQLite notes that insufficient space on the underlying volume can be a cause.

What to check

Check available space and quota on the volume that contains the database directory.
Verify permissions for the -shm file and the directory, not only the main database file.
Check WAL mode access from all processes and keep the database local to the host where possible.

PRAGMA journal_mode;
PRAGMA wal_checkpoint(PASSIVE);

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.