Elena Stepanova added a comment - 2020-03-07 18:51 Thanks for the report. The regression was introduced by this commit: commit 0fd5b11eb05be8e8e996b26d845aae3b863448d3 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Fri Sep 6 14:54:22 2019 +0300   MDEV-20511: Galera replication of events is not consistent After SST from master node (the one where event is ENABLED) - you will end up with the event enabled on two nodes, hence it's now being executed twice. It can be solved by comparing event's originator with server_id. if not equal, then change its status to 'SLAVESIDE_DISABLED' The change makes all events which were created by a server with a different server_id to get disabled. Moreover, they remain disabled even if the server is later started with the initial server_id again. create event ev on schedule every 1 minute do set @a= 1; select name , originator, status from mysql.event;   --let $server_id= `SELECT @@global.server_id`   --echo # --echo # Restarting server with server_id=100 --echo # --let $restart_parameters= --server-id=100 --source include/restart_mysqld.inc   select @@ global .server_id; select name , originator, status from mysql.event; --eval set global server_id= $server_id   --echo # --echo # Restarting server with the original server_id=$server_id --echo # --let $restart_parameters= --source include/restart_mysqld.inc   select @@ global .server_id; select name , originator, status from mysql.event;   # Cleanup drop event ev; 10.2 8382f106 select name , originator, status from mysql.event; name originator status ev 1 ENABLED # # Restarting server with server_id=100 # select @@ global .server_id; @@ global .server_id 100 select name , originator, status from mysql.event; name originator status ev 1 SLAVESIDE_DISABLED set global server_id= 1; # # Restarting server with the original server_id=1 # select @@ global .server_id; @@ global .server_id 1 select name , originator, status from mysql.event; name originator status ev 1 SLAVESIDE_DISABLED

Jan Lindström (Inactive) added a comment - 2020-03-09 06:01 If SST is done from a galera node that is also acting as MASTER newly synced node in galera eco-system will also copy-over the event state enabling duplicate event in galera eco-system. Identification uses naturally server_id so not sure what you can do here to (1) avoid enabling events that should not be enabled and (2) allow events that should be enabled to be enabled.

Elena Stepanova added a comment - 2020-03-09 12:04 greenman , jacob.moorman , We should probably add some sort of a note or a warning for users recommending them to check their events (at least if there was a chance that server_id of their server has changed at least once). As I understand, the fix makes sure that the events don't get disabled anymore, but those which did will remain disabled, so people would need to update them manually to re-enable.

Ian Gilfillan added a comment - 2020-03-09 12:14 Thanks elenst , will document - MDEV-21896