[MDEV-20511] Galera replication of events is not consistent Created: 2019-09-06  Updated: 2020-03-07  Resolved: 2019-09-09

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2
Fix Version/s: 10.2.28, 10.3.19, 10.4.9

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-21758 Events switched randomly to SLAVESIDE... Closed

 Description   

Refs: https://bugs.launchpad.net/codership-mysql/+bug/1312618 https://jira.percona.com/browse/PXC-999

MariaDB Galera has following problems based on mtr testing:

  • 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'
  • If event owner node is re-created using SST, all the nodes have the event now in "SLAVESIDE_DISABLED" state, hence manual action is needed to re-enable the event on one of the nodes. This requirement of the manual action will be documented.
Generated at Thu Feb 08 09:00:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.