SQLite Forum

WAL files deleted
We were wondering about this in our project too, we think we're closing all the connections appropriately, but still end up with lingering wal files.  Someone suggested this test using the sqlite3 cli; what do you think is going on here?  Maybe a bug in the CLI?  Or a bug in the docs?

arya@jrrr /tmp % rm -rf test*
arya@jrrr /tmp % sqlite3 test.db
SQLite version 3.32.3 2020-06-18 14:16:19
Enter ".help" for usage hints.
sqlite> PRAGMA journal_mode = WAL;
sqlite> CREATE TABLE t(a);
sqlite> .exit
arya@jrrr /tmp % ls test*
test.db		test.db-shm	test.db-wal
arya@jrrr /tmp %