This is expected behaviour. As Richard guessed, the system libsqlite3.dylib is built with SQLITE_ENABLE_PERSIST_WAL. For Darwin systems, the compromise of keeping the extra 4MiB (max) file around is generally worth the reduced I/O overhead that results from creating, resizing, and unlinking files.
If you need, you can still override this behaviour using the SQLITE_FCNTL_PERSIST_WAL opcode to the sqlite3_file_control() interface. Scott On Jan 28, 2019, at 10:32, Carsten Müncheberg <[email protected]> wrote: > > When loading and using /usr/lib/libsqlite3.dylib (3.19.3) which is shipped > with MacOS 10.13.6 I noticed that the -wal and -shm files are not deleted > when closing the last connection to a database. I tested this with the > sqlite3 command line tool. It does not happen when I compile and link > SQLite myself. > > Is this expected behavior or some kind of bug? > > Carsten _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
