Hass.io - no logbook or history after moving to HassOS

Installation Home Assistant OS
1

I switched over to HassOS yesterday and everything seems to have migrated nicely. However, today I noticed I have no Logbook or History.

The logs showed a lot of errors like: Error executing query: (sqlite3.DatabaseError) database disk image is malformed

After a little searching I found an older thread that suggested deleting Home-Assistant_V2.db to fix the issue. I tried this (just renamed the DB file). A new one was created, but now I have errors like: Error executing query: (sqlite3.OperationalError) no such table: states

Anyone else with a similar issue or any ideas on how to fix it?

UPDATE:
I deleted both the renamed and newly created Home-Assistant_V2.db then rebooted and that seems to have fixed the issue.

2

Watching this thread as it is similar to my thread (Mysql errors after updateing/migrating to 1.5 PI3 image(I figured it out))

3

I have the same problem, once I changed to HassOS my Log and History did not work. As you said, I deleted my database and rebooted and now it works again.

4

I have the same issue…

On ResinOS everything was OK, after clean install HassOS v1.11 (32bit) and copy/paste configuration now history is not working.
My database is located on MySQL NAS server. Then I tried to delete database tables and new tables are created succesfully… So connection is not problem…

Any idea how to fix this?