Since upgrading to 0.51.1 I’m now seeing the following issues in the log. Any idea if there is a way to fix these now? Restarting doesn’t seem to improve things.
2017-08-14 08:06:15 WARNING (Recorder) [homeassistant.components.recorder.migration] Failed to drop index ix_states_created_domain from table states. Schema Migration will continue; this is not a critical operation.
2017-08-14 08:06:15 WARNING (Recorder) [homeassistant.components.recorder.migration] Failed to drop index states__state_changes from table states. Schema Migration will continue; this is not a critical operation.
2017-08-14 08:06:15 WARNING (Recorder) [homeassistant.components.recorder.migration] Failed to drop index states__significant_changes from table states. Schema Migration will continue; this is not a critical operation.
2017-08-14 08:06:20 WARNING (Recorder) [homeassistant.components.recorder.migration] Failed to drop index ix_states_entity_id_created from table states. Schema Migration will continue; this is not a critical operation.
2017-08-14 08:06:24 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2017-08-14 08:06:25 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) database is locked [SQL: ‘CREATE INDEX ix_states_entity_id_last_updated ON states (entity_id, last_updated)’]
2017-08-14 08:06:25 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) database is locked [SQL: ‘CREATE INDEX ix_states_entity_id_last_updated ON states (entity_id, last_updated)’] (retrying in 3 seconds)