Hi There,
Since upgrading to HA 2023.5 and Maria DB 2.6 I’ve been having HA restart continuously.
I’ve restarted my PI and even reinstalled MariaDB but it keeps happening.
This is in my logs
Unhandled database error while processing task KeepAliveTask(): (MySQLdb.OperationalError) (2013, ‘Lost connection to MySQL server during query’) [SQL: SELECT 1] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
Traceback (most recent call last):
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py”, line 1963, in _exec_single_context
self.dialect.do_execute(
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py”, line 920, in do_execute
cursor.execute(statement, parameters)
File “/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/usr/local/lib/python3.10/site-packages/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (2013, ‘Lost connection to MySQL server during query’)
After enough occurrences, Maria Db will either restart or HA will restart.
Anyone else experiencing this.
Thanks