Debian Codegraph @

mysql-test/suite/group_replication/r/gr_view_change_uuid.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [connection server1]
7 SET sql_log_bin = 0;
8 include/gtid_utils.inc
9 SET sql_log_bin = 1;
10 [connection server2]
11 SET sql_log_bin = 0;
12 include/gtid_utils.inc
13 SET sql_log_bin = 1;
14 [connection server3]
15 SET sql_log_bin = 0;
16 include/gtid_utils.inc
17 SET sql_log_bin = 1;
18
19 ############################################################
20 # 1. Start server 1 and assert it only has one transaction
21 [connection server1]
22 SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid;
23 SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de";
24 Warnings:
25 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
26 include/start_and_bootstrap_group_replication.inc
27 Warnings:
28 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
29 include/assert.inc [GTID_EXECUTED must have one transaction of view change]
30 include/show_binlog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 server-binary-log.000001 # Previous_gtids # #
33 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
34 server-binary-log.000001 # Query # # BEGIN
35 server-binary-log.000001 # Query # # COMMIT
36
37 ############################################################
38 # 2. Start server 2 and assert it has two transactions
39 [connection server2]
40 SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid;
41 SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de";
42 Warnings:
43 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
44 include/start_group_replication.inc
45 Warnings:
46 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
47 include/assert.inc [GTID_EXECUTED must have two transactions of view changes]
48 include/show_binlog_events.inc
49 Log_name Pos Event_type Server_id End_log_pos Info
50 server-binary-log.000001 # Previous_gtids # #
51 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
52 server-binary-log.000001 # Query # # BEGIN
53 server-binary-log.000001 # Query # # COMMIT
54 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
55 server-binary-log.000001 # Query # # BEGIN
56 server-binary-log.000001 # Query # # COMMIT
57
58 ############################################################
59 # 3. Confirm server 1 has same GTID_EXECUTED as server 2
60 [connection server1]
61 include/assert.inc [GTID_EXECUTED must have two transactions of view changes]
62 include/show_binlog_events.inc
63 Log_name Pos Event_type Server_id End_log_pos Info
64 server-binary-log.000001 # Previous_gtids # #
65 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
66 server-binary-log.000001 # Query # # BEGIN
67 server-binary-log.000001 # Query # # COMMIT
68 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
69 server-binary-log.000001 # Query # # BEGIN
70 server-binary-log.000001 # Query # # COMMIT
71
72 ############################################################
73 # 4. Start server 3 and assert it has three transactions
74 [connection server3]
75 SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid;
76 SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de";
77 Warnings:
78 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
79 include/start_group_replication.inc
80 Warnings:
81 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
82 include/assert.inc [GTID_EXECUTED must have three transactions of view changes]
83 include/show_binlog_events.inc
84 Log_name Pos Event_type Server_id End_log_pos Info
85 server-binary-log.000001 # Previous_gtids # #
86 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
87 server-binary-log.000001 # Query # # BEGIN
88 server-binary-log.000001 # Query # # COMMIT
89 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
90 server-binary-log.000001 # Query # # BEGIN
91 server-binary-log.000001 # Query # # COMMIT
92 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
93 server-binary-log.000001 # Query # # BEGIN
94 server-binary-log.000001 # Query # # COMMIT
95
96 ############################################################
97 # 5. Confirm server 1 has same GTID_EXECUTED than server 3
98 [connection server1]
99 include/assert.inc [GTID_EXECUTED must have three transactions of view changes]
100 include/show_binlog_events.inc
101 Log_name Pos Event_type Server_id End_log_pos Info
102 server-binary-log.000001 # Previous_gtids # #
103 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
104 server-binary-log.000001 # Query # # BEGIN
105 server-binary-log.000001 # Query # # COMMIT
106 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
107 server-binary-log.000001 # Query # # BEGIN
108 server-binary-log.000001 # Query # # COMMIT
109 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
110 server-binary-log.000001 # Query # # BEGIN
111 server-binary-log.000001 # Query # # COMMIT
112 ############################################################
113 # 6. Confirm server 2 has same GTID_EXECUTED than server 3
114 [connection server2]
115 include/assert.inc [GTID_EXECUTED must have three transactions of view changes]
116 include/show_binlog_events.inc
117 Log_name Pos Event_type Server_id End_log_pos Info
118 server-binary-log.000001 # Previous_gtids # #
119 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
120 server-binary-log.000001 # Query # # BEGIN
121 server-binary-log.000001 # Query # # COMMIT
122 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
123 server-binary-log.000001 # Query # # BEGIN
124 server-binary-log.000001 # Query # # COMMIT
125 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
126 server-binary-log.000001 # Query # # BEGIN
127 server-binary-log.000001 # Query # # COMMIT
128
129 ############################################################
130 # 7. Stop server 3 and assert it has three transactions
131 [connection server3]
132 include/stop_group_replication.inc
133 include/assert.inc [GTID_EXECUTED must have three transactions of view changes]
134 include/show_binlog_events.inc
135 Log_name Pos Event_type Server_id End_log_pos Info
136 server-binary-log.000001 # Previous_gtids # #
137 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
138 server-binary-log.000001 # Query # # BEGIN
139 server-binary-log.000001 # Query # # COMMIT
140 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
141 server-binary-log.000001 # Query # # BEGIN
142 server-binary-log.000001 # Query # # COMMIT
143 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
144 server-binary-log.000001 # Query # # BEGIN
145 server-binary-log.000001 # Query # # COMMIT
146
147 ############################################################
148 # 8. Stop server 2 and assert it has three transactions
149 [connection server2]
150 include/stop_group_replication.inc
151 include/assert.inc [GTID_EXECUTED must have three transactions of view changes]
152 include/show_binlog_events.inc
153 Log_name Pos Event_type Server_id End_log_pos Info
154 server-binary-log.000001 # Previous_gtids # #
155 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
156 server-binary-log.000001 # Query # # BEGIN
157 server-binary-log.000001 # Query # # COMMIT
158 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
159 server-binary-log.000001 # Query # # BEGIN
160 server-binary-log.000001 # Query # # COMMIT
161 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
162 server-binary-log.000001 # Query # # BEGIN
163 server-binary-log.000001 # Query # # COMMIT
164
165 ############################################################
166 # 9. Start server 2 and assert it has 4 transactions
167 [connection server2]
168 include/start_group_replication.inc
169 Warnings:
170 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
171 include/assert.inc [GTID_EXECUTED must have four transactions of view changes]
172 include/show_binlog_events.inc
173 Log_name Pos Event_type Server_id End_log_pos Info
174 server-binary-log.000001 # Previous_gtids # #
175 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
176 server-binary-log.000001 # Query # # BEGIN
177 server-binary-log.000001 # Query # # COMMIT
178 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
179 server-binary-log.000001 # Query # # BEGIN
180 server-binary-log.000001 # Query # # COMMIT
181 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
182 server-binary-log.000001 # Query # # BEGIN
183 server-binary-log.000001 # Query # # COMMIT
184 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
185 server-binary-log.000001 # Query # # BEGIN
186 server-binary-log.000001 # Query # # COMMIT
187
188 ############################################################
189 # 10. Confirm server 1 has same GTID_EXECUTED as server 2
190 [connection server1]
191 include/assert.inc [GTID_EXECUTED must have four transactions of view changes]
192 include/show_binlog_events.inc
193 Log_name Pos Event_type Server_id End_log_pos Info
194 server-binary-log.000001 # Previous_gtids # #
195 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
196 server-binary-log.000001 # Query # # BEGIN
197 server-binary-log.000001 # Query # # COMMIT
198 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
199 server-binary-log.000001 # Query # # BEGIN
200 server-binary-log.000001 # Query # # COMMIT
201 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
202 server-binary-log.000001 # Query # # BEGIN
203 server-binary-log.000001 # Query # # COMMIT
204 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
205 server-binary-log.000001 # Query # # BEGIN
206 server-binary-log.000001 # Query # # COMMIT
207
208 ############################################################
209 # 11. Start server 3 and assert it has 5 transactions
210 [connection server3]
211 include/start_group_replication.inc
212 Warnings:
213 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
214 include/assert.inc [GTID_EXECUTED must have five transactions of view changes]
215 include/show_binlog_events.inc
216 Log_name Pos Event_type Server_id End_log_pos Info
217 server-binary-log.000001 # Previous_gtids # #
218 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
219 server-binary-log.000001 # Query # # BEGIN
220 server-binary-log.000001 # Query # # COMMIT
221 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
222 server-binary-log.000001 # Query # # BEGIN
223 server-binary-log.000001 # Query # # COMMIT
224 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
225 server-binary-log.000001 # Query # # BEGIN
226 server-binary-log.000001 # Query # # COMMIT
227 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
228 server-binary-log.000001 # Query # # BEGIN
229 server-binary-log.000001 # Query # # COMMIT
230 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
231 server-binary-log.000001 # Query # # BEGIN
232 server-binary-log.000001 # Query # # COMMIT
233 ############################################################
234 # 12. Confirm server 1 has same GTID_EXECUTED than server 3
235 [connection server1]
236 include/assert.inc [GTID_EXECUTED must have five transactions of view changes]
237 include/show_binlog_events.inc
238 Log_name Pos Event_type Server_id End_log_pos Info
239 server-binary-log.000001 # Previous_gtids # #
240 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
241 server-binary-log.000001 # Query # # BEGIN
242 server-binary-log.000001 # Query # # COMMIT
243 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
244 server-binary-log.000001 # Query # # BEGIN
245 server-binary-log.000001 # Query # # COMMIT
246 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
247 server-binary-log.000001 # Query # # BEGIN
248 server-binary-log.000001 # Query # # COMMIT
249 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
250 server-binary-log.000001 # Query # # BEGIN
251 server-binary-log.000001 # Query # # COMMIT
252 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
253 server-binary-log.000001 # Query # # BEGIN
254 server-binary-log.000001 # Query # # COMMIT
255 ############################################################
256 # 13. Confirm server 2 has same GTID_EXECUTED than server 3
257 [connection server2]
258 include/assert.inc [GTID_EXECUTED must have five transactions of view changes]
259 include/show_binlog_events.inc
260 Log_name Pos Event_type Server_id End_log_pos Info
261 server-binary-log.000001 # Previous_gtids # #
262 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
263 server-binary-log.000001 # Query # # BEGIN
264 server-binary-log.000001 # Query # # COMMIT
265 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
266 server-binary-log.000001 # Query # # BEGIN
267 server-binary-log.000001 # Query # # COMMIT
268 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
269 server-binary-log.000001 # Query # # BEGIN
270 server-binary-log.000001 # Query # # COMMIT
271 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
272 server-binary-log.000001 # Query # # BEGIN
273 server-binary-log.000001 # Query # # COMMIT
274 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
275 server-binary-log.000001 # Query # # BEGIN
276 server-binary-log.000001 # Query # # COMMIT
277
278 ############################################################
279 # 14. Cleanup
280 [connection server1]
281 SET sql_log_bin = 0;
282 include/gtid_utils_end.inc
283 SET sql_log_bin = 1;
284 include/stop_group_replication.inc
285 SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save;
286 Warnings:
287 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
288 SET GLOBAL group_replication_view_change_uuid = "AUTOMATIC";
289 Warnings:
290 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
291 [connection server2]
292 SET sql_log_bin = 0;
293 include/gtid_utils_end.inc
294 SET sql_log_bin = 1;
295 include/stop_group_replication.inc
296 SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save;
297 Warnings:
298 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
299 [connection server3]
300 SET sql_log_bin = 0;
301 include/gtid_utils_end.inc
302 SET sql_log_bin = 1;
303 include/stop_group_replication.inc
304 SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save;
305 Warnings:
306 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
307 include/group_replication_end.inc