Debian Codegraph @

mysql-test/suite/galera/t/MW-336.test

raw
1 #
2 # MW-336 Slave threads may leak if variable wsrep_slave_threads is set repeatedly
3 #
4
5 --source include/galera_cluster.inc
6 --source include/force_restart.inc
7 --source include/have_sequence.inc
8
9 --connection node_1
10 SET @wsrep_slave_threads_orig = @@wsrep_slave_threads;
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) Engine=InnoDB;
12
13 SET GLOBAL wsrep_slave_threads = 10;
14
15 # ensure that the threads have actually started running
16 --echo # Set slave threads to 10 step 1
17 --let $wait_condition = SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
18 --let $wait_condition_on_error_output = SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
19 --source include/wait_condition_with_debug.inc
20
21 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
22
23 SET GLOBAL wsrep_slave_threads = 1;
24
25 --connection node_2
26 INSERT INTO t1 VALUES (NULL);
27
28 --connection node_1
29 --echo # Wait until one of the appliers has exited
30 --let $wait_condition = SELECT VARIABLE_VALUE = 9 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
31 --let $wait_condition_on_error_output = SELECT COUNT(*), 9 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
32 --source include/wait_condition_with_debug.inc
33
34 SELECT VARIABLE_VALUE AS EXPECT_9 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
35
36 SET GLOBAL wsrep_slave_threads = 10;
37
38 # Note that above insert could be handled by one of the slave threads
39 --echo # Set slave threads to 10 step 2
40 --let $wait_condition = SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
41 --let $wait_condition_on_error_output = SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
42 --source include/wait_condition_with_debug.inc
43
44 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
45
46 SET GLOBAL wsrep_slave_threads = 20;
47
48 --echo # Set slave threads to 20
49 --let $wait_condition = SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
50 --let $wait_condition_on_error_output = SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
51 --source include/wait_condition_with_debug.inc
52
53 SELECT VARIABLE_VALUE AS EXPECT_20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
54
55 SET GLOBAL wsrep_slave_threads = 1;
56
57 --connection node_2
58 --disable_query_log
59 let $c = 50;
60 while ($c) {
61 INSERT INTO t1 VALUES(NULL); COMMIT;
62 dec $c;
63 }
64 --enable_query_log
65
66 --connection node_1
67 --let $wait_condition = SELECT COUNT(*) = 51 FROM t1;
68 --let $wait_condition_on_error_output = SELECT COUNT(*) FROM t1;
69 --source include/wait_condition_with_debug.inc
70
71 --echo # Wait until 19 of the appliers has exited
72 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
73 --let $wait_condition_on_error_output = SELECT COUNT(*), 1 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
74 --source include/wait_condition_with_debug.inc
75
76 SELECT VARIABLE_VALUE AS EXPECT_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
77
78 SELECT COUNT(*) AS EXPECT_51 FROM t1;
79
80 SET GLOBAL wsrep_slave_threads = 10;
81 --echo # Set slave threads to 10 step 3
82 --let $wait_condition = SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
83 --let $wait_condition_on_error_output = SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
84 --source include/wait_condition_with_debug.inc
85
86 SELECT VARIABLE_VALUE AS EXPECT_10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
87
88 --connection node_1
89 SET GLOBAL wsrep_slave_threads = 1;
90
91 --connection node_2
92 --disable_query_log
93 let $c = 50;
94 while ($c) {
95 INSERT INTO t1 VALUES(NULL); COMMIT;
96 dec $c;
97 }
98 --enable_query_log
99
100 --connection node_1
101 --echo # Wait until slave threads back to 1
102 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
103 --let $wait_condition_on_error_output = SELECT COUNT(*), 1 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist
104 --source include/wait_condition_with_debug.inc
105
106 SELECT VARIABLE_VALUE AS EXPECT_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
107
108 SELECT COUNT(*) AS EXPECT_101 FROM t1;
109
110 DROP TABLE t1;
111
112 --disable_query_log
113 SET GLOBAL wsrep_slave_threads = @wsrep_slave_threads_orig;
114 --enable_query_log