[MDEV-9675] Running FLUSH TABLES WITH READ LOCK followed by SET GLOBAL wsrep_desync=ON freezes the node (kill pid needed) Created: 2016-03-02  Updated: 2019-12-14  Resolved: 2019-12-14

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.22-galera
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Claudio Nanni Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Linux

Attachments: File perf-kernel-galeranode.svg    

 Description   

If I run:

FLUSH TABLES WITH READ LOCK;
SET GLOBAL wsrep_desync=ON;

Completely freezes the Galera node, not possible to login, and the only option is to kill mysqld process.

 Comments   
Comment by Claudio Nanni [ 2016-03-02 ]

Please note, due to MDEV-9626 Codership will change the behaviour of FTWRL on a Galera node to issue an implicit desync before FTWRL and resync afterwards.
So this issue MDEV-9675 might not be an issue anymore at that point.

Comment by Jan Lindström (Inactive) [ 2019-12-14 ]

Support for 10.0-galera has ended.

Generated at Thu Feb 08 07:36:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.