HI just recently discovered I have this error in the log. Anyone knowing what causes this and how to fix it?
Logger: homeassistant.components.recorder
Source: components/recorder/init.py:509
Integration: Recorder (documentation, issues)
First occurred: 17:23:02 (1 occurrences)
Last logged: 17:23:02
Error saving events: (sqlite3.DatabaseError) database disk image is malformed [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’, ‘2020-11-15 16:23:01.729844’, ‘2020-11-15 16:23:01.729844’, ‘b744006afd1c220a43a6a4ee0a7209f2’, None, None)] (Background on this error at: http://sqlalche.me/e/13/4xp6)
Traceback (most recent call last): File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context self.dialect.do_execute( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py”, line 593, in do_execute cursor.execute(statement, parameters) sqlite3.DatabaseError: database disk image is malformed The above exception was the direct cause of the following exception: Traceback (most recent call last): File “/usr/src/homeassistant/homeassistant/components/recorder/init.py”, line 454, in _commit_event_session_or_retry self._commit_event_session() File “/usr/src/homeassistant/homeassistant/components/recorder/init.py”, line 509, in _commit_event_session self.event_session.flush() File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2536, in flush self._flush(objects) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2678, in flush transaction.rollback(capture_exception=True) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in exit compat.raise( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise raise exception File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2638, in flush flush_context.execute() File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 419, in execute n.execute_aggregate(self, set) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 521, in execute_aggregate self.execute(uow) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 586, in execute persistence.save_obj( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 239, in save_obj _emit_insert_statements( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 1135, in _emit_insert_statements result = cached_connections[connection].execute( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1011, in execute return meth(self, multiparams, params) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py”, line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1124, in _execute_clauseelement ret = self._execute_context( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1316, in _execute_context self.handle_dbapi_exception( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1510, in handle_dbapi_exception util.raise( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise raise exception File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context self.dialect.do_execute( File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py”, line 593, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed [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’, ‘2020-11-15 16:23:01.729844’, ‘2020-11-15 16:23:01.729844’, ‘b744006afd1c220a43a6a4ee0a7209f2’, None, None)] (Background on this error at: http://sqlalche.me/e/13/4xp6)