What does HRESULT 0x87AF170A (SQLITE_E_IOERR_DELETE_NOENT) mean?

 
Previous Next
SQLITE_E_IOERR_SEEK SQLITE_E_IOERR_MMAP

SQLITE_E_IOERR_DELETE_NOENT

SQLITE_E_IOERR_DELETE_NOENT corresponds to SQLITE_IOERR_DELETE_NOENT. The VFS xDelete operation failed because the file SQLite tried to remove did not exist.

What to check

  • Identify which companion file was missing: journal, WAL, shared-memory, temporary, or another VFS-managed file.
  • Check for cleanup jobs, sync software, antivirus, or another process that may remove files from the database directory.
  • Do not reconstruct missing WAL or journal files manually; establish the database state from a safe backup or controlled recovery procedure.
PRAGMA journal_mode;
PRAGMA database_list;

SQLite: Result and Error Codes

SQLite: Extended Result Codes

SQLite: VFS interface

SQLite: Temporary Files

SQLite: How Database Files Can Become Corrupt


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