GTID monitoring: @@read_only parsing error in MaxScale 24.02.6

8 views
Skip to first unread message

MariaDB MaxScale

unread,
Sep 4, 2025, 10:36:08 AM (4 days ago) Sep 4
to MariaDB MaxScale
Hello guys,
I would like to report an issue I am experiencing with the Docker version of MariaDB MaxScale 24.02.6 together with the Docker server version of MariaDB 12.0.2.

It seems that MaxScale is no longer able to correctly fetch the GTID.
In the log file /var/log/maxscale/maxscale.log, I can see the following errors:

On the master DB:

2025-09-04 10:21:10 warning: [mariadbmon] Error during monitor update of server 'dbmasterhost': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' returned invalid data: Cannot convert field 'OFF' to boolean.

On the slave DB:

2025-09-04 10:21:16 warning: [mariadbmon] Error during monitor update of server 'dbslavehost': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' returned invalid data: Cannot convert field 'OFF' to boolean.

The issue appears to be related to the value of @@read_only, which is being returned as a VARCHAR(2) instead of a BIGINT UNSIGNED as with the other values.

Looking into the GitHub repository, I was able to trace the query to this part of the code: https://github.com/mariadb-corporation/MaxScale/blob/24.02/server/modules/monitor/mariadbmon/mariadbserver.cc#L573

Is there a possible fix for this, or do you have a workaround available?

At the moment, MaxScale is unusable and cannot resynchronize the master and slave databases.

Thank you in advance for your support.

Reply all
Reply to author
Forward
0 new messages