MaxScale 24.02.6 is not compatible with MariaDB 12.0.2: Monitor fails with 'Cannot convert field ON to boolean'

Environment:

MaxScale Version: 24.02.6~bookworm-1 (built using CMake)

MariaDB Server Version: 12.0.2

Operating System: Debian 12 (Bookworm)

Steps to Reproduce:

Upgrade a MariaDB database server from version 11.x (e.g., 11.8) to 12.0.2.

Ensure MaxScale 24.02.6 is configured with MariaDBMon monitor to watch the upgraded database.

Restart MaxScale service.

Expected Behavior:

MaxScale's monitor should successfully connect to the MariaDB 12.0.2 server and report its status without errors.

Actual Behavior:

The MariaDBMon monitor fails to connect and reports an error in the MaxScale log. The monitor is unable to correctly interpret the value of the @@read_only system variable, as it now returns the string 'ON' instead of the numeric value '1'.

Error log Snippet:
[mariadbmon] Error during monitor update of server 'db': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' returned invalid data: Cannot convert field 'ON' to boolean.

Additional Information:
This issue did not occur on MariaDB 11.8. It only appeared after upgrading to version 12.0.2, which changed the format of the @@read_only variable. It appears that MaxScale 24.02.6 has not been updated to handle this new format.

Versions below 24.02.6
Versions 22.08.17 and 23.x, on the other hand, cannot read the GTID number

warning: [mariadbmon] Automatic rejoin was not attempted on server 'db' even though it is a valid candidate. Will keep retrying with this message suppressed for all servers. Errors: 'db' does not have a valid gtid_current_pos.