Debian Codegraph @

mysql-test/suite/rpl/r/rpl_perfschema_connection_applier_status.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 [connection slave]
7 # Adding debug point 'rpl_ps_tables' to @@GLOBAL.debug
8 include/stop_slave_io.inc
9 [connection master]
10 CREATE TABLE t (a int);
11 [connection slave]
12 # Adding debug point 'rpl_ps_tables_queue' to @@GLOBAL.debug
13 include/start_slave_io.inc
14 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_before';
15 # Removing debug point 'rpl_ps_tables_queue' from @@GLOBAL.debug
16 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_finish';
17 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_after_finish';
18 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_continue';
19 include/assert.inc [Assert that the currently queueing gtid is equal to current_gtid]
20 include/assert.inc [Assert that the last queued gtid is equal to last_gtid]
21 include/assert.inc [Assert that currently queueing gtid was cleared]
22 include/assert.inc [Assert that currently queueing OCT was cleared]
23 include/assert.inc [Assert that currently queueing ICT was cleared]
24 include/assert.inc [Assert that currently queueing start was cleared]
25 include/assert.inc [Assert that the last queued gtid is equal to current_gtid]
26 include/assert.inc [Assert that currently queueing OCT exists]
27 include/assert.inc [Assert that currently queueing ICT exists]
28 include/assert.inc [Assert that currently queueing start_time exists]
29 include/assert.inc [Assert that the OCT of the last queued and currently queueing is the same]
30 include/assert.inc [Assert that the ICT of the last queued and currently queueing is the same]
31 include/assert.inc [Assert that the start time of the last queued and currently queueing is the same]
32 include/assert.inc [Assert that the end time of the last queued is greater than the start time]
33 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_before';
34 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_finish';
35 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_after_finish';
36 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_continue';
37 include/assert.inc [Assert that the currently applying gtid is equal to current_gtid]
38 include/assert.inc [Assert that the last applied gtid is equal to last_gtid]
39 include/assert.inc [Assert that currently applying gtid was cleared]
40 include/assert.inc [Assert that currently applying OCT was cleared]
41 include/assert.inc [Assert that currently applying ICT was cleared]
42 include/assert.inc [Assert that currently applying start was cleared]
43 include/assert.inc [Assert that the last applied gtid is equal to current_gtid]
44 include/assert.inc [Assert that currently applying OCT exists]
45 include/assert.inc [Assert that currently applying ICT exists]
46 include/assert.inc [Assert that currently applying start_time exists]
47 include/assert.inc [Assert that the OCT of the last applied and currently applying is the same]
48 include/assert.inc [Assert that the ICT of the last applied and currently applying is the same]
49 include/assert.inc [Assert that the start time of the last applied and currently applying is the same]
50 include/assert.inc [Assert that the end time of the last applied is greater than the start time]
51 include/stop_slave_io.inc
52 [connection master]
53 INSERT INTO t VALUES(1);
54 [connection slave]
55 # Adding debug point 'rpl_ps_tables_queue' to @@GLOBAL.debug
56 include/start_slave_io.inc
57 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_before';
58 # Removing debug point 'rpl_ps_tables_queue' from @@GLOBAL.debug
59 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_finish';
60 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_after_finish';
61 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_continue';
62 include/assert.inc [Assert that the currently queueing gtid is equal to current_gtid]
63 include/assert.inc [Assert that the last queued gtid is equal to last_gtid]
64 include/assert.inc [Assert that currently queueing gtid was cleared]
65 include/assert.inc [Assert that currently queueing OCT was cleared]
66 include/assert.inc [Assert that currently queueing ICT was cleared]
67 include/assert.inc [Assert that currently queueing start was cleared]
68 include/assert.inc [Assert that the last queued gtid is equal to current_gtid]
69 include/assert.inc [Assert that currently queueing OCT exists]
70 include/assert.inc [Assert that currently queueing ICT exists]
71 include/assert.inc [Assert that currently queueing start_time exists]
72 include/assert.inc [Assert that the OCT of the last queued and currently queueing is the same]
73 include/assert.inc [Assert that the ICT of the last queued and currently queueing is the same]
74 include/assert.inc [Assert that the start time of the last queued and currently queueing is the same]
75 include/assert.inc [Assert that the end time of the last queued is greater than the start time]
76 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_before';
77 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_finish';
78 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_after_finish';
79 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_continue';
80 include/assert.inc [Assert that the currently applying gtid is equal to current_gtid]
81 include/assert.inc [Assert that the last applied gtid is equal to last_gtid]
82 include/assert.inc [Assert that currently applying gtid was cleared]
83 include/assert.inc [Assert that currently applying OCT was cleared]
84 include/assert.inc [Assert that currently applying ICT was cleared]
85 include/assert.inc [Assert that currently applying start was cleared]
86 include/assert.inc [Assert that the last applied gtid is equal to current_gtid]
87 include/assert.inc [Assert that currently applying OCT exists]
88 include/assert.inc [Assert that currently applying ICT exists]
89 include/assert.inc [Assert that currently applying start_time exists]
90 include/assert.inc [Assert that the OCT of the last applied and currently applying is the same]
91 include/assert.inc [Assert that the ICT of the last applied and currently applying is the same]
92 include/assert.inc [Assert that the start time of the last applied and currently applying is the same]
93 include/assert.inc [Assert that the end time of the last applied is greater than the start time]
94 include/stop_slave_io.inc
95 [connection master]
96 UPDATE t SET a=2;
97 [connection slave]
98 # Adding debug point 'rpl_ps_tables_queue' to @@GLOBAL.debug
99 include/start_slave_io.inc
100 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_before';
101 # Removing debug point 'rpl_ps_tables_queue' from @@GLOBAL.debug
102 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_finish';
103 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_after_finish';
104 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_continue';
105 include/assert.inc [Assert that the currently queueing gtid is equal to current_gtid]
106 include/assert.inc [Assert that the last queued gtid is equal to last_gtid]
107 include/assert.inc [Assert that currently queueing gtid was cleared]
108 include/assert.inc [Assert that currently queueing OCT was cleared]
109 include/assert.inc [Assert that currently queueing ICT was cleared]
110 include/assert.inc [Assert that currently queueing start was cleared]
111 include/assert.inc [Assert that the last queued gtid is equal to current_gtid]
112 include/assert.inc [Assert that currently queueing OCT exists]
113 include/assert.inc [Assert that currently queueing ICT exists]
114 include/assert.inc [Assert that currently queueing start_time exists]
115 include/assert.inc [Assert that the OCT of the last queued and currently queueing is the same]
116 include/assert.inc [Assert that the ICT of the last queued and currently queueing is the same]
117 include/assert.inc [Assert that the start time of the last queued and currently queueing is the same]
118 include/assert.inc [Assert that the end time of the last queued is greater than the start time]
119 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_before';
120 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_finish';
121 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_after_finish';
122 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_continue';
123 include/assert.inc [Assert that the currently applying gtid is equal to current_gtid]
124 include/assert.inc [Assert that the last applied gtid is equal to last_gtid]
125 include/assert.inc [Assert that currently applying gtid was cleared]
126 include/assert.inc [Assert that currently applying OCT was cleared]
127 include/assert.inc [Assert that currently applying ICT was cleared]
128 include/assert.inc [Assert that currently applying start was cleared]
129 include/assert.inc [Assert that the last applied gtid is equal to current_gtid]
130 include/assert.inc [Assert that currently applying OCT exists]
131 include/assert.inc [Assert that currently applying ICT exists]
132 include/assert.inc [Assert that currently applying start_time exists]
133 include/assert.inc [Assert that the OCT of the last applied and currently applying is the same]
134 include/assert.inc [Assert that the ICT of the last applied and currently applying is the same]
135 include/assert.inc [Assert that the start time of the last applied and currently applying is the same]
136 include/assert.inc [Assert that the end time of the last applied is greater than the start time]
137 include/stop_slave_io.inc
138 [connection master]
139 DELETE FROM t WHERE a=2;
140 [connection slave]
141 # Adding debug point 'rpl_ps_tables_queue' to @@GLOBAL.debug
142 include/start_slave_io.inc
143 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_before';
144 # Removing debug point 'rpl_ps_tables_queue' from @@GLOBAL.debug
145 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_finish';
146 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_after_finish';
147 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_continue';
148 include/assert.inc [Assert that the currently queueing gtid is equal to current_gtid]
149 include/assert.inc [Assert that the last queued gtid is equal to last_gtid]
150 include/assert.inc [Assert that currently queueing gtid was cleared]
151 include/assert.inc [Assert that currently queueing OCT was cleared]
152 include/assert.inc [Assert that currently queueing ICT was cleared]
153 include/assert.inc [Assert that currently queueing start was cleared]
154 include/assert.inc [Assert that the last queued gtid is equal to current_gtid]
155 include/assert.inc [Assert that currently queueing OCT exists]
156 include/assert.inc [Assert that currently queueing ICT exists]
157 include/assert.inc [Assert that currently queueing start_time exists]
158 include/assert.inc [Assert that the OCT of the last queued and currently queueing is the same]
159 include/assert.inc [Assert that the ICT of the last queued and currently queueing is the same]
160 include/assert.inc [Assert that the start time of the last queued and currently queueing is the same]
161 include/assert.inc [Assert that the end time of the last queued is greater than the start time]
162 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_before';
163 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_finish';
164 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_after_finish';
165 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_continue';
166 include/assert.inc [Assert that the currently applying gtid is equal to current_gtid]
167 include/assert.inc [Assert that the last applied gtid is equal to last_gtid]
168 include/assert.inc [Assert that currently applying gtid was cleared]
169 include/assert.inc [Assert that currently applying OCT was cleared]
170 include/assert.inc [Assert that currently applying ICT was cleared]
171 include/assert.inc [Assert that currently applying start was cleared]
172 include/assert.inc [Assert that the last applied gtid is equal to current_gtid]
173 include/assert.inc [Assert that currently applying OCT exists]
174 include/assert.inc [Assert that currently applying ICT exists]
175 include/assert.inc [Assert that currently applying start_time exists]
176 include/assert.inc [Assert that the OCT of the last applied and currently applying is the same]
177 include/assert.inc [Assert that the ICT of the last applied and currently applying is the same]
178 include/assert.inc [Assert that the start time of the last applied and currently applying is the same]
179 include/assert.inc [Assert that the end time of the last applied is greater than the start time]
180 include/stop_slave_io.inc
181 [connection master]
182 DROP TABLE t;
183 [connection slave]
184 # Adding debug point 'rpl_ps_tables_queue' to @@GLOBAL.debug
185 include/start_slave_io.inc
186 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_before';
187 # Removing debug point 'rpl_ps_tables_queue' from @@GLOBAL.debug
188 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_finish';
189 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_queue_after_finish';
190 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_queue_continue';
191 include/assert.inc [Assert that the currently queueing gtid is equal to current_gtid]
192 include/assert.inc [Assert that the last queued gtid is equal to last_gtid]
193 include/assert.inc [Assert that currently queueing gtid was cleared]
194 include/assert.inc [Assert that currently queueing OCT was cleared]
195 include/assert.inc [Assert that currently queueing ICT was cleared]
196 include/assert.inc [Assert that currently queueing start was cleared]
197 include/assert.inc [Assert that the last queued gtid is equal to current_gtid]
198 include/assert.inc [Assert that currently queueing OCT exists]
199 include/assert.inc [Assert that currently queueing ICT exists]
200 include/assert.inc [Assert that currently queueing start_time exists]
201 include/assert.inc [Assert that the OCT of the last queued and currently queueing is the same]
202 include/assert.inc [Assert that the ICT of the last queued and currently queueing is the same]
203 include/assert.inc [Assert that the start time of the last queued and currently queueing is the same]
204 include/assert.inc [Assert that the end time of the last queued is greater than the start time]
205 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_before';
206 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_finish';
207 SET debug_sync= 'now WAIT_FOR signal.rpl_ps_tables_apply_after_finish';
208 SET debug_sync= 'now SIGNAL signal.rpl_ps_tables_apply_continue';
209 include/assert.inc [Assert that the currently applying gtid is equal to current_gtid]
210 include/assert.inc [Assert that the last applied gtid is equal to last_gtid]
211 include/assert.inc [Assert that currently applying gtid was cleared]
212 include/assert.inc [Assert that currently applying OCT was cleared]
213 include/assert.inc [Assert that currently applying ICT was cleared]
214 include/assert.inc [Assert that currently applying start was cleared]
215 include/assert.inc [Assert that the last applied gtid is equal to current_gtid]
216 include/assert.inc [Assert that currently applying OCT exists]
217 include/assert.inc [Assert that currently applying ICT exists]
218 include/assert.inc [Assert that currently applying start_time exists]
219 include/assert.inc [Assert that the OCT of the last applied and currently applying is the same]
220 include/assert.inc [Assert that the ICT of the last applied and currently applying is the same]
221 include/assert.inc [Assert that the start time of the last applied and currently applying is the same]
222 include/assert.inc [Assert that the end time of the last applied is greater than the start time]
223 # Removing debug point 'rpl_ps_tables' from @@GLOBAL.debug
224 include/stop_slave.inc
225 include/assert.inc [Assert that the gtid is kept while the slave is stopped]
226 include/start_slave.inc
227 include/assert.inc [Assert that the gtid is kept after the slave was stopped and started]
228 [connection master]
229 SET SESSION GTID_NEXT= AUTOMATIC;
230 include/sync_slave_sql_with_master.inc
231 [connection master]
232 SET SQL_LOG_BIN= 0;
233 CREATE TABLE t1(i INT);
234 SET SQL_LOG_BIN= 1;
235 [connection slave]
236 call mtr.add_suppression("Replica SQL for channel '': .*Error .Unknown table .test.t1.. on query.* Error_code: MY-001051");
237 call mtr.add_suppression("Replica: Unknown table .test.t1. Error_code: MY-001051");
238 call mtr.add_suppression("Replica SQL for channel '': .*Error executing row event: 'Table 'test.t1' doesn't exist'");
239 call mtr.add_suppression("Replica SQL for channel '': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state.*");
240 [connection master]
241 DROP TABLE t1;
242 [connection slave]
243 include/wait_for_slave_sql_error.inc [errno=1051]
244 include/assert.inc [LAST_APPLIED_TRANSACTION did not change after the failed DDL]
245 include/assert.inc [APPLYING_TRANSACTION is equal to the failed transaction GTID]
246 include/stop_slave.inc
247 [connection master]
248 include/rpl_reset.inc
249 SET SQL_LOG_BIN= 0;
250 CREATE TABLE t1(i INT);
251 SET SQL_LOG_BIN= 1;
252 INSERT INTO t1 VALUES (1);
253 [connection slave]
254 include/wait_for_slave_sql_error.inc [errno=1146]
255 include/assert.inc [LAST_APPLIED_TRANSACTION did not change after the failed DML]
256 include/assert.inc [APPLYING_TRANSACTION is equal to the failed transaction GTID]
257 [connection master]
258 SET SQL_LOG_BIN= 0;
259 DROP TABLE t1;
260 SET SQL_LOG_BIN= 1;
261 include/rpl_reset.inc
262 [connection master]
263 [connection slave]
264 include/stop_slave.inc
265 SET GLOBAL replica_parallel_workers= 4;
266 include/start_slave.inc
267 include/assert.inc [processing_gtid is cleared when a former STS slave restarts with MTS enabled]
268 include/assert.inc [last_processed_gtid is cleared when a former STS slave restarts with MTS enabled]
269 include/stop_slave.inc
270 SET GLOBAL replica_parallel_workers= 0;
271 Warnings:
272 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
273 include/start_slave.inc
274 include/rpl_end.inc