Getting lots of sql errors since upgrading to 0.92. Assuming that home-assistant_v2.db
was corrupted, I deleted it and restarted several times. The home-assistant_v2.db
file was recreated each time, but the errors persist.
Example errors from the log:
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:12.024002', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:12.024002', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:09.012289', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:09.012289', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:06.000906', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:06.000906', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:02.992789', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
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": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:02.992789', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database update. Could not save after 11 tries. Giving up
4:23 PM components/recorder/__init__.py (ERROR)
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.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:23:02.989722', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
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.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:23:02.989722', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
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.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:22:59.981485', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:22 PM components/recorder/__init__.py (ERROR)
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.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:22:59.981485', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:22 PM components/recorder/util.py (ERROR)
1 reply