Hi,
I upgraded to 0.112 during the night and this morning I found all my MQTT (using mosquitto) entities unavailable, all my TADO entities unavailable, HACS missing from the right menu with a notification warning me that hacs could not be set up.
I’ve then restored a backup but with no luck: entities are still unavailable and in “restored” state in entities page.
Nothing useful in system logs nor in mosquitto logs.
Is there anything I can look for?
Anything in the logs ? What mqtt entities (tasmota, zigbee2mqtt, other ) ?
Hi francisp, thank you for the reply and sorry for the delay: I’ve been re-executing the upgrade since before your reply to try and fix the issue.
I’ve now upgraded both the SO and the Core and lots of errors wen away: is this mandatory?
First time, I upgraded just the core, to proceed step-by-step and check each time.
Mqtt and TADO entities are up and running, hacs is working again (although I had to reinstall the frontend modules due to missing js).
Now the new issues are recorder, history, logbook and history_stats.sensor.
There are lots of ERRORS in the Core logs:
2020-07-06 12:04:20 WARNING (Recorder) [homeassistant.components.recorder.migration] Adding index `ix_events_context_parent_id` to database. Note: this can take several minutes on large databases and slow computers. Please be patient!
2020-07-06 12:07:20 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: CREATE INDEX ix_events_context_parent_id ON events (context_parent_id)]
(Background on this error at: http://sqlalche.me/e/4xp6)
2020-07-06 12:07:20 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: CREATE INDEX ix_events_context_parent_id ON events (context_parent_id)]
(Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2020-07-06 12:07:20 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
2020-07-06 12:07:22 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2020-07-06 12:07:22 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not set up all dependencies.
2020-07-06 12:07:22 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2020-07-06 12:07:22 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not set up all dependencies.
These all depend on recorder. It seems your database failed to migrated to the new format. If there is nothing in your database you want to keep, you can delete home-assistant_v2.db and restart.
All good stuff is on Influx, and I’m already awared of the db failure after a snapshot restore: cleared the DB file and all it’s now working.
Thank you.
