I have not been able to get into the GUI for a while now and I can’t seem to figure out why. I’ve restarted several times, power cycled, etc… and the GUI hangs on “connecting”. My log showed that the database was corrupted so I stopped HA, deleted the database, and restarted with no change in behavior. I didn’t make any changes between the time it was working and not.
Below is my log before deleting the database,
2018-01-30 08:57:15 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=81 from 2018-01-30 02:23:17.123922)
2018-01-30 08:57:51 WARNING (MainThread) [homeassistant.components.media_player] Setup of platform cast is taking over 10 seconds.
2018-01-30 08:58:02 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (?, ?, ?, ?, ?)'] [parameters: ('service_registered', '{"domain": "recorder", "service": "purge"}', 'LOCAL', '2018-01-30 14:57:14.809413', '2018-01-30 14:58:01.996331')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-01-30 08:58:11 WARNING (SyncWorker_16) [netdisco.ssdp] Error fetching description at http://127.0.0.1:58080/dd1ac56da4.xml
and after,
2018-01-30 09:03:23 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=1 from 2018-01-30 15:02:06.708191)
2018-01-30 09:03:57 WARNING (MainThread) [homeassistant.components.media_player] Setup of platform cast is taking over 10 seconds.
2018-01-30 09:04:16 WARNING (SyncWorker_5) [netdisco.ssdp] Error fetching description at http://127.0.0.1:58080/dd1ac56da4.xml
2018-01-30 09:09:30 WARNING (SyncWorker_9) [netdisco.ssdp] Error fetching description at https://192.168.29.5:8888
any suggestions?