What is happening
SQLite states that separating a WAL-mode database from its WAL can lose committed transactions or corrupt the copied state. The shared-memory file can be rebuilt from the WAL, so these files have different recovery importance.
SQLite WAL recovery
In WAL mode, recent committed pages may remain in a separate -wal file until checkpointed into the main database. The -shm file is an index that can be rebuilt, but the WAL is part of persistent database state.
Understand the symptom
SQLite states that separating a WAL-mode database from its WAL can lose committed transactions or corrupt the copied state. The shared-memory file can be rebuilt from the WAL, so these files have different recovery importance.
What you may see
Committed pages may exist only in the WAL.
The main file, WAL, or copied generation may be inconsistent.
Required WAL files, permissions, or immutable handling may be absent.
Checkpointing may have been blocked or the application exited uncleanly.
Protect the source
Do not treat it as a temporary cache.
Work only with verified copies from the same generation.
Capture all related files atomically or after clean shutdown.
Do this now
Prevent connections, writes, and automatic checkpoints.
Keep database, WAL, SHM, journal, names, timestamps, and directory structure.
Identify last known record, row counts, application time, and crash event.
Image failing storage before scanning large databases repeatedly.
NEPFOSYS process
NEPFOSYS compares page size, salts, sequence values, WAL frames, and file timestamps.
Valid committed frames and readable database pages are assembled without changing originals.
Integrity checks, table counts, keys, timestamps, and priority application records are reviewed.
A clear next step
Start a case with the exact symptoms, incident timeline, prior attempts, encryption details, and the files that matter most. NEPFOSYS will route the case to the appropriate DFW intake or nationwide mail-in path.
Start with a case reviewQuestions, answered
It can normally be rebuilt, while the WAL can contain committed data not yet in the main file.
Not safely while WAL mode is active unless the application performs a supported backup or checkpoint.
No. Preserve the complete set first and test checkpoints on a copy.
DFW local · Nationwide mail-in