Errors on upgrading to 0.42.3

Archive HASSbian
1

Hi all, just upgraded from 0.41 to 0.42.3 and seeing these errors

Running:

homeassistant@hassbian:~/.homeassistant $ hass --script check_config
Testing configuration at /home/homeassistant/.homeassistant
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up mqtt
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up binary_sensor
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up discovery
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up group
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up sensor
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up switch
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up automation
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up blink
17-04-14 09:32:16 INFO (MainThread) [homeassistant.setup] Setting up http
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up updater
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up notify
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up script
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up zone
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up ifttt
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up nest
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up sun
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up recorder
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up websocket_api
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up api
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up camera
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up config
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up device_tracker
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up history
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up frontend
17-04-14 09:32:17 INFO (MainThread) [homeassistant.setup] Setting up logbook

And the log appears to be empty.

I do a manual restart of HASS and see:

17-04-14 09:36:19 INFO (Recorder) [homeassistant.components.recorder.migration] Upgrading recorder db schema to version 2
17-04-14 09:36:19 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) index ix_recorder_runs_start_end already exists [SQL: ‘CREATE INDEX ix_recorder_runs_start_end ON recorder_runs (start, “end”)’]
17-04-14 09:36:19 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) index ix_recorder_runs_start_end already exists [SQL: ‘CREATE INDEX ix_recorder_runs_start_end ON recorder_runs (start, “end”)’] (retrying in 3 seconds)
17-04-14 09:36:20 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.

And:

17-04-14 09:36:40 INFO (MainThread) [homeassistant.core] Bus:Handling <Event service_executed[L]: service_call_id=1980479568-2>
17-04-14 09:36:40 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of history. Setup failed for dependencies: recorder
17-04-14 09:36:40 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not setup all dependencies.
17-04-14 09:36:40 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of logbook. Setup failed for dependencies: recorder
17-04-14 09:36:40 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not setup all dependencies.

2

@robmarkcole, if you can live with it, delete or rename your database file.

1 Like
3

HASS will create a new .db?

4

Yes it does, but you loose your complete history.

5

OK that fixed it, cheers!

6

Hi
I m getting these errors after update

17-04-14 23:50:14 ERROR (MainThread) [homeassistant.setup] Error during setup of component mqtt
Traceback (most recent call last):
  File "/srv/homeassistant/lib/python3.4/site-packages/homeassistant/setup.py", line 189, in _async_setup_component
result = yield from component.async_setup(hass, processed_config)
  File "/srv/homeassistant/lib/python3.4/site-packages/homeassistant/components/mqtt/__init__.py", line 350, in async_setup
will_message, birth_message, tls_version)
  File "/srv/homeassistant/lib/python3.4/site-packages/homeassistant/components/mqtt/__init__.py", line 426, in __init__
proto = mqtt.MQTTv311
AttributeError: 'module' object has no attribute 'MQTTv311'
17-04-14 23:50:16 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of sensor.mqtt. Setup failed for dependencies: mqtt
17-04-14 23:50:16 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform sensor.mqtt: Could not setup all dependencies.
17-04-14 23:50:16 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of sensor.mqtt. Setup failed for dependencies: mqtt
17-04-14 23:50:16 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform sensor.mqtt: Could not setup all dependencies.
17-04-14 23:50:26 WARNING (MainThread) [homeassistant.setup] Setup of switch is taking over 10 seconds.
17-04-14 23:50:26 WARNING (MainThread) [homeassistant.setup] Setup of sensor is taking over 10 seconds.
17-04-14 23:50:27 WARNING (MainThread) [homeassistant.setup] Setup of device_tracker is taking over 10 seconds.
17-04-14 23:51:39 WARNING (MainThread) [homeassistant.setup] Setup of media_player is taking over 10 seconds.