Recorder does not start on 0.41 and above

[Phontana]

I upgraded my docker container to 0.42.3, but the log shows the message below. I'm running Home Assistant in Docker Toolbox on macOS. I also tried running 0.41, 0.42, 0.42.1 and 0.42.2, but all of them show the same error message. I am now on 0.40.2 and that version does work. Can some help me with this?

17-04-12 20:19:54 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error [SQL: '\nCREATE TABLE events (\n\tevent_id INTEGER NOT NULL, \n\tevent_type VARCHAR(32), \n\tevent_data TEXT, \n\torigin VARCHAR(32), \n\ttime_fired DATETIME, \n\tcreated DATETIME, \n\tPRIMARY KEY (event_id)\n)\n\n'] (retrying in 3 seconds)
17-04-12 20:19:57 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:00 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:03 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:04 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
17-04-12 20:20:06 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:09 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:12 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:15 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:18 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:21 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (sqlite3.OperationalError) disk I/O error (retrying in 3 seconds)
17-04-12 20:20:21 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Component failed to initialize.
17-04-12 20:20:21 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of history. Setup failed for dependencies: recorder
17-04-12 20:20:21 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not setup all dependencies.
17-04-12 20:20:21 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of logbook. Setup failed for dependencies: recorder
17-04-12 20:20:21 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not setup all dependencies.

[Phontana]

Could it be related to #6519? This is the only change I see in the changelog for 0.41 regarding SQLite.

[electricJP]

Got the same issue (logbook and history were failing too), solved by deleting DB and restarting HA.

[Phontana]

That does not work for me. I tried using a fresh install as well, but got the same issue. I found out that it has to do with boot2docker, maybe it doesn't have the correct access to the configuration folder?

[Phontana]

I fixed it by switching to MySQL instead of SQLite.

[DePingus]

I fixed it in ubuntu by deleting (backed up first) both home-assistant.db and home-assistant_v2.db.