What does HRESULT 0x87AF0106 (SQLITE_E_LOCKED_SHAREDCACHE) mean?

 
Previous Next
SQLITE_E_BUSY_RECOVERY SQLITE_E_READONLY_RECOVERY

SQLITE_E_LOCKED_SHAREDCACHE

SQLITE_E_LOCKED_SHAREDCACHE is the extended SQLite locked result for a shared-cache conflict. A table lock in a shared cache prevents the requested operation.

What to check

  • Confirm whether shared-cache mode is enabled explicitly or inherited from a language binding.
  • Reduce overlapping statements and transaction scopes that access the same table through shared cache.
  • Consider separate connections without shared cache when the architecture does not require shared-cache semantics.
PRAGMA read_uncommitted;

SQLite: Result and Error Codes

SQLite: File locking and concurrency

SQLite: PRAGMA statements


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