This is HomeAssistant on Docker on Ubuntu 20.04
It has been running fine, but latest update to 2021.3.0.
Now it takes 5-10 minutes to come up, and then shows errors, but runs fine it seems.
I see these errors in log:
2021-03-09 18:04:15 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly.
2021-03-09 18:04:25 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2021-03-09 18:05:15 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2021-03-09 18:05:39 WARNING (Recorder) [homeassistant.components.recorder.migration] Database is about to upgrade. Schema version: 9
2021-03-09 18:05:39 WARNING (Recorder) [homeassistant.components.recorder.migration] Adding index
ix_states_old_state_id
to database. Note: this can take several minutes on large databases and slow computers. Please be patient!2021-03-09 18:05:52 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: CREATE INDEX ix_states_old_state_id ON states (old_state_id)]
(Background on this error at: Error Messages — SQLAlchemy 1.3 Documentation)
2021-03-09 18:05:52 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup to sqlite:////config/home-assistant_v2.db: (sqlite3.DatabaseError) database disk image is malformed
[SQL: CREATE INDEX ix_states_old_state_id ON states (old_state_id)]
Here is configuration.yaml:
`mythuser@amethi:~/homeassistant$ cat configuration.yaml
Configure a default setup of Home Assistant (frontend, api, etc)
default_config:
Uncomment this if you are using SSL/TLS, running in Docker container, etc.
http:
base_url: example.duckdns.org:8123
Text to speech
tts:
- platform: google_translate
group: !include groups.yaml
automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml
panel_custom:
- name: zwave-graph-panel
url_path: zwave-graph
sidebar_title: Z-Wave Graph
sidebar_icon: mdi:z-wave
module_url: /local/zwavegraph3.js
config:ranker - pick one: network-simplex, tight-tree, longest-path
ranker: network-simplexedge_visibility - pick one: relevant, all
edge_visibility: relevantgrouping - pick one: z-wave, ungrouped
grouping: z-wave
Example configuration.yaml entry
logbook:
Basic configuration.yaml entry
history:
`