Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_applier_conflict_role_var.test

raw
1 --source include/have_ndb.inc
2 --source suite/ndb_rpl/ndb_master-slave.inc
3
4 connection slave;
5
6 show global variables like 'ndb_applier_conflict_role';
7
8 #show slave status;
9
10 --let $status_items=Slave_SQL_Running
11 --source include/show_slave_status.inc
12 stop slave sql_thread;
13 --source include/show_slave_status.inc
14
15 --echo Show set-to-same state is ok
16 set global ndb_applier_conflict_role = NONE;
17
18 --echo Now transition through all status, including set-to-self
19 set global ndb_applier_conflict_role = "PRIMARY";
20 show global variables like 'ndb_applier_conflict_role';
21 set global ndb_applier_conflict_role = "PRIMARY";
22 set global ndb_applier_conflict_role = "SECONDARY";
23 show global variables like 'ndb_applier_conflict_role';
24 set global ndb_applier_conflict_role = "SECONDARY";
25 set global ndb_applier_conflict_role = "NONE";
26 set global ndb_applier_conflict_role = "SECONDARY";
27 set global ndb_applier_conflict_role = "PRIMARY";
28 set global ndb_applier_conflict_role = "NONE";
29 set global ndb_applier_conflict_role = "PASS";
30 show global variables like 'ndb_applier_conflict_role';
31 set global ndb_applier_conflict_role = "PASS";
32 set global ndb_applier_conflict_role = "NONE";
33
34
35 --echo Now test illegal transitions
36 set global ndb_applier_conflict_role = "PRIMARY";
37 --error 1220
38 set global ndb_applier_conflict_role = "PASS";
39 show global variables like 'ndb_applier_conflict_role';
40
41
42 set global ndb_applier_conflict_role = "SECONDARY";
43 --error 1220
44 set global ndb_applier_conflict_role = "PASS";
45 show global variables like 'ndb_applier_conflict_role';
46
47
48 set global ndb_applier_conflict_role = "NONE";
49 set global ndb_applier_conflict_role = "PASS";
50 --error 1220
51 set global ndb_applier_conflict_role = "PRIMARY";
52 show global variables like 'ndb_applier_conflict_role';
53
54 --error 1220
55 set global ndb_applier_conflict_role = "SECONDARY";
56 show global variables like 'ndb_applier_conflict_role';
57
58 set global ndb_applier_conflict_role = "NONE";
59
60 --echo Now test transitions not possible due to
61 --echo Slave SQL thread running
62
63 start slave sql_thread;
64 --source include/show_slave_status.inc
65
66 --echo From NONE
67 set global ndb_applier_conflict_role = "NONE";
68 --error 1220
69 set global ndb_applier_conflict_role = "PRIMARY";
70 show global variables like 'ndb_applier_conflict_role';
71
72 --error 1220
73 set global ndb_applier_conflict_role = "SECONDARY";
74 show global variables like 'ndb_applier_conflict_role';
75
76 --error 1220
77 set global ndb_applier_conflict_role = "PASS";
78 show global variables like 'ndb_applier_conflict_role';
79
80 stop slave sql_thread;
81
82 --echo From PRIMARY
83 set global ndb_applier_conflict_role = "PRIMARY";
84
85 start slave sql_thread;
86
87 set global ndb_applier_conflict_role = "PRIMARY";
88 --error 1220
89 set global ndb_applier_conflict_role = "SECONDARY";
90 show global variables like 'ndb_applier_conflict_role';
91 --error 1220
92 set global ndb_applier_conflict_role = "NONE";
93 show global variables like 'ndb_applier_conflict_role';
94 --error 1220
95 set global ndb_applier_conflict_role = "PASS";
96 show global variables like 'ndb_applier_conflict_role';
97
98 stop slave sql_thread;
99
100 --echo From SECONDARY
101 set global ndb_applier_conflict_role = "SECONDARY";
102
103 start slave sql_thread;
104
105 set global ndb_applier_conflict_role = "SECONDARY";
106 --error 1220
107 set global ndb_applier_conflict_role = "PRIMARY";
108 show global variables like 'ndb_applier_conflict_role';
109 --error 1220
110 set global ndb_applier_conflict_role = "NONE";
111 show global variables like 'ndb_applier_conflict_role';
112 --error 1220
113 set global ndb_applier_conflict_role = "PASS";
114 show global variables like 'ndb_applier_conflict_role';
115
116 stop slave sql_thread;
117
118 --echo From PASS
119 set global ndb_applier_conflict_role = "NONE";
120 set global ndb_applier_conflict_role = "PASS";
121
122 start slave sql_thread;
123
124 set global ndb_applier_conflict_role = "PASS";
125 --error 1220
126 set global ndb_applier_conflict_role = "PRIMARY";
127 show global variables like 'ndb_applier_conflict_role';
128 --error 1220
129 set global ndb_applier_conflict_role = "SECONDARY";
130 show global variables like 'ndb_applier_conflict_role';
131 --error 1220
132 set global ndb_applier_conflict_role = "NONE";
133 show global variables like 'ndb_applier_conflict_role';
134
135 stop slave sql_thread;
136
137 set global ndb_applier_conflict_role = "NONE";
138
139 --echo Test some aliases for role names
140
141 set global ndb_applier_conflict_role = PR;
142 show global variables like 'ndb_applier_conflict_role';
143
144 set global ndb_applier_conflict_role = S;
145 show global variables like 'ndb_applier_conflict_role';
146
147 set global ndb_applier_conflict_role = N;
148 show global variables like 'ndb_applier_conflict_role';
149
150 set global ndb_applier_conflict_role = PA;
151 show global variables like 'ndb_applier_conflict_role';
152
153 set global ndb_applier_conflict_role = 0;
154 show global variables like 'ndb_applier_conflict_role';
155
156 set global ndb_applier_conflict_role = 2;
157 show global variables like 'ndb_applier_conflict_role';
158
159 set global ndb_applier_conflict_role = 1;
160 show global variables like 'ndb_applier_conflict_role';
161
162 set global ndb_applier_conflict_role = 0;
163 show global variables like 'ndb_applier_conflict_role';
164
165 set global ndb_applier_conflict_role = 3;
166 show global variables like 'ndb_applier_conflict_role';
167
168 set global ndb_applier_conflict_role = NON;
169
170 start slave sql_thread;
171
172 --source include/rpl_end.inc
173
174 --echo
175 --echo # Reboot server setting with both ndb_slave_conflict_role & ndb_applier_conflict_role variable.
176 call mtr.add_suppression("mysqld startup An incident event has been written to the binary log which will stop the replicas");
177 --let $mysqld_name=mysqld.1.1
178 --let $restart_parameters=restart:--ndb_slave_conflict_role="PRIMARY" --ndb_applier_conflict_role="SECONDARY"
179 --source include/restart_mysqld.inc
180
181
182 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
183 --let $assert_select= The syntax 'ndb_slave_conflict_role' is deprecated and will be removed in a future release. Please use ndb_applier_conflict_role instead.
184 --let $assert_count= 1
185 --let $assert_text= Deprecation warning is logged during startup.
186 --source include/assert_grep.inc
187
188 --echo
189 --echo # when new and deprecated variables are set, only new value should be considered
190 show global variables like 'ndb_applier_conflict_role';
191 show global variables like 'ndb_slave_conflict_role';
192
193 --echo
194 --echo # updating one variables should also update the other variable
195 set global ndb_slave_conflict_role = "PRIMARY";
196 show global variables like 'ndb_applier_conflict_role';
197 show global variables like 'ndb_slave_conflict_role';
198
199 set global ndb_applier_conflict_role = "NONE";
200 show global variables like 'ndb_applier_conflict_role';
201 show global variables like 'ndb_slave_conflict_role';