HA code continually restarting due to issue with Maria DB

1

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

2

These constantly show up in the MariaDB add on logs

2023-05-06 8:31:21 0 [Note] mysqld: ready for connections.
Version: ‘10.6.12-MariaDB’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 MariaDB Server
[08:31:30] INFO: Service mariadb exited with code 256 (by signal 9)
[08:31:32] INFO: Starting MariaDB
2023-05-06 8:31:34 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision

3

Hi,

Were you able to solve this in the meantime? I am having the same issue for months already.