Disk usage getting higher

Installation Home Assistant OS
1

I’m running HA on RP4 with 64GB SD card. My disk usage has gone up from 12% to 52% in 10 days. The biggest file is the home-assistant_v2.db which is 15GB while the 4 snapshots is around 10GB. How to reduce the home-assistant_v2.db?

2

Check the recorder docs and use the keep_days option to reduce the amount of data retained. I have mine set to 2 days.

With snapshots, use one of the add ons available to similarly retain x number of snapshots. I retain 5.

However I wouldn’t be too concerned.

1 Like
3

Thanks for the fast reply. Where do I check the recorder doc?

4

See: How to reduce your database size and extend the life of your SD card

5

Thanks for your help. This is heavy stuff. Need some time to read and digest. Appreciate your help.

6

Where do you put this code? In config.yaml?

Create this notification integration:

Copy to clipboard

- platform: file
  name: entity_log
  filename: /config/www/entity_log.txt
  timestamp: false
7

Use the template editor method. No need to do that. It was an old method I used when I had trouble copying the results from the template editor. This method works much better now.

8

Ok. Got it

9

Hi, seems like cannot purge my database. Anyone can help?

Logger: homeassistant.components.recorder.purge
Source: components/recorder/purge.py:101
Integration: Recorder (documentation, issues)
First occurred: October 19, 2020, 1:42:05 PM (2 occurrences)
Last logged: 4:12:00 AM

Error purging history: (sqlite3.DatabaseError) database disk image is malformed [SQL: DELETE FROM states WHERE states.last_updated < ?] [parameters: (‘2020-09-07 20:15:17.040312’,)] (Background on this error at: http://sqlalche.me/e/13/4xp6)

Logger: homeassistant.components.recorder.purge
Source: components/recorder/purge.py:101
Integration: Recorder (documentation, issues)
First occurred: October 19, 2020, 1:42:05 PM (2 occurrences)
Last logged: 4:12:00 AM

Error purging history: (sqlite3.DatabaseError) database disk image is malformed [SQL: DELETE FROM states WHERE states.last_updated < ?] [parameters: (‘2020-09-07 20:15:17.040312’,)] (Background on this error at: http://sqlalche.me/e/13/4xp6)

10

Easy solution: delete home-assistant_v2.db and restart. You will lose your previous history.

Or you can search the forum on how to repair an SQLite DB. There are a few topics.

11

Great! I just delete then. No problem to loss some data. TQ.

12

Do I need to do anything to rebuild the database?

13

It is automatically recreated when you restart HA

14

Oic…Ok. TQ