Debian Codegraph @

mysql-test/suite/rpl/r/rpl_terminology_use_previous_replica_connect.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 #### Initialize ####
7 include/suppress_messages.inc
8 # Connection 1 suppresses message <Source command COM_REGISTER_REPLICA failed: failed>.
9 # Connection 1 suppresses message <Source command COM_BINLOG_DUMP failed: failed>.
10 # Connection 1 suppresses message <Failed on request_dump.. for channel>.
11 # Connection 2 suppresses message <Source command COM_REGISTER_REPLICA failed: failed>.
12 # Connection 2 suppresses message <Source command COM_BINLOG_DUMP failed: failed>.
13 # Connection 2 suppresses message <Failed on request_dump.. for channel>.
14
15 #### Testing terminology_use_previous = 0 ####
16 SET @@session.terminology_use_previous = 0;
17 Warnings:
18 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
19
20 ---- replica_waiting_to_reconnect after failed_registration ----
21 # Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug
22 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
23 START REPLICA IO_THREAD;
24 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
25 STATE
26 Waiting to reconnect after a failed registration on source
27 Warnings:
28 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
29 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
30 STATE
31 Waiting to reconnect after a failed registration on source
32 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
33 PROCESSLIST_STATE
34 Waiting to reconnect after a failed registration on source
35 Slave_IO_State = 'Waiting to reconnect after a failed registration on source'
36 # Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug
37 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
38 KILL THREAD_ID_OF_RECEIVER;
39 include/wait_for_slave_io_to_stop.inc
40
41 ---- replica_reconnecting after failed_registration ----
42 # Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug
43 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
44 START REPLICA IO_THREAD;
45 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
46 STATE
47 Reconnecting after a failed registration on source
48 Warnings:
49 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
50 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
51 STATE
52 Reconnecting after a failed registration on source
53 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
54 PROCESSLIST_STATE
55 Reconnecting after a failed registration on source
56 Slave_IO_State = 'Reconnecting after a failed registration on source'
57 # Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug
58 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
59 KILL THREAD_ID_OF_RECEIVER;
60 include/wait_for_slave_io_to_stop.inc
61
62 ---- replica_waiting_to_reconnect after failed_binlog_dump ----
63 # Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug
64 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
65 START REPLICA IO_THREAD;
66 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
67 STATE
68 Waiting to reconnect after a failed binlog dump request
69 Warnings:
70 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
71 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
72 STATE
73 Waiting to reconnect after a failed binlog dump request
74 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
75 PROCESSLIST_STATE
76 Waiting to reconnect after a failed binlog dump request
77 Slave_IO_State = 'Waiting to reconnect after a failed binlog dump request'
78 # Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug
79 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
80 KILL THREAD_ID_OF_RECEIVER;
81 include/wait_for_slave_io_to_stop.inc
82
83 ---- replica_reconnecting after failed_binlog_dump ----
84 # Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug
85 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
86 START REPLICA IO_THREAD;
87 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
88 STATE
89 Reconnecting after a failed binlog dump request
90 Warnings:
91 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
92 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
93 STATE
94 Reconnecting after a failed binlog dump request
95 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
96 PROCESSLIST_STATE
97 Reconnecting after a failed binlog dump request
98 Slave_IO_State = 'Reconnecting after a failed binlog dump request'
99 # Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug
100 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
101 KILL THREAD_ID_OF_RECEIVER;
102 include/wait_for_slave_io_to_stop.inc
103
104 ---- replica_waiting_to_reconnect after failed_event_read ----
105 # Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug
106 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
107 START REPLICA IO_THREAD;
108 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
109 STATE
110 Waiting to reconnect after a failed source event read
111 Warnings:
112 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
113 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
114 STATE
115 Waiting to reconnect after a failed source event read
116 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
117 PROCESSLIST_STATE
118 Waiting to reconnect after a failed source event read
119 Slave_IO_State = 'Waiting to reconnect after a failed source event read'
120 # Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug
121 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
122 KILL THREAD_ID_OF_RECEIVER;
123 include/wait_for_slave_io_to_stop.inc
124
125 ---- replica_reconnecting after failed_event_read ----
126 # Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug
127 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
128 START REPLICA IO_THREAD;
129 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
130 STATE
131 Reconnecting after a failed source event read
132 Warnings:
133 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
134 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
135 STATE
136 Reconnecting after a failed source event read
137 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
138 PROCESSLIST_STATE
139 Reconnecting after a failed source event read
140 Slave_IO_State = 'Reconnecting after a failed source event read'
141 # Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug
142 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
143 KILL THREAD_ID_OF_RECEIVER;
144 include/wait_for_slave_io_to_stop.inc
145
146 #### Testing terminology_use_previous = 1 ####
147 SET @@session.terminology_use_previous = 1;
148 Warnings:
149 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
150
151 ---- replica_waiting_to_reconnect after failed_registration ----
152 # Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug
153 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
154 START REPLICA IO_THREAD;
155 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
156 STATE
157 Waiting to reconnect after a failed registration on master
158 Warnings:
159 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
160 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
161 STATE
162 Waiting to reconnect after a failed registration on master
163 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
164 PROCESSLIST_STATE
165 Waiting to reconnect after a failed registration on master
166 Slave_IO_State = 'Waiting to reconnect after a failed registration on master'
167 # Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug
168 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
169 KILL THREAD_ID_OF_RECEIVER;
170 include/wait_for_slave_io_to_stop.inc
171
172 ---- replica_reconnecting after failed_registration ----
173 # Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug
174 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
175 START REPLICA IO_THREAD;
176 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
177 STATE
178 Reconnecting after a failed registration on master
179 Warnings:
180 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
181 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
182 STATE
183 Reconnecting after a failed registration on master
184 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
185 PROCESSLIST_STATE
186 Reconnecting after a failed registration on master
187 Slave_IO_State = 'Reconnecting after a failed registration on master'
188 # Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug
189 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
190 KILL THREAD_ID_OF_RECEIVER;
191 include/wait_for_slave_io_to_stop.inc
192
193 ---- replica_waiting_to_reconnect after failed_binlog_dump ----
194 # Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug
195 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
196 START REPLICA IO_THREAD;
197 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
198 STATE
199 Waiting to reconnect after a failed binlog dump request
200 Warnings:
201 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
202 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
203 STATE
204 Waiting to reconnect after a failed binlog dump request
205 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
206 PROCESSLIST_STATE
207 Waiting to reconnect after a failed binlog dump request
208 Slave_IO_State = 'Waiting to reconnect after a failed binlog dump request'
209 # Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug
210 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
211 KILL THREAD_ID_OF_RECEIVER;
212 include/wait_for_slave_io_to_stop.inc
213
214 ---- replica_reconnecting after failed_binlog_dump ----
215 # Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug
216 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
217 START REPLICA IO_THREAD;
218 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
219 STATE
220 Reconnecting after a failed binlog dump request
221 Warnings:
222 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
223 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
224 STATE
225 Reconnecting after a failed binlog dump request
226 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
227 PROCESSLIST_STATE
228 Reconnecting after a failed binlog dump request
229 Slave_IO_State = 'Reconnecting after a failed binlog dump request'
230 # Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug
231 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
232 KILL THREAD_ID_OF_RECEIVER;
233 include/wait_for_slave_io_to_stop.inc
234
235 ---- replica_waiting_to_reconnect after failed_event_read ----
236 # Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug
237 # Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug
238 START REPLICA IO_THREAD;
239 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
240 STATE
241 Waiting to reconnect after a failed master event read
242 Warnings:
243 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
244 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
245 STATE
246 Waiting to reconnect after a failed master event read
247 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
248 PROCESSLIST_STATE
249 Waiting to reconnect after a failed master event read
250 Slave_IO_State = 'Waiting to reconnect after a failed master event read'
251 # Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug
252 # Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug
253 KILL THREAD_ID_OF_RECEIVER;
254 include/wait_for_slave_io_to_stop.inc
255
256 ---- replica_reconnecting after failed_event_read ----
257 # Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug
258 # Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug
259 START REPLICA IO_THREAD;
260 SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%';
261 STATE
262 Reconnecting after a failed master event read
263 Warnings:
264 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
265 SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%';
266 STATE
267 Reconnecting after a failed master event read
268 SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%';
269 PROCESSLIST_STATE
270 Reconnecting after a failed master event read
271 Slave_IO_State = 'Reconnecting after a failed master event read'
272 # Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug
273 # Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug
274 KILL THREAD_ID_OF_RECEIVER;
275 include/wait_for_slave_io_to_stop.inc
276
277 #### Clean up ####
278 SET @@session.terminology_use_previous = NONE;
279 Warnings:
280 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
281 include/start_slave.inc
282 include/rpl_end.inc