String of Database and sensor errors and Hassio locked up

Every couple of days I get a hassio lockup and if I look in information I see these as an example:

Error in database connectivity: (sqlite3.OperationalError) unable to open database file. (retrying in 3 seconds)
10:34 components/recorder/init.py (ERROR)
Error executing query: (sqlite3.OperationalError) unable to open database file
10:34 components/recorder/util.py (ERROR)
Update for sensor.bom_gosford_wind_gust_kt fails
10:34 components/sensor/bom.py (ERROR)

I can still control my lights etc but I can’t get into Hassio to configure addons etc. If I SSH in, no matter what I type, nothing is accepted. All I can do at this point is reboot the RPi.

I’m running a RPi 3b (obviously) 0.60 and my SD card was supplied by RS Components - one of their noobs cards. It’s not that old - couple of months max. I am also using a power supply specific to the RPi3 from RS components.

What can I do to get back control here? Is rebooting it? Does everyone else have this problem after a day or so?

Further - WinSCP and Putty now also refuse to connect.
Also can’t sync Google Actions - get an error on the project in Google Home.

I’m sure a reboot will fix all this of course…

How big is your SDCard? Sounds like it’s filling up with the database

32gb SD Card.

hassio seems to have a lot of quirks.

I am running just the normal docker container, but on a NUC, and I don’t have any issues with it.

Seems so. I’m trying to see how to limit the log file to a week… (although I’m sure it’s not this)

Cheers. I’ll see how that works

The other thing that worries me is it can’t be good restarting HA all the time by power cycling the Pi. How long does yours stay up for before needing a power cycle?

Just also noticed when it was locked that it wasn’t displaying the album artwork anymore (even though it was displaying the track and artist) and it had no trouble controlling my lights but could not sync my devices…

Power cycling the pi by pulling power is bad for the sdcard. You can corrupt the card very easily that way.

I never have to reboot my NUC. I’m not running on a pi.

oh of course - you said that earlier.

No kidding! That’s why I’m trying to fix it.