Over the last week or so, my HA installation reboots once every day at random times. In the logs, I see this error:
‘’’
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:330
integration: Recorder (documentation, issues)
First occurred: 1:53:24 PM (1 occurrences)
Last logged: 1:53:24 PM
The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly
‘’’
Any ideas?
I’m going to guess a RasPI with an SD card?
Yes, RPi4 8GB 512GB sd card running under PiMox.
90% chance your SD Card is crapping out.
Thanks, might it be advisable to copy (or clone) the current card to a new one?
Do a backup, then restore.on the new one.
I suggest an SSD in a USB carrier, connected to an external USB hub that has a separate power supply… This powers the ssd from not the pi supply.
If you are doing another SD card, industrial grade class 10 and from a reputable supplier. And given some time it will fail again. They are not made for the write-write action of a database.
I rebuilt my system on an Intel NUC, restored from backup. I still see the error. There seems to be no definitive answer to this, at least in the HA community. Can someone provide some insight as to why this happens at all?
Thanks.