Hi All, I have a similar problem like many of the users. My SD Card with 16G is at the limit because the DB is 15 GB in size. So I followed some hints and deleted the DB. Everything is fine after a reboot, a new DB was created. The new DB is 1G in size but the DF and also Homeassistant says that…

Yes i noticed, your DB-file is not large ! now as i mentioned [image] Wasserflo: It shrunk for 500M after that (to 14.5G) 13025312 this is the total used space you get a better overview if you run du -sh * And try another thing, in the console type ha su repair

The minimum recommend size is 32 GB. [image] How to keep your recorder database size under control Community Guides Note: This guide was written for an earlier version of Home Assistant (around 2021). Since then, changes have happened, but this guide hasn’t be…

Does this help? [image] Graceful shutdown and restart in case of power failure Hardware Do you need the database? If not, use a dummy db, it will never corrupt grin # Put the SQLITE db in memory. recorder: db_url: 'sqlite:///:memory:'

Just FYI, this was removed in April of 2022 as an available option. [image] How to keep your recorder database size under control Community Guides Unfortunately the in-memory sqlite does not have proper locking between threads which leads to random failures so its not lon…

tsssk…shame on me thanks @code-in-progress

[image] Wasserflo: How can I free up the disk space now? Did you also deleted the DB-WALL and DB-SHM file ? Have you tried Purge ALL + Repack ?

Yes, I have deleted also the Wall and SHM file. This is what the folder is looking now: [image] Before I delete the DB files the .db file was 14.8G in size. I used the rm command to remove them and have read that it deletes the file permantely not sending it to trash. But the df shows this: [im…

An option would be to start fresh (with at least a 32GB card) and restore a backup .

[image] Wasserflo: So the space from the files is not freed from the SD Card. This makes me think that there is might be some ‘hidden’ trash folder on an SD Card? Have you tried REPACK ? Seems like your DB is 9 GB and you DB-WAL is 4gb ! Do you have SQLite Web add-on installed ? edit: sorr…

[image] Wasserflo: My SD Card with 16G is at the limit because the DB is 15 GB in size. You can literally run a pi with a 120GB SSD for about twice the price of an SD card. It doesn’t make sense to use SD cards anymore. That would be your best solution.

[image] forsquirel: It doesn’t make sense to use SD cards anymore. I have different thoughts on that. But to each their own.

Delete DB, not enough space

Configuration

MaxK (Mark) April 12, 2024, 9:02am 2

The minimum recommend size is 32 GB.