Debian Codegraph @

mysql-test/suite/rpl/r/rpl_semi_sync_alias.result

raw
1 include/master-slave.inc
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 master]
6 ==== Setup ====
7 include/save_error_log_position.inc
8 CREATE TABLE t1 (a INT PRIMARY KEY AUTO_INCREMENT);
9 include/sync_slave_sql_with_master.inc
10 include/save_error_log_position.inc
11 include/stop_slave.inc
12 [connection master]
13 include/stop_dump_threads.inc
14 include/suppress_messages.inc
15 # Connection 1 suppresses message <.*A message intended for a client cannot be sent there as no client-session is attached.*Got an error reading communication packets.*>.
16 # Connection 2 suppresses message <.*A message intended for a client cannot be sent there as no client-session is attached.*Got an error reading communication packets.*>.
17 include/suppress_messages.inc
18 # Connection 1 un-suppresses message <rpl_semi_sync.*is deprecated and will be removed in a future release.*>.
19 # Connection 2 un-suppresses message <rpl_semi_sync.*is deprecated and will be removed in a future release.*>.
20 ==== R3. Replication: old source library -> old replica library ====
21 [connection master]
22 INSTALL PLUGIN rpl_semi_sync_master SONAME 'SEMISYNC_MASTER_PLUGIN';
23 Warnings:
24 Note 1287 'rpl_semi_sync_master' is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead
25 include/assert_error_log.inc [server: 1, pattern: .*rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.]
26 # R1. source variable name matches source library name
27 SET @@global.rpl_semi_sync_master_enabled = 1;
28 [connection slave]
29 INSTALL PLUGIN rpl_semi_sync_slave SONAME 'SEMISYNC_SLAVE_PLUGIN';
30 Warnings:
31 Note 1287 'rpl_semi_sync_slave' is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead
32 include/assert_error_log.inc [server: 2, pattern: .*rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.]
33 # R2. replica variable name matches replica library name
34 SET @@global.rpl_semi_sync_slave_enabled = 1;
35 [connection slave]
36 include/start_slave.inc
37 [connection master]
38 include/assert.inc [Initially no acked transactions]
39 INSERT INTO t1() VALUES ();
40 include/assert.inc [After one transaction is committed, one transaction got acked]
41 include/sync_slave_sql_with_master.inc
42 [connection master]
43 include/assert.inc [Semisync master library should remain enabled on master]
44 [connection slave]
45 include/assert.inc [Semisync slave library should remain enabled on slave]
46 include/stop_slave.inc
47 [connection master]
48 include/stop_dump_threads.inc
49 UNINSTALL PLUGIN rpl_semi_sync_master;
50 [connection slave]
51 include/stop_dump_threads.inc
52 UNINSTALL PLUGIN rpl_semi_sync_slave;
53 ==== R4. Replication: old source library -> new replica library ====
54 [connection master]
55 INSTALL PLUGIN rpl_semi_sync_master SONAME 'SEMISYNC_MASTER_PLUGIN';
56 Warnings:
57 Note 1287 'rpl_semi_sync_master' is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead
58 include/assert_error_log.inc [server: 1, pattern: .*rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.]
59 # R1. source variable name matches source library name
60 SET @@global.rpl_semi_sync_master_enabled = 1;
61 [connection slave]
62 INSTALL PLUGIN rpl_semi_sync_replica SONAME 'SEMISYNC_REPLICA_PLUGIN';
63 # R2. replica variable name matches replica library name
64 SET @@global.rpl_semi_sync_replica_enabled = 1;
65 [connection slave]
66 include/start_slave.inc
67 [connection master]
68 include/assert.inc [Initially no acked transactions]
69 INSERT INTO t1() VALUES ();
70 include/assert.inc [After one transaction is committed, one transaction got acked]
71 include/sync_slave_sql_with_master.inc
72 [connection master]
73 include/assert.inc [Semisync master library should remain enabled on master]
74 [connection slave]
75 include/assert.inc [Semisync replica library should remain enabled on slave]
76 include/stop_slave.inc
77 [connection master]
78 include/stop_dump_threads.inc
79 UNINSTALL PLUGIN rpl_semi_sync_master;
80 [connection slave]
81 include/stop_dump_threads.inc
82 UNINSTALL PLUGIN rpl_semi_sync_replica;
83 ==== R5. Replication: new source library -> old replica library ====
84 [connection master]
85 INSTALL PLUGIN rpl_semi_sync_source SONAME 'SEMISYNC_SOURCE_PLUGIN';
86 # R1. source variable name matches source library name
87 SET @@global.rpl_semi_sync_source_enabled = 1;
88 [connection slave]
89 INSTALL PLUGIN rpl_semi_sync_slave SONAME 'SEMISYNC_SLAVE_PLUGIN';
90 Warnings:
91 Note 1287 'rpl_semi_sync_slave' is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead
92 include/assert_error_log.inc [server: 2, pattern: .*rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.]
93 # R2. replica variable name matches replica library name
94 SET @@global.rpl_semi_sync_slave_enabled = 1;
95 [connection slave]
96 include/start_slave.inc
97 [connection master]
98 include/assert.inc [Initially no acked transactions]
99 INSERT INTO t1() VALUES ();
100 include/assert.inc [After one transaction is committed, one transaction got acked]
101 include/sync_slave_sql_with_master.inc
102 [connection master]
103 include/assert.inc [Semisync source library should remain enabled on master]
104 [connection slave]
105 include/assert.inc [Semisync slave library should remain enabled on slave]
106 include/stop_slave.inc
107 [connection master]
108 include/stop_dump_threads.inc
109 UNINSTALL PLUGIN rpl_semi_sync_source;
110 [connection slave]
111 include/stop_dump_threads.inc
112 UNINSTALL PLUGIN rpl_semi_sync_slave;
113 ==== R6. New source and old replica on the same node works, and R7. Old source and new replica on the same node works ====
114 # Reconfigure toplogy and install plugins.
115 include/rpl_change_topology.inc [new topology=1->2->1]
116 Warnings:
117 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
118 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.
119 [connection master]
120 INSTALL PLUGIN rpl_semi_sync_master SONAME 'SEMISYNC_MASTER_PLUGIN';
121 Warnings:
122 Note 1287 'rpl_semi_sync_master' is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead
123 include/assert_error_log.inc [server: 1, pattern: .*rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.]
124 # R1. source variable name matches source library name
125 SET @@global.rpl_semi_sync_master_enabled = 1;
126 [connection slave]
127 INSTALL PLUGIN rpl_semi_sync_slave SONAME 'SEMISYNC_SLAVE_PLUGIN';
128 Warnings:
129 Note 1287 'rpl_semi_sync_slave' is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead
130 include/assert_error_log.inc [server: 2, pattern: .*rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.]
131 # R2. replica variable name matches replica library name
132 SET @@global.rpl_semi_sync_slave_enabled = 1;
133 [connection slave]
134 INSTALL PLUGIN rpl_semi_sync_source SONAME 'SEMISYNC_SOURCE_PLUGIN';
135 # R1. source variable name matches source library name
136 SET @@global.rpl_semi_sync_source_enabled = 1;
137 [connection master]
138 INSTALL PLUGIN rpl_semi_sync_replica SONAME 'SEMISYNC_REPLICA_PLUGIN';
139 # R2. replica variable name matches replica library name
140 SET @@global.rpl_semi_sync_replica_enabled = 1;
141 # Check that replication works in the usual direction
142 SET @@global.rpl_semi_sync_source_enabled = 0;
143 SET @@global.rpl_semi_sync_replica_enabled = 0;
144 [connection slave]
145 include/start_slave.inc
146 [connection master]
147 include/assert.inc [Initially no acked transactions]
148 INSERT INTO t1() VALUES ();
149 include/assert.inc [After one transaction is committed, one transaction got acked]
150 include/sync_slave_sql_with_master.inc
151 [connection master]
152 include/assert.inc [Semisync master library should remain enabled on master]
153 [connection slave]
154 include/assert.inc [Semisync slave library should remain enabled on slave]
155 include/stop_slave.inc
156 # Check that replication works in reverse direction
157 SET @@global.rpl_semi_sync_replica_enabled = 1;
158 SET @@global.rpl_semi_sync_master_enabled = 0;
159 SET @@global.rpl_semi_sync_source_enabled = 1;
160 SET @@global.rpl_semi_sync_slave_enabled = 0;
161 [connection master]
162 include/start_slave.inc
163 [connection slave]
164 include/assert.inc [Initially no acked transactions]
165 INSERT INTO t1() VALUES ();
166 include/assert.inc [After one transaction is committed, one transaction got acked]
167 include/sync_slave_sql_with_master.inc
168 [connection slave]
169 include/assert.inc [Semisync source library should remain enabled on slave]
170 [connection master]
171 include/assert.inc [Semisync replica library should remain enabled on master]
172 include/stop_slave.inc
173 # Uninstall plugins
174 [connection master]
175 include/stop_dump_threads.inc
176 UNINSTALL PLUGIN rpl_semi_sync_master;
177 [connection slave]
178 include/stop_dump_threads.inc
179 UNINSTALL PLUGIN rpl_semi_sync_slave;
180 [connection slave]
181 include/stop_dump_threads.inc
182 UNINSTALL PLUGIN rpl_semi_sync_source;
183 [connection master]
184 include/stop_dump_threads.inc
185 UNINSTALL PLUGIN rpl_semi_sync_replica;
186 ==== R8. Error installing conflicting plugins. ====
187 ==== R8.1 Error installing first old and then new source library ====
188 * Case a) Use INSTALL PLUGIN dynamically
189 INSTALL PLUGIN rpl_semi_sync_master SONAME 'PLUGIN_NAME';
190 Warnings:
191 Note 1287 'rpl_semi_sync_master' is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead
192 # R9.1. deprecation warnings for dynamic plugin load using INSTALL PLUGIN
193 include/assert_error_log.inc [server: 1, pattern: .rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.]
194 INSTALL PLUGIN rpl_semi_sync_source SONAME 'PLUGIN_NAME';
195 ERROR HY000: Cannot install the rpl_semi_sync_source plugin when the rpl_semi_sync_master plugin is installed.
196 include/assert_error_log.inc [server: 1, pattern: Plugin 'rpl_semi_sync_source' init function returned error.]
197 include/assert.inc [rpl_semi_sync_master should remain installed]
198 include/assert.inc [rpl_semi_sync_source should not be installed]
199 UNINSTALL PLUGIN rpl_semi_sync_master;
200 * Case b) Restart server with --plugin-load
201 include/rpl_restart_server.inc [server_number=1]
202 include/assert_error_log.inc [server: 1, pattern: Cannot install the rpl_semi_sync_master plugin when the rpl_semi_sync_source plugin is installed.
203 Plugin .rpl_semi_sync_master. init function returned error.
204 Cannot install the rpl_semi_sync_source plugin when the rpl_semi_sync_master plugin is installed.
205 Plugin .rpl_semi_sync_source. init function returned error.
206 ]
207 include/assert.inc [No semisync plugin should be installed]
208 * Case c) Restart server with --init-file
209 include/rpl_restart_server.inc [server_number=1]
210 # R9.3. deprecation warnings for --init-file
211 include/assert_error_log.inc [server: 1, pattern: .rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.
212 Plugin 'rpl_semi_sync_source' init function returned error.
213 Cannot install the rpl_semi_sync_source plugin when the rpl_semi_sync_master plugin is installed.
214 ]
215 UNINSTALL PLUGIN rpl_semi_sync_master;
216 ==== R8.2 Error installing first new and then old source library ====
217 * Case a) Use INSTALL PLUGIN dynamically
218 INSTALL PLUGIN rpl_semi_sync_source SONAME 'PLUGIN_NAME';
219 # R9.1. deprecation warnings for dynamic plugin load using INSTALL PLUGIN
220 INSTALL PLUGIN rpl_semi_sync_master SONAME 'PLUGIN_NAME';
221 ERROR HY000: Cannot install the rpl_semi_sync_master plugin when the rpl_semi_sync_source plugin is installed.
222 include/assert_error_log.inc [server: 1, pattern: Plugin 'rpl_semi_sync_master' init function returned error.]
223 include/assert.inc [rpl_semi_sync_source should remain installed]
224 include/assert.inc [rpl_semi_sync_master should not be installed]
225 UNINSTALL PLUGIN rpl_semi_sync_source;
226 * Case b) Restart server with --plugin-load
227 include/rpl_restart_server.inc [server_number=1]
228 include/assert_error_log.inc [server: 1, pattern: Cannot install the rpl_semi_sync_source plugin when the rpl_semi_sync_master plugin is installed.
229 Plugin .rpl_semi_sync_source. init function returned error.
230 Cannot install the rpl_semi_sync_master plugin when the rpl_semi_sync_source plugin is installed.
231 Plugin .rpl_semi_sync_master. init function returned error.
232 ]
233 include/assert.inc [No semisync plugin should be installed]
234 * Case c) Restart server with --init-file
235 include/rpl_restart_server.inc [server_number=1]
236 # R9.3. deprecation warnings for --init-file
237 include/assert_error_log.inc [server: 1, pattern:
238 Plugin 'rpl_semi_sync_master' init function returned error.
239 Cannot install the rpl_semi_sync_master plugin when the rpl_semi_sync_source plugin is installed.
240 ]
241 UNINSTALL PLUGIN rpl_semi_sync_source;
242 ==== R8.3. Error installing first old and then new replica library ====
243 * Case a) Use INSTALL PLUGIN dynamically
244 INSTALL PLUGIN rpl_semi_sync_slave SONAME 'PLUGIN_NAME';
245 Warnings:
246 Note 1287 'rpl_semi_sync_slave' is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead
247 # R9.1. deprecation warnings for dynamic plugin load using INSTALL PLUGIN
248 include/assert_error_log.inc [server: 1, pattern: .rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.]
249 INSTALL PLUGIN rpl_semi_sync_replica SONAME 'PLUGIN_NAME';
250 ERROR HY000: Cannot install the rpl_semi_sync_replica plugin when the rpl_semi_sync_slave plugin is installed.
251 include/assert_error_log.inc [server: 1, pattern: Plugin 'rpl_semi_sync_replica' init function returned error.]
252 include/assert.inc [rpl_semi_sync_slave should remain installed]
253 include/assert.inc [rpl_semi_sync_replica should not be installed]
254 UNINSTALL PLUGIN rpl_semi_sync_slave;
255 * Case b) Restart server with --plugin-load
256 include/rpl_restart_server.inc [server_number=1]
257 include/assert_error_log.inc [server: 1, pattern: Cannot install the rpl_semi_sync_slave plugin when the rpl_semi_sync_replica plugin is installed.
258 Plugin .rpl_semi_sync_slave. init function returned error.
259 Cannot install the rpl_semi_sync_replica plugin when the rpl_semi_sync_slave plugin is installed.
260 Plugin .rpl_semi_sync_replica. init function returned error.
261 ]
262 include/assert.inc [No semisync plugin should be installed]
263 * Case c) Restart server with --init-file
264 include/rpl_restart_server.inc [server_number=1]
265 # R9.3. deprecation warnings for --init-file
266 include/assert_error_log.inc [server: 1, pattern: .rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.
267 Plugin 'rpl_semi_sync_replica' init function returned error.
268 Cannot install the rpl_semi_sync_replica plugin when the rpl_semi_sync_slave plugin is installed.
269 ]
270 UNINSTALL PLUGIN rpl_semi_sync_slave;
271 ==== R8.4. Error installing first new and then old replica library ====
272 * Case a) Use INSTALL PLUGIN dynamically
273 INSTALL PLUGIN rpl_semi_sync_replica SONAME 'PLUGIN_NAME';
274 # R9.1. deprecation warnings for dynamic plugin load using INSTALL PLUGIN
275 INSTALL PLUGIN rpl_semi_sync_slave SONAME 'PLUGIN_NAME';
276 ERROR HY000: Cannot install the rpl_semi_sync_slave plugin when the rpl_semi_sync_replica plugin is installed.
277 include/assert_error_log.inc [server: 1, pattern: Plugin 'rpl_semi_sync_slave' init function returned error.]
278 include/assert.inc [rpl_semi_sync_replica should remain installed]
279 include/assert.inc [rpl_semi_sync_slave should not be installed]
280 UNINSTALL PLUGIN rpl_semi_sync_replica;
281 * Case b) Restart server with --plugin-load
282 include/rpl_restart_server.inc [server_number=1]
283 include/assert_error_log.inc [server: 1, pattern: Cannot install the rpl_semi_sync_replica plugin when the rpl_semi_sync_slave plugin is installed.
284 Plugin .rpl_semi_sync_replica. init function returned error.
285 Cannot install the rpl_semi_sync_slave plugin when the rpl_semi_sync_replica plugin is installed.
286 Plugin .rpl_semi_sync_slave. init function returned error.
287 ]
288 include/assert.inc [No semisync plugin should be installed]
289 * Case c) Restart server with --init-file
290 include/rpl_restart_server.inc [server_number=1]
291 # R9.3. deprecation warnings for --init-file
292 include/assert_error_log.inc [server: 1, pattern:
293 Plugin 'rpl_semi_sync_slave' init function returned error.
294 Cannot install the rpl_semi_sync_slave plugin when the rpl_semi_sync_replica plugin is installed.
295 ]
296 UNINSTALL PLUGIN rpl_semi_sync_replica;
297 ==== R9.2. Deprecation warnings generated for --plugin-load ====
298 include/rpl_restart_server.inc [server_number=1]
299 include/assert_error_log.inc [server: 1, pattern: .rpl_semi_sync_master. is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.
300 .rpl_semi_sync_slave. is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.
301 ]
302 ==== Clean up ====
303 include/rpl_restart_server.inc [server_number=1]
304 [connection slave]
305 include/start_slave.inc
306 [connection master]
307 include/wait_for_slave_to_start.inc
308 DROP TABLE t1;
309 include/sync_slave_sql_with_master.inc
310 include/rpl_end.inc