HASS not starting, database issue?

Installation Home Assistant OS
1

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?

2

I’ve just posted a boot issue on a separate thread but noticed on here you have a similar problem. Mine too mentions similar malformed XML but has shown this before and not presented an issue so i had discounted it, but it could be relevant?

    2018-01-30 20:34:03 WARNING (SyncWorker_15) [netdisco.ssdp] Found malformed XML at http://192.168.1.221:9080: status=ok
3

Mine is related to my Roku stick, and has displayed that error before. What device is associated with that IP?

4

Hi, i would need to check but either chrome cast or fire tv. Nothing to do with hassio, which is why i had ignored it before

5

has anyone managed to locate that sqlite3.database file and see if one can fix the problem by simply deleting that database file?