red slate
Hello everyone. I’m having serious issues with my Home Assistant setup. It’s running on a Raspberry Pi 5 with 8 GB RAM and an official Raspberry Pi 256 GB NVMe. When it works, everything runs perfectly. But I regularly get sqlite3.DatabaseError and sqlite3.OperationalError, and the whole system crashes.
At that point, I can’t download logs anymore and the UI is usually not accessible. The screenshot is all I currently have. If I power cycle the Pi, everything works fine again until the error occurs next time.
I reduced how often it happens by restarting the Pi once every night. Without that, it would crash every 1–2 days. Now it’s about once a week. But I’d like to fix this permanently.
Can anyone help? My system is very clean and minimal. I don’t have many devices, barely any add-ons installed, and the Pi is not under load. CPU usage is usually around 0–1% and RAM usage around 15%.
slate terrace