On 2017/02/08 7:21 PM, Niti Agarwal wrote:
The databases I'm working with are write ahead logging (WAL) databases. According to the SQLite documentation, the shm and wal files are supposed to be deleted upon completion of the program. However, these files are still there after execution of this program. The documentation says the files might still be there if the program does not complete cleanly, but I'm just not seeing that. Any insight?
This might be unrelated to your specific problem and you don't mention the OS - but I have seen this happen on combinations of Windows virtualisation and/or Anti-Virus holding open the newly appearing files for checking so it can't be deleted in a short time-frame. Ensure your DB is in a non-system-protective folder (such as my documents) and anti-virus is killed, then try again - if it still happens, we need to check more.
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users