Recorder could not start

Configuration
1

I just started getting the following notification in HA 0.115.3

Notification
Notification615×620 19.7 KB

I’m not getting any errors, when I run check config. Of the things listed, default_config is the only one even set up in my config.

2

What does the logs under Configuration -> Logs say?

3 
2020-09-25 11:37:12 WARNING (MainThread) [homeassistant.loader] You are using a custom integration for hacs which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant.
2020-09-25 11:37:12 WARNING (MainThread) [homeassistant.loader] You are using a custom integration for mail_and_packages which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant.
2020-09-25 11:37:13 WARNING (MainThread) [homeassistant.components.http] The 'base_url' option is deprecated, please remove it from your configuration
2020-09-25 11:37:22 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:37:22 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:37:22 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:37:23 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2020-09-25 11:37:33 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:37:33 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:37:33 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:37:43 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:37:43 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:37:43 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:37:54 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:37:54 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:37:54 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:04 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:04 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:04 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:12 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2020-09-25 11:38:15 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:15 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:15 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:26 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:26 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:26 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:36 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:36 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:36 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:47 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:47 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:47 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:57 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=137 from 2020-09-23 22:03:25.337728)
2020-09-25 11:38:57 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6)
2020-09-25 11:38:57 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE recorder_runs SET "end"=?, closed_incorrect=? WHERE recorder_runs.run_id = ?]
[parameters: ('2020-09-25 15:37:13.110761', 1, 137)]
(Background on this error at: http://sqlalche.me/e/13/4xp6) (retrying in 3 seconds)
2020-09-25 11:38:57 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:38:59 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:00 WARNING (MainThread) [homeassistant.components.template.binary_sensor] The 'entity_id' option is deprecated, please remove it from your configuration
2020-09-25 11:39:03 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2020-09-25 11:39:03 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not set up all dependencies.
2020-09-25 11:39:03 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2020-09-25 11:39:03 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not set up all dependencies.
2020-09-25 11:39:04 ERROR (MainThread) [homeassistant.config_entries] Error setting up entry ecobee for ecobee
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/pyecobee/__init__.py", line 564, in _request
    response.raise_for_status()
  File "/usr/local/lib/python3.8/site-packages/requests/models.py", line 941, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: https://api.ecobee.com/token?grant_type=refresh_token&refresh_token=0VQWXiXUhyTv6OhsBOmVnzl6Meijotu2&client_id=DJLwfDnUAWpPIveHMJRPwFA7wDf4utZw

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/config_entries.py", line 228, in async_setup
    result = await component.async_setup_entry(hass, self)  # type: ignore
  File "/usr/src/homeassistant/homeassistant/components/ecobee/__init__.py", line 58, in async_setup_entry
    if not await data.refresh():
  File "/usr/src/homeassistant/homeassistant/components/ecobee/__init__.py", line 105, in refresh
    if await self._hass.async_add_executor_job(self.ecobee.refresh_tokens):
  File "/usr/local/lib/python3.8/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/local/lib/python3.8/site-packages/pyecobee/__init__.py", line 159, in refresh_tokens
    response = self._request(
  File "/usr/local/lib/python3.8/site-packages/pyecobee/__init__.py", line 578, in _request
    raise InvalidTokenError(
pyecobee.errors.InvalidTokenError: ecobee tokens invalid; re-authentication required
2020-09-25 11:39:06 ERROR (MainThread) [homeassistant.components.automation] Platform automation does not generate unique IDs. ID living_double_up already exists - ignoring automation.living_room_double_up
2020-09-25 11:39:09 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of default_config. Setup failed for dependencies: history, logbook
2020-09-25 11:39:09 ERROR (MainThread) [homeassistant.setup] Setup failed for default_config: Could not set up all dependencies.
2020-09-25 11:39:43 WARNING (MainThread) [homeassistant.components.zwave] Z-Wave entity Zooz ZEN25 S2 Double Plug Unknown (node_id: 4) not ready after 30 seconds, continuing anyway```
4

Phuu, there’s a lot of problems with your system.

The base_url option has been deprecated for some time now, internal and external_url are set under homeassistant section, see an example here

The entity_id option for templates has been deprecated in v0.115, you need to adjust your templates accordingly.

For the logbook, history etc. Try:
Shutdown Home Assistant, delete home-assistant_v2.db, start again.

And you need to reinstall the EcoBee integration to re-authenticate, but I don’t own any EcoBee products and can therefore not help you with this.

1 Like
5

Thanks. I guess I’ve got some work to do.