Debian Codegraph @

mysql-test/suite/galera_3nodes/t/MDEV-29171.test

raw
1 #
2 # MDEV-29171: changing the value of wsrep_gtid_domain_id
3 # with full cluster restart fails on some nodes
4 #
5
6 --source include/galera_cluster.inc
7 --source include/galera_sst_method.inc
8 --source include/force_restart.inc
9
10 #
11 # Initially wsrep gtid domain id is 100
12 #
13
14 --connection node_1
15 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
16
17 --connection node_2
18 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
19
20 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
21 --connection node_3
22 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
23
24
25 #
26 # Shutdown all nodes
27 #
28 --connection node_3
29 --source include/shutdown_mysqld.inc
30
31 --connection node_1
32 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
33 --source include/wait_condition.inc
34
35 --connection node_2
36 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
37 --source include/wait_condition.inc
38 --source include/shutdown_mysqld.inc
39
40 --connection node_1
41 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
42 --source include/wait_condition.inc
43 --source include/shutdown_mysqld.inc
44
45 --sleep 5
46
47 #
48 # Bootstrap from node_1 and change wsrep_gtid_domain_id to 200
49 #
50 --connection node_1
51 --let $restart_parameters = --wsrep_new_cluster --wsrep_gtid_domain_id=200
52 --source include/start_mysqld.inc
53
54 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
55 --source include/wait_condition.inc
56 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
57 --source include/wait_condition.inc
58 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment'
59 --source include/wait_condition.inc
60
61 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
62 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
63 show variables like 'wsrep_gtid_domain_id';
64
65 #
66 # Restart node_2, expect that wsrep_gtid_domain_id has changed to 200
67 #
68 --connection node_2
69 --let $restart_parameters =
70 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
71 --source include/start_mysqld.inc
72
73 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
74 --source include/wait_condition.inc
75 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
76 --source include/wait_condition.inc
77 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment'
78 --source include/wait_condition.inc
79
80 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
81 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
82 show variables like 'wsrep_gtid_domain_id';
83
84 --connection node_1
85 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
86 --source include/wait_condition.inc
87
88 #
89 # Restart node_3, select node_2 as donor
90 # If bug is present, node_3 remains on domain id 100
91 #
92 --connection node_3
93 --let $restart_parameters = --wsrep_sst_donor=node2
94 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.3.expect
95 --source include/start_mysqld.inc
96
97 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
98 --source include/wait_condition.inc
99 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
100 --source include/wait_condition.inc
101 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment'
102 --source include/wait_condition.inc
103
104 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
105 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
106
107 # Expect domain id 200
108 show variables like 'wsrep_gtid_domain_id';
109
110 --connection node_1
111 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
112 --source include/wait_condition.inc
113
114 #
115 # Cleanup
116 #
117 --connection node_1
118 set global wsrep_gtid_domain_id=100;
119
120 --connection node_2
121 set global wsrep_gtid_domain_id=100;
122 CALL mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
123
124 --connection node_3
125 set global wsrep_gtid_domain_id=100;
126 CALL mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");