[resolved] Keeps receiving notification errors after I install HA on UnRaid

Configuration
1

Hi Guys, 2 days ago, I started my HA from scratch, ditched the pi and install Hassio on my new unraid server.

the install was pretty painless, and I was very happy to see that it’s still the same hassio I that I loved on the pi but on a PC

However, I keep getting nags about invalid configurations
attached screenshot:
recorer

Here’s what some of my logs have to say:

Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_events_context_id ON events (context_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)

I’m not sure where to start…

2

2019-01-04_10-14-32
2019-01-04_10-14-321399×1096 82.4 KB

3

delete the .db file. restart hassio

4

wow! that was easy!
Thank you!

I renamed it instead of deleting it, to “home-assistant_v2.db.bk”
Restarted Hassio… and the 300MB db file is now only 230K, + all errors are gone.

what’s in the db file anyways?

5

history mostly