Database.db-wal - 80+ GB

Product: PowerShell Universal
Version: 4.2.7

Has anyone ever seen an 80+ GB database.db-wal file in the UniversalAutomation directory? After doing a little reading, it is a SQLite Write-Ahead Log file which is useful for commits/rollback purposes.

I have rebooted the server, hoping that would clear it but it seems to be sticking around. Any thoughts on how to shrink this or remove it?

Mines at 40GB.

Feels excessive, is this just expected behaviour @adam ?

image

SQLLite WAL databases can be truncated using
.\sqlite3.exe database.db “PRAGMA wal_checkpoint(TRUNCATE);”

sqlite3.exe can be found in the command line bundle here:
https://www.sqlite.org/download.html

Stop the service first :sweat_smile:

You can try adjusting the database logging target (or remove it if you’re not using it) to see if that’s causing it.

It could also be job logs\output if you’re running lots of scripts.