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.