[MDEV-31737] Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_MARIABACKUP Created: 2023-07-18  Updated: 2023-08-14  Resolved: 2023-08-08

Status: Closed
Project: MariaDB Server
Component/s: Backup, Galera, wsrep
Affects Version/s: 10.6.14
Fix Version/s: 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.2

Type: Bug Priority: Major
Reporter: Eric Hontz Assignee: Julius Goryavsky
Resolution: Fixed Votes: 1
Labels: None
Environment:

Linux

Attachments: File mariadb_galera_docker.tar.gz    

 Description   

Note: I reported this in a comment on MDEV-26391, but as instructed, I'm opening a bug.

I tried out the new wsrep_mode = BF_ABORT_MARIABACKUP setting and found that, when using wsrep_sst_method = mariabackup, a node never returns from Donor/Desynced to Synced after a serving as an SST donor.

I've attached a tarball containing a docker-compose environment that reliably reproduces the issue. The logs directory contains the logs from each node and queries that show the 'wsrep_%' status and PROCESSLIST.

After the cluster is formed, 2 of the 3 nodes have 

+---------------------------+----------------+
 
| Variable_name             | Value          |
 
+---------------------------+----------------+
 
| wsrep_local_state_comment | Donor/Desynced |
 
+---------------------------+----------------+

while the last node to join the cluster has

+---------------------------+--------+
 
| Variable_name             | Value  |
 
+---------------------------+--------+
 
| wsrep_local_state_comment | Synced |
 
+---------------------------+--------+



 Comments   
Comment by Jan Lindström [ 2023-07-26 ]

https://github.com/MariaDB/server/pull/2714

Comment by Julius Goryavsky [ 2023-08-09 ]

Fix merged with head revision as https://github.com/MariaDB/server/commit/0be4781428a4044b13b085965820a995652bb0e9

Generated at Thu Feb 08 10:26:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.