After re-flashing Hass.io to my microSD and letting it install last night, I restored a configuration file from 0.64. It seems to have worked fairly well except for the following:
configuration.yaml is empty for history and logbook, and recorder is not even specified. I have never adjusted these components so I don’t know why it’s complaining about them, unless something has changed between 0.64 and 0.66
How do I fix this?
Thanks!
Log file for a brand new install, post restoration of config only:
2018-04-11 21:31:43 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2018-04-11 21:32:33 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:32:33 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:32:38 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:32:38 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:32:44 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:32:44 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:32:49 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:32:49 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:32:55 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:32:55 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:00 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:33:00 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:06 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:33:06 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:11 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:33:11 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:17 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:33:17 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:22 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-04-11 21:33:22 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'CREATE INDEX ix_states_event_id ON states (event_id)'] (Background on this error at: http://sqlalche.me/e/4xp6) (retrying in 3 seconds)
2018-04-11 21:33:22 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Component failed to initialize.
2018-04-11 21:33:22 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of history. Setup failed for dependencies: recorder
2018-04-11 21:33:22 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not setup all dependencies.
2018-04-11 21:33:24 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of logbook. Setup failed for dependencies: recorder
2018-04-11 21:33:24 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not setup all dependencies.Ok, I renamed home-assistant_v2.db to home-assistant_v2.db.old and rebooted it, and I think it’s fixed the problem. At least there are no more errors relating to those components and the web gui options for logbook and history are now visible.
Ok, I renamed home-assistant_v2.db to home-assistant_v2.db.old and rebooted it, and I think it’s fixed the problem. At least there are no more errors relating to those components and the web gui options for logbook and history are now visible.
works perfect
thank you very much