Sqlite wal file is growing until the disk is completely full

1

For about a week, I have an issue with my home assistant, where the wal file of my sqlite database is not committing the changes to the db…
About an hour after a reboot or manual commit, the wal file has grown again to +10GB in size…
My recorder wasn’t changed, commit set at 20 like for the past 3 years or so…
Nothing much has changed about my setup… so no idea why the db is growing so fast…

I know I should offload historical data to an external mariadb or other instance, but I didn’t get there yet…

I have 2 options of pushing the wal info to the db, which is either a Home Assistant core restart, or a manual “PRAGMA wal_checkpoint(TRUNCATE);” in the SQLite Web module.

Does anyone have the golden idea where to start looking? I would hate to loose my historical data…

2

It is doing a database migration. From the other topics that people post, it is recommended to have at least 50% free space. You might want to increase your disk space to allow the migration to complete. The WAL will be cleaned up automatically after migration is done.

3 Likes