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?
All Comments (3)
Mines at 40GB.
Feels excessive, is this just expected behaviour @Adam Driscoll ?
9b2093b495ab377edd1e4621b61754d177155a83.png
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
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.
Adam Driscoll
PowerShell Expert and Developer at Devolutions