[MDEV-32282] Galera node remains paused after interleaving FTWRLs Created: 2023-09-28  Updated: 2023-10-27  Resolved: 2023-10-27

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.32
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1

Type: Bug Priority: Major
Reporter: Teemu Ollakka Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None

Attachments: HTML File patch    

 Description   

After having two clients running FLUSH TABLES WITH READ LOCK/UNLOCK TABLES against Galera node, the node sometimes gets stuck in paused state causing following queries to fail, e.g.

ER_UNKNOWN_COM_ERROR (1047): Aborting TOI: Replication paused on node for FTWRL/BACKUP STAGE.

The attached patch contains required sync points and a test case to reproduce the problem.

 Comments   
Comment by Jan Lindström [ 2023-10-11 ]

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

Comment by Julius Goryavsky [ 2023-10-27 ]

Fix merged with head revision after review & testing (https://github.com/MariaDB/server/commit/ef7fc586aea1048bc5526192158a8e8e935ddd1a)

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