I have the following error messages:
Logger: homeassistant.components.recorder
Source: components/recorder/__init__.py:524
Integration: Recorder (documentation, issues)
First occurred: April 4, 2021, 9:17:45 PM (19 occurrences)
Last logged: April 4, 2021, 9:25:40 PM
Error in database connectivity during commit: 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2021-04-05 01:24:44.888194', '2021-04-05 01:24:44.888194', '47a0adfab17660207a182c0dc690dccf', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8). (retrying in 3 seconds)
Error in database connectivity during commit: 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2021-04-05 01:25:08.969368', '2021-04-05 01:25:08.969368', '4839a5ed7ab160b45a853068de329da2', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8). (retrying in 3 seconds)
Error in database connectivity during commit: 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2021-04-05 01:25:10.705532', '2021-04-05 01:25:10.705532', 'a394e194c50a3150ba29e3e4399e2657', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8). (retrying in 3 seconds)
Error in database connectivity during commit: 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2021-04-05 01:25:35.054233', '2021-04-05 01:25:35.054233', '2fa15f6c4825e96f05d687a2ca2fe785', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8). (retrying in 3 seconds)
Error in database connectivity during commit: 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2021-04-05 01:25:39.024199', '2021-04-05 01:25:39.024199', 'e756807858864762029d28ae3a9b3ae3', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8). (retrying in 3 seconds)
I have tried deleting the database using
rm /config/home-assistant_v2.db
and then restarting and it doesn’t seem to fix the problem. There is nothing under the ‘Logbook’ or ‘History’ sections. I have 9 motion sensors that have also stopped showing any data or connectivity, not sure if the two problems are connected or not.