[MXS-4794] Scheduled events with SUPER-privilege definer can run during switchover Created: 2023-10-05 Updated: 2024-02-05 Resolved: 2024-02-02 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Monitor |
| Affects Version/s: | 22.08.4 |
| Fix Version/s: | 24.02.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Massimo | Assignee: | Esa Korhonen |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Sprint: | MXS-SPRINT-195, MXS-SPRINT-196, MXS-SPRINT-201 |
| Description |
|
The switch master breaks the replication if server has currently running events with super-privilege. During a switch call, the monitor disable the EVENTS on the actual master before proceeding to the switch, unfortunately this does not prevent that there are event running, and we will end up with a switch succeed but the Ex-master, get more GTID and the replication will be out of sync. after disable all the events, select * from information_Schema.processlist should tell if there are event running. based on that we or refuse the switch, or wait, or handle the event kill |
| Comments |
| Comment by Esa Korhonen [ 2023-12-11 ] |
|
Moving to backlog, as the issue was fixed by the user and there is no perfect solution on how MaxScale could detect running scheduled events. |
| Comment by Esa Korhonen [ 2024-02-02 ] |
|
Closing, documentation warns about this issue. |