Hi there!
I have the same records in the HA log.
I installed HA on OrangePi3b with sdcard as a disk by adding containers step by step.
Now I have
1)Home Assistant 2023.10.5
2)MARIADB_VERSION: 1:11.1.2+maria~ubu2204
At first glance all looks not so bad but this repeatable issue in the log points to some abnormal things
Could you share ideas and thoughts about what it could be and how it could be fixed?
Below is one fragment of this issue from HA log:
2023-11-28T17:01:50.929177718Z s6-rc: info: service legacy-services: stopping
2023-11-28T17:01:51.006980068Z 2023-11-28 21:01:50.992 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (2013, 'Lost connection to server during query')
2023-11-28T17:01:51.013885540Z [SQL: SELECT event_types.event_type_id, event_types.event_type
2023-11-28T17:01:51.014003081Z FROM event_types
2023-11-28T17:01:51.014030790Z WHERE event_types.event_type IN (%s)]
2023-11-28T17:01:51.014052081Z [parameters: ('homeassistant_stop',)]
2023-11-28T17:01:51.014072206Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.046399241Z 2023-11-28 21:01:51.038 WARNING (Thread-2 (_thread_main)) [homeassistant.components.mqtt.client] Disconnected from MQTT server 192.168.1.59:1883 (7)
2023-11-28T17:01:51.110555731Z 2023-11-28 21:01:51.098 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
2023-11-28T17:01:51.232021862Z 2023-11-28 21:01:51.209 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
2023-11-28T17:01:51.599574617Z 2023-11-28 21:01:51.224 ERROR (Recorder) [homeassistant.components.recorder.core] SQLAlchemyError error processing task EventTask(event=<Event homeassistant_stop[L]>): Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
2023-11-28T17:01:51.599726867Z Traceback (most recent call last):
2023-11-28T17:01:51.599756325Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 904, in _process_one_task_or_recover
2023-11-28T17:01:51.599777908Z return task.run(self)
2023-11-28T17:01:51.599798616Z ^^^^^^^^^^^^^^
2023-11-28T17:01:51.599817866Z File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 281, in run
2023-11-28T17:01:51.599837700Z instance._process_one_event(self.event)
2023-11-28T17:01:51.599857241Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1014, in _process_one_event
2023-11-28T17:01:51.599877658Z self._process_non_state_changed_event_into_session(event)
2023-11-28T17:01:51.599897491Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1029, in _process_non_state_changed_event_into_session
2023-11-28T17:01:51.599917616Z elif event_type_id := event_type_manager.get(event.event_type, session, True):
2023-11-28T17:01:51.599936866Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600036907Z File "/usr/src/homeassistant/homeassistant/components/recorder/table_managers/event_types.py", line 54, in get
2023-11-28T17:01:51.600059365Z return self.get_many((event_type,), session)[event_type]
2023-11-28T17:01:51.600194406Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600223281Z File "/usr/src/homeassistant/homeassistant/components/recorder/table_managers/event_types.py", line 82, in get_many
2023-11-28T17:01:51.600254781Z for event_type_id, event_type in execute_stmt_lambda_element(
2023-11-28T17:01:51.600276656Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600310198Z File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 221, in execute_stmt_lambda_element
2023-11-28T17:01:51.600331781Z executed = session.connection().execute(stmt)
2023-11-28T17:01:51.600351614Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600370572Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1412, in execute
2023-11-28T17:01:51.600389239Z return meth(
2023-11-28T17:01:51.600407614Z ^^^^^
2023-11-28T17:01:51.600435322Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/lambdas.py", line 604, in _execute_on_connection
2023-11-28T17:01:51.600454864Z return connection._execute_clauseelement(
2023-11-28T17:01:51.600473530Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600492489Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1635, in _execute_clauseelement
2023-11-28T17:01:51.600511739Z ret = self._execute_context(
2023-11-28T17:01:51.600529822Z ^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600548488Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1808, in _execute_context
2023-11-28T17:01:51.600567738Z conn = self._revalidate_connection()
2023-11-28T17:01:51.600586113Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.600604780Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 665, in _revalidate_connection
2023-11-28T17:01:51.600623738Z self._invalid_transaction()
2023-11-28T17:01:51.600642405Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 655, in _invalid_transaction
2023-11-28T17:01:51.600661655Z raise exc.PendingRollbackError(
2023-11-28T17:01:51.600680905Z sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
2023-11-28T17:01:51.630038785Z 2023-11-28 21:01:51.623 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (2013, "Lost connection to server at 'handshake: reading initial communication packet', system error: 11")
2023-11-28T17:01:51.630271243Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.750580045Z 2023-11-28 21:01:51.747 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (2013, "Lost connection to server at 'handshake: reading initial communication packet', system error: 11")
2023-11-28T17:01:51.750676586Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.871637261Z 2023-11-28 21:01:51.851 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:51.889846229Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.963829511Z 2023-11-28 21:01:51.853 ERROR (Recorder) [homeassistant.components.recorder.core] Unhandled database error while processing task EventTask(event=<Event homeassistant_final_write[L]>): (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:51.973143265Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.973220265Z Traceback (most recent call last):
2023-11-28T17:01:51.973243890Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
2023-11-28T17:01:51.973265473Z self._dbapi_connection = engine.raw_connection()
2023-11-28T17:01:51.973285306Z ^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973305723Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3288, in raw_connection
2023-11-28T17:01:51.973325556Z return self.pool.connect()
2023-11-28T17:01:51.973344806Z ^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973364348Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 452, in connect
2023-11-28T17:01:51.973383598Z return _ConnectionFairy._checkout(self)
2023-11-28T17:01:51.973403139Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973422681Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1267, in _checkout
2023-11-28T17:01:51.973442806Z fairy = _ConnectionRecord.checkout(pool)
2023-11-28T17:01:51.973461764Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973480430Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 721, in checkout
2023-11-28T17:01:51.973499389Z with util.safe_reraise():
2023-11-28T17:01:51.973518347Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2023-11-28T17:01:51.973537597Z raise exc_value.with_traceback(exc_tb)
2023-11-28T17:01:51.973557139Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 719, in checkout
2023-11-28T17:01:51.973576680Z dbapi_connection = rec.get_connection()
2023-11-28T17:01:51.973666513Z ^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973688388Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 839, in get_connection
2023-11-28T17:01:51.973708805Z self.__connect()
2023-11-28T17:01:51.973727763Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
2023-11-28T17:01:51.973746721Z with util.safe_reraise():
2023-11-28T17:01:51.973765388Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2023-11-28T17:01:51.973784346Z raise exc_value.with_traceback(exc_tb)
2023-11-28T17:01:51.973814971Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
2023-11-28T17:01:51.973835971Z self.dbapi_connection = connection = pool._invoke_creator(self)
2023-11-28T17:01:51.973858137Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973877096Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 637, in connect
2023-11-28T17:01:51.973896345Z return dialect.connect(*cargs, **cparams)
2023-11-28T17:01:51.973914720Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973933679Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 615, in connect
2023-11-28T17:01:51.973952637Z return self.loaded_dbapi.connect(*cargs, **cparams)
2023-11-28T17:01:51.973971304Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.973989970Z File "/usr/local/lib/python3.11/site-packages/MySQLdb/__init__.py", line 121, in Connect
2023-11-28T17:01:51.974008928Z return Connection(*args, **kwargs)
2023-11-28T17:01:51.974027595Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974045678Z File "/usr/local/lib/python3.11/site-packages/MySQLdb/connections.py", line 193, in __init__
2023-11-28T17:01:51.974064928Z super().__init__(*args, **kwargs2)
2023-11-28T17:01:51.974083303Z MySQLdb.OperationalError: (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:51.974118011Z
2023-11-28T17:01:51.974181303Z The above exception was the direct cause of the following exception:
2023-11-28T17:01:51.974202886Z
2023-11-28T17:01:51.974221552Z Traceback (most recent call last):
2023-11-28T17:01:51.974240802Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 904, in _process_one_task_or_recover
2023-11-28T17:01:51.974260052Z return task.run(self)
2023-11-28T17:01:51.974278427Z ^^^^^^^^^^^^^^
2023-11-28T17:01:51.974297094Z File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 281, in run
2023-11-28T17:01:51.974316635Z instance._process_one_event(self.event)
2023-11-28T17:01:51.974384885Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1014, in _process_one_event
2023-11-28T17:01:51.974407052Z self._process_non_state_changed_event_into_session(event)
2023-11-28T17:01:51.974426593Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1029, in _process_non_state_changed_event_into_session
2023-11-28T17:01:51.974446427Z elif event_type_id := event_type_manager.get(event.event_type, session, True):
2023-11-28T17:01:51.974465968Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974484635Z File "/usr/src/homeassistant/homeassistant/components/recorder/table_managers/event_types.py", line 54, in get
2023-11-28T17:01:51.974503885Z return self.get_many((event_type,), session)[event_type]
2023-11-28T17:01:51.974522843Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974546759Z File "/usr/src/homeassistant/homeassistant/components/recorder/table_managers/event_types.py", line 82, in get_many
2023-11-28T17:01:51.974566593Z for event_type_id, event_type in execute_stmt_lambda_element(
2023-11-28T17:01:51.974585551Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974603926Z File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 221, in execute_stmt_lambda_element
2023-11-28T17:01:51.974623468Z executed = session.connection().execute(stmt)
2023-11-28T17:01:51.974641551Z ^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974659634Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1985, in connection
2023-11-28T17:01:51.974678884Z return self._connection_for_bind(
2023-11-28T17:01:51.974697551Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974774842Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2001, in _connection_for_bind
2023-11-28T17:01:51.974809550Z return trans._connection_for_bind(engine, execution_options)
2023-11-28T17:01:51.974831133Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974850675Z File "<string>", line 2, in _connection_for_bind
2023-11-28T17:01:51.974870800Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
2023-11-28T17:01:51.974890050Z ret_value = fn(self, *arg, **kw)
2023-11-28T17:01:51.974908716Z ^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.974927091Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1126, in _connection_for_bind
2023-11-28T17:01:51.974946341Z conn = bind.connect()
2023-11-28T17:01:51.974964716Z ^^^^^^^^^^^^^^
2023-11-28T17:01:51.974983674Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3264, in connect
2023-11-28T17:01:51.975002633Z return self._connection_cls(self)
2023-11-28T17:01:51.975081966Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975103257Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
2023-11-28T17:01:51.975123674Z Connection._handle_dbapi_exception_noconnection(
2023-11-28T17:01:51.975142924Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2426, in _handle_dbapi_exception_noconnection
2023-11-28T17:01:51.975161882Z raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
2023-11-28T17:01:51.975180549Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
2023-11-28T17:01:51.975199507Z self._dbapi_connection = engine.raw_connection()
2023-11-28T17:01:51.975218173Z ^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975259590Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3288, in raw_connection
2023-11-28T17:01:51.975280007Z return self.pool.connect()
2023-11-28T17:01:51.975298673Z ^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975318215Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 452, in connect
2023-11-28T17:01:51.975337173Z return _ConnectionFairy._checkout(self)
2023-11-28T17:01:51.975355548Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975374214Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1267, in _checkout
2023-11-28T17:01:51.975393173Z fairy = _ConnectionRecord.checkout(pool)
2023-11-28T17:01:51.975411548Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975429923Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 721, in checkout
2023-11-28T17:01:51.975449464Z with util.safe_reraise():
2023-11-28T17:01:51.975467839Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2023-11-28T17:01:51.975486506Z raise exc_value.with_traceback(exc_tb)
2023-11-28T17:01:51.975505464Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 719, in checkout
2023-11-28T17:01:51.975524714Z dbapi_connection = rec.get_connection()
2023-11-28T17:01:51.975543089Z ^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975561755Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 839, in get_connection
2023-11-28T17:01:51.975581005Z self.__connect()
2023-11-28T17:01:51.975599672Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
2023-11-28T17:01:51.975618922Z with util.safe_reraise():
2023-11-28T17:01:51.975637297Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2023-11-28T17:01:51.975656838Z raise exc_value.with_traceback(exc_tb)
2023-11-28T17:01:51.975724505Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
2023-11-28T17:01:51.975745796Z self.dbapi_connection = connection = pool._invoke_creator(self)
2023-11-28T17:01:51.975765338Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975784588Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 637, in connect
2023-11-28T17:01:51.975804129Z return dialect.connect(*cargs, **cparams)
2023-11-28T17:01:51.975822796Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975841463Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 615, in connect
2023-11-28T17:01:51.975860712Z return self.loaded_dbapi.connect(*cargs, **cparams)
2023-11-28T17:01:51.975879671Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975898046Z File "/usr/local/lib/python3.11/site-packages/MySQLdb/__init__.py", line 121, in Connect
2023-11-28T17:01:51.975923129Z return Connection(*args, **kwargs)
2023-11-28T17:01:51.975942087Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-11-28T17:01:51.975961629Z File "/usr/local/lib/python3.11/site-packages/MySQLdb/connections.py", line 193, in __init__
2023-11-28T17:01:51.975981170Z super().__init__(*args, **kwargs2)
2023-11-28T17:01:51.975999545Z sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:51.976018795Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-11-28T17:01:51.990625694Z 2023-11-28 21:01:51.988 ERROR (Recorder) [homeassistant.components.recorder.core] Error in database connectivity during commit: Error executing query: (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:51.990824027Z (Background on this error at: https://sqlalche.me/e/20/e3q8). (retrying in 3 seconds)
2023-11-28T17:01:55.002894322Z 2023-11-28 21:01:54.990 ERROR (Recorder) [homeassistant.components.recorder.core] Error saving the event session during shutdown: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:55.003246654Z (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a)
2023-11-28T17:01:55.003360695Z Traceback (most recent call last):
2023-11-28T17:01:55.003461028Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1429, in _end_session
2023-11-28T17:01:55.003563986Z self._commit_event_session_or_retry()
2023-11-28T17:01:55.003658194Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1155, in _commit_event_session_or_retry
2023-11-28T17:01:55.003753860Z self._commit_event_session()
2023-11-28T17:01:55.004021026Z File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1175, in _commit_event_session
2023-11-28T17:01:55.004127484Z session.commit()
2023-11-28T17:01:55.004221692Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1923, in commit
2023-11-28T17:01:55.004316483Z trans.commit(_to_root=True)
2023-11-28T17:01:55.004407774Z File "<string>", line 2, in commit
2023-11-28T17:01:55.004501399Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 103, in _go
2023-11-28T17:01:55.004596190Z self._raise_for_prerequisite_state(fn.__name__, current_state)
2023-11-28T17:01:55.004688065Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 912, in _raise_for_prerequisite_state
2023-11-28T17:01:55.004779356Z raise sa_exc.PendingRollbackError(
2023-11-28T17:01:55.004869773Z sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb.OperationalError) (2002, "Can't connect to server on '192.168.1.59' (115)")
2023-11-28T17:01:55.004971855Z (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a)