Home Assistant on my Raspberry Pi went down hard when my dog pulled its plug.
After it rebooted, I get this error. I tried deleting the .db file in the /config folder, but even after rebooting multiple times, I still get this error and the .db file has not been rebuilt.
Any ideas? Thanks
Here is the log entry of the recorder. I visited that page, which didn’t help me at all fix the issue:
Make sure the MariaDB addon is started, then restart HA from the /config/server_control page
Your mariadb is corrupt. Remove the add-on (save your config) and re-install it. The .db file in the /config folder is the sqlite database, you are not using it anymore since you switched to mariadb.
mariadb was running, but I restarted it anyway and verified it was running, then restarted HA. Still same error.
I will try deleted the mariadb addon and reinstalling it.
Restarted Home Assistant and was able to install MariaDB.
However, I’ve tried twice now to restore just the MariaDB Snapshot from a recent Snapshot and nothing changes on the MariaDB Configuration tab - its still shows the defaults
Finally got the snapshot to restore mariadb settings.
Rebooted HA
Verified mariaDB was started.
Same error as originally.
Still stuck
Ok, this is stupid. I just reinstalled mariaDB, but it says I’m running an older version (1.3) while a newer one is available (2.2.1)
How can that be?
Upgraded mariaDB to 2.2.1 and rebooted. Still broken
That rarely works. Just start with a fresh db after reinstalling the addon.
Ship Performance Optimisation System?
Oh that SPOS.
Bye. 
Classic “dog ate my homework” story. If anything can go wrong it will go wrong. No manual to cover this one 
Damn. I was going to make that joke. 
Keep it civil. Otherwise this will get locked. Have a great day.
Not sure why my post got moderated, it also contained the solution …
Anyway, I’ll put no more effort into this thread 
My fault. Sorry.
Can you explain why that rarely works? In what cases does and does it not work? Just genuinely curious. What if OP had restored the entire snapshot they had?
Nope. Just know from experience here that restoring the HA database, default or MariaDB, very rarely works.
