[MDEV-26969] mariabackup sst donor stuck in Donor/Desynced even after the SST succeeds Created: 2021-11-03  Updated: 2022-01-14  Resolved: 2022-01-14

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.4.21, 10.5.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Eric Howey Assignee: Seppo Jaakola
Resolution: Duplicate Votes: 2
Labels: CS0371509
Environment:

I have a 3 node cluster running on Rocky Linux 8. These servers are my staging environment running in Vultr in the same datacenter. However, this issue also occurs in my production environment with 3 bare metal servers connected to the same switch. I just prefer not to test/experiment on my production systems.


Attachments: File Donor.log     File Joiner.log     File server.cnf    
Issue Links:
Relates
relates to MDEV-27459 SST works as expected on joiner node ... Closed

 Description   

More often than not when using mariabackup, the donor is stuck in Donor/Desynced indefinitely even though the joiner has finished the sst and is Synced. Sometimes this issue will not occur, but it rarely works correctly. If I restart mariadb on the stuck Donor, everything comes back up fine and fully synced. I can easily reproduce this issue in both my staging and production environments. Attached are the following:

Donor Logs
Joiner Logs
mariadb config

I brought this up in the codership group. Someone has come up with a potential fix for this issue already.
https://groups.google.com/g/codership-team/c/qOeuIRBcrDA



 Comments   
Comment by Mark Reibert [ 2021-11-08 ]

I am seeing this too, also on 10.4.21. Note the donor node will return to "Synced" if I restart MariaDB on the joiner node.

Comment by Mark Reibert [ 2021-11-22 ]

The problem remains in MariaDB 10.4.22.

Comment by Gabor Orosz [ 2022-01-03 ]

That someone was me and I consider that "potential fix" as a mitigation.
You can find the references (mitigation and mysql test case) in MDEV-26918 and these two ticket can be grouped and handled together as a duplicate.

Comment by Jan Lindström (Inactive) [ 2022-01-14 ]

Duplicate of MDEV-27459

Generated at Thu Feb 08 09:49:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.