mariadb/mysql-test/suite/galera/t/MDEV-30418.test
Jan Lindström dd159aeb1b MDEV-30418 : Setting wsrep_slave_threads causes thread hang
Problem was that wsrep was disconnected and new slave
threads tried to connect to cluster but failed as
we were disconnected state.

Allow changing wsrep_slave_threads only when wsrep is enabled
and we are connected to a cluster. In other cases report
error and issue a warning.
2025-09-26 15:33:56 +03:00

32 lines
998 B
Text

--source include/galera_cluster.inc
# Save original auto_increment_offset values.
--let $node_1=node_1
--let $node_2=node_2
--source ../galera/include/auto_increment_offset_save.inc
--connection node_2
select @@wsrep_slave_threads;
SET @cluster_address_orig = @@wsrep_cluster_address;
SET GLOBAL wsrep_cluster_address=AUTO;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL wsrep_slave_threads=12;
SHOW WARNINGS;
SET GLOBAL wsrep_cluster_address=ON;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL wsrep_slave_threads=0;
SHOW WARNINGS;
SET GLOBAL wsrep_cluster_address='a';
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL wsrep_slave_threads=2;
SHOW WARNINGS;
--disable_query_log
SET GLOBAL wsrep_cluster_address = @cluster_address_orig;
--enable_query_log
select @@wsrep_slave_threads;
show status like 'wsrep_cluster_size';
show status like 'wsrep_cluster_status';
call mtr.add_suppression("WSREP:.*");
# Restore original auto_increment_offset values.
--source ../galera/include/auto_increment_offset_restore.inc