Home Assistant crashed every few days

Installation Home Assistant OS
1

Hi,
as title says my HA has started to crash every few days. This mean that I’m able to connect to my instance and almost all sensor are " following to your Unavailable and cannot use add-ons or even boot ha from gui(need to power it off from cable). Lights and ac are still working thought HA.

Went trough logs are they look like this. I have Pi 4, 8GB where HA are installed on ssd.

image
image2238×766 129 KB

image
image1318×236 23.9 KB

image
image1791×581 93.7 KB

image
image2315×295 40 KB

image
image1331×228 22.6 KB

image
image2314×1106 222 KB

What would be next steps to find root cause to this so I can fix it. Looks like it might have started with disk I/O error and have something to do with sql

2

Its seems your DB is corrupted, maybe your SSD experiences some problem. Anyway if you have a lots of IoT and settings, you are recommended to replace SQLlite to Mysql or MariaDB or Postgress

3

I have maybe about 50 devices connected to my ha (sensor, lights, tv and etc). Is DB corruption usally more related SSD or to DB it self (SQLlite)?

4

It can be coming from the SSD anyway 50 is a lot of IoT most recommend to ditch the sqllite and going for rational DB

5

Installed MariaDB and HA seems to work way better. No crashes is last 3 days

1 Like