HASSBIAN crashes, my pi3 crashes. How to troubleshoot

Archive HASSbian
41

This morning the DB file was 28GByte. HASS crashed again (not sure if because of size of DB or what)

This is my configuration. Can anyone explain how to avoid this huge database?

recorder:
  purge_days: 2
  db_url: sqlite:///home/homeassistant/.homeassistant/home-assistant_v2.db
  include:
    entities:
      - sensor.dark_sky_summary
      - switch.closet
      - binary_sensor.motion_sensor_158d000127acc3
# History setting is empty now
history:
42

Wow, that’s insane. Since I re-created it yesterday, mine has gone up to 3.2MB

Perhaps you should download it and take a look inside to see what kind of messages take that much space? I use “db browser for sqlite” from http://sqlitebrowser.org/
But I havent looked around much for alternatives, so not sure how good it is for such big databases.

43

to trabnsfer from SD car will take forever. I put a new thread, the developers of HASS, or some user should know what’s happening

44

@anon35356645 If you have devices that generate alot of traffic, like an energy monitor, or any other device whose value changes often, you should exclude those devices from your history…

45

I do not know which device might be