So I just did an update from .87.1 to .100.3. Big jump I know but .87 was solid for me and I wasn’t yet using anything new.
Well that changed I performed the update and now I’m chasing breaking changes, some with no luck, others have been resolved.
My biggest issue right now is with the DB. After the update I was getting an “Database Locked” error.
To attempt to resolve this I backed up the DB, removed it and restarted HA.
While I no longer have a “DB Locked” errors in the logs I do have a host of these errors:
Error in database connectivity: (sqlite3.OperationalError) no such table: events
[SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: ('state_changed', '{"entity_id": "sensor.watches", "old_state": {"entity_id": "sensor.watches", "state": "", "attributes": {"alert detail": "", "alert time": "", "attri ... (691 characters truncated) ... :00", "last_updated": "2019-10-27T15:29:15.314439+00:00", "context": {"id": "4f7d777534274cf986d21b67300dcafd", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-10-27 15:29:15.314454', '2019-10-27 17:48:49.497372', '4f7d777534274cf986d21b67300dcafd', None)]
(Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
Error executing query: (sqlite3.OperationalError) no such table: events
[SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: ('state_changed', '{"entity_id": "sensor.watches", "old_state": {"entity_id": "sensor.watches", "state": "", "attributes": {"alert detail": "", "alert time": "", "attri ... (691 characters truncated) ... :00", "last_updated": "2019-10-27T15:29:15.314439+00:00", "context": {"id": "4f7d777534274cf986d21b67300dcafd", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-10-27 15:29:15.314454', '2019-10-27 17:48:49.497372', '4f7d777534274cf986d21b67300dcafd', None)]
(Background on this error at: http://sqlalche.me/e/e3q8)
Error in database update. Could not save after 11 tries. Giving up
There are so many of these errors I can’t find entries for my other issues