[MDEV-30418] Setting wsrep_slave_threads causes thread hang - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.11.15, 11.4.9, 11.8.4, 12.1.2, 12.2.1
Component/s: Galera, wsrep
Labels:

Bug Category:
Can result in hang or crash
Sprint:
Q3/2025 Maintenance, Q4/2025 Galera Maintenance, Q4/2025 Galera Development

SET GLOBAL wsrep_cluster_address=AUTO;

SET GLOBAL wsrep_slave_threads=12;

Leads to a thread hang. Another connection will show the hanging statement:

11.0.1 b075191ba8598af6aff5549e6e19f6255aef258a (Optimized)
11.0.1-opt>SHOW PROCESSLIST;
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
\| Id \| User \| Host \| db \| Command \| Time \| State \| Info \| Progress \|
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
\| 4 \| root \| localhost \| test \| Query \| 7972 \| NULL \| SET GLOBAL wsrep_slave_threads=12 \| 0.000 \|
\| 5 \| root \| localhost \| test \| Query \| 0 \| starting \| SHOW PROCESSLIST \| 0.000 \|
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
2 rows in set (0.000 sec)

relates to

MDEV-25472 Server crashes when wsrep_cluster_address set to unkown address and wsrep_slave_threads to 0

MDEV-27689 Node hangs and complete galera cluster freezes

Estimated:

5.4d

Remaining:

Logged:

4d 5h 20m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.