Also, make sure that folder is not a shared resource or inside a shared resource that is visible from any other network node or machine.
This piece, describing the same symptom for Internet Explorer temporary files, may help: https://support.microsoft.com/en-us/kb/814782 What happens when you make the DB, set WAL mode, do a Query, then wait 2 minutes doing nothing, then close the DB. Do the temp files still loiter? On 2015-08-15 07:28 PM, Ashwin Hirschi wrote: > > Hello, > > I've recently found SQLite doesn't always remove its journal files > anymore. > > The issue seems to occur when opening WAL databases in read-only mode > (i.e. using SQLITE_OPEN_READONLY). > > A scenario to reproduce this (using version 3.8.11.1) looks like: > > 1. open a WAL database in read-only mode > 2. prepare & finalize a query > 3. close the database > > The "-shm" and "-wal" journal files are created during the prepare() > in step 2. But, after step 3, they're both still present. > > If the database is opened in read-write mode, everything is fine. > Lastly, I'm having the issue on a Windows 10 machine and am not > currently able to test anywhere else... > > So, can anyone else reproduce the above scenario? > > Ashwin. > > P.S. I've also checked some older SQLite versions. It looks like this > unfortunate "non-cleanup" was introduced in 3.8.11. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
