homeassistant broken database

[David Nordin]

Hi

Love proxySQL!

I encountered something I don't quite understand myself but is likely explainable.

I use proxySQL for MySQL.
On top I have two machines running keepalived and proxysql
proxysql offers via VIP.
the two proxysql services are in native-cluster mode with primary/backup against MySQL.
The two MySQL-servers with "group-replication" method master-master

When I connect home assistant directly to MySQL it generates a database and runs smoothly but when I use the VIP that points to proxySQL with port it gets broken directly:

Homeassistant:
`Error executing compile statistics: (MySQLdb.OperationalError) (3098, 'The table does not comply with the requirements by an external plugin.') [SQL: INSERT INTO statistics_short_term (created, created_ts, metadata_id, start, start_ts, mean, min, max, last_reset, last_reset_ts, state, sum) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)] [parameters: (None, 1734125710.1015248, 1143, None, 1734125400.0, None, None, None, None, None, 42438.932, 0.5429999999978463)] (Background on this error at: https://sqlalche.me/e/20/e3q8)`

simple tail -f /var/lib/proxysql/proxysql.log:
`2024-12-13 21:40:10 MySQL_Session.cpp:4872:handler_minus1_LogErrorDuringQuery(): [WARNING] Error during query on (1,192.168.86.78,3306,15765): 3098, The table does not comply with the requirements by an external plugin.`

I'm quite new to this so it goes way beyond my skills but I gather proxysql is changing the queries into  an unsupported format?