Error Maxscale 24.02.3 gtid_position

20 views
Skip to first unread message

Vincent Romero

unread,
Nov 18, 2024, 4:41:15 PM11/18/24
to MariaDB MaxScale
Version: MaxScale 24.02.3



2024-11-18 18:33:38   error  : [mariadbmon] Could not query events of 'bd02': Query 'SELECT Event_schema, Event_name FROM information_schema.EVENTS WHERE Status = 'ENABLED';' failed: 'Cannot proceed, because event scheduler is disabled'. Event handling can be disabled by setting 'handle_events' to false, will keep retrying with this message suppressed.
2024-11-18 18:33:38   warning: [mariadbmon] Server 'bd01' (10.1.48-MariaDB-0ubuntu0.18.04.1) does not support MariaDB gtid.
2024-11-18 18:33:38   error  : [mariadbmon] The backend cluster does not support failover/switchover due to the following reason(s):\nThe version of 'bd01' (10.1.48-MariaDB-0ubuntu0.18.04.1) is not supported. Failover/switchover requires MariaDB Server 10.4 or later.\n
2024-11-18 18:33:38   notice : [mariadbmon] Disabling automatic cluster operations for 5 monitor ticks.
2024-11-18 18:33:38   warning: [mariadbmon] Query 'SELECT c.VARIABLE_VALUE, s.VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES c JOIN INFORMATION_SCHEMA.GLOBAL_STATUS s ON(c.VARIABLE_NAME = 'rpl_semi_sync_master_enabled' AND s.VARIABLE_NAME = 'rpl_semi_sync_master_status')' did not return any rows.


maxctrl list servers
┌────────┬────────────────┬──────┬─────────────┬─────────────────┬─────────────┬────────────┐
│ Server │ Address        │ Port │ Connections │ State           │ GTID        │ Monitor    │
├────────┼────────────────┼──────┼─────────────┼─────────────────┼─────────────┼────────────┤
│ bd01   │ 192.168.10.6   │ 3306 │ 0           │ Master, Running │             │ om-monitor │
├────────┼────────────────┼──────┼─────────────┼─────────────────┼─────────────┼────────────┤
│ bd02   │ 192.168.10.150 │ 3306 │ 0           │ Slave, Running  │ 0-1-3900185 │ om-monitor │
└────────┴────────────────┴──────┴─────────────┴─────────────────┴─────────────┴────────────┘
Reply all
Reply to author
Forward
0 new messages