SQLite recorder purge fails with full disk issues

I agree the fix is to just delete the .db and let it rebuild.

To keep it from growing that big again, exclude all the entities you don’t need to keep, and set a short keep_days parameter. More information here:

To this I’d add that there are some inherently “chatty” integrations which create a lot of records, or fill each record with a lot of duplicated attributes. You can use SQL to query your database to find the worst offenders and focus on those.

1 Like