Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 STOP SLAVE;
5 include/wait_for_slave_to_stop.inc
6 connection master;
7 SET SESSION BINLOG_FORMAT=ROW;
8 CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM;
9 CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM;
10 INSERT INTO t1 VALUES (1,1),(2,4),(3,9);
11 INSERT INTO t2 VALUES (1,1),(2,8),(3,27);
12 UPDATE t1,t2 SET b = d, d = b * 2 WHERE a = c;
13 include/show_binlog_events.inc
14 Log_name Pos Event_type Server_id End_log_pos Info
15 master-bin.000001 # Gtid # # GTID #-#-#
16 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM
17 master-bin.000001 # Gtid # # GTID #-#-#
18 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM
19 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
20 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1,1),(2,4),(3,9)
21 master-bin.000001 # Table_map # # table_id: # (test.t1)
22 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
23 master-bin.000001 # Query # # COMMIT
24 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
25 master-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1,1),(2,8),(3,27)
26 master-bin.000001 # Table_map # # table_id: # (test.t2)
27 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
28 master-bin.000001 # Query # # COMMIT
29 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
30 master-bin.000001 # Annotate_rows # # UPDATE t1,t2 SET b = d, d = b * 2 WHERE a = c
31 master-bin.000001 # Table_map # # table_id: # (test.t1)
32 master-bin.000001 # Table_map # # table_id: # (test.t2)
33 master-bin.000001 # Update_rows_v1 # # table_id: #
34 master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
35 master-bin.000001 # Query # # COMMIT
36 SELECT * FROM t1;
37 a b
38 1 1
39 2 8
40 3 27
41 SELECT * FROM t2;
42 c d
43 1 2
44 2 8
45 3 18
46 connection slave;
47 START SLAVE UNTIL MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=MASTER_LOG_POS;
48 include/wait_for_slave_sql_to_stop.inc
49 include/check_slave_param.inc [Exec_Master_Log_Pos]
50 include/check_slave_no_error.inc
51 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
52 START SLAVE;
53 include/wait_for_slave_to_start.inc
54 SELECT * FROM t1;
55 a b
56 1 1
57 2 4
58 3 9
59 SELECT * FROM t2;
60 c d
61 1 1
62 2 8
63 3 27
64 STOP SLAVE;
65 include/wait_for_slave_to_stop.inc
66 include/reset_slave.inc
67 connection master;
68 RESET MASTER;
69 SET SESSION BINLOG_FORMAT=STATEMENT;
70 SET @foo = 12;
71 INSERT INTO t1 VALUES(@foo, 2*@foo);
72 include/show_binlog_events.inc
73 Log_name Pos Event_type Server_id End_log_pos Info
74 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
75 master-bin.000001 # User var # # @`foo`=12
76 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(@foo, 2*@foo)
77 master-bin.000001 # Query # # COMMIT
78 connection slave;
79 START SLAVE UNTIL MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=MASTER_LOG_POS;
80 include/wait_for_slave_sql_to_stop.inc
81 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
82 START SLAVE;
83 include/wait_for_slave_to_start.inc
84 connection master;
85 DROP TABLE t1, t2;
86 connection slave;
87 connection master;
88 SET SESSION BINLOG_FORMAT=ROW;
89 SET AUTOCOMMIT=0;
90 CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=myisam;
91 CREATE TABLE t2 (a INT, b VARCHAR(20)) ENGINE=myisam;
92 CREATE TABLE t3 (a INT, b VARCHAR(20)) ENGINE=myisam;
93 INSERT INTO t1 VALUES (1,'master/slave');
94 INSERT INTO t2 VALUES (1,'master/slave');
95 INSERT INTO t3 VALUES (1,'master/slave');
96 CREATE TRIGGER tr1 AFTER UPDATE on t1 FOR EACH ROW
97 BEGIN
98 INSERT INTO t2 VALUES (NEW.a,NEW.b);
99 DELETE FROM t2 WHERE a < NEW.a;
100 END|
101 CREATE TRIGGER tr2 AFTER INSERT on t2 FOR EACH ROW
102 BEGIN
103 UPDATE t3 SET a =2, b = 'master only';
104 END|
105 connection slave;
106 include/stop_slave.inc
107 connection master;
108 UPDATE t1 SET a = 2, b = 'master only' WHERE a = 1;
109 DROP TRIGGER tr1;
110 DROP TRIGGER tr2;
111 INSERT INTO t1 VALUES (3,'master/slave');
112 INSERT INTO t2 VALUES (3,'master/slave');
113 INSERT INTO t3 VALUES (3,'master/slave');
114 COMMIT;
115 SELECT * FROM t1 ORDER BY a;
116 a b
117 2 master only
118 3 master/slave
119 SELECT * FROM t2 ORDER BY a;
120 a b
121 2 master only
122 3 master/slave
123 SELECT * FROM t3 ORDER BY a;
124 a b
125 2 master only
126 3 master/slave
127 connection slave;
128 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
129 include/start_slave.inc
130 SELECT * FROM t1 ORDER BY a;
131 a b
132 1 master/slave
133 3 master/slave
134 SELECT * FROM t2 ORDER BY a;
135 a b
136 1 master/slave
137 3 master/slave
138 SELECT * FROM t3 ORDER BY a;
139 a b
140 1 master/slave
141 3 master/slave
142 connection master;
143 DROP TABLE t1, t2, t3;
144 connection slave;
145 **** Case 2: Row binlog format and transactional tables ****
146 connection master;
147 CREATE TABLE t4 (a INT, b VARCHAR(20)) ENGINE=innodb;
148 CREATE TABLE t5 (a INT, b VARCHAR(20)) ENGINE=innodb;
149 CREATE TABLE t6 (a INT, b VARCHAR(20)) ENGINE=innodb;
150 connection slave;
151 include/stop_slave.inc
152 connection master;
153 BEGIN;
154 INSERT INTO t4 VALUES (2, 'master only');
155 INSERT INTO t5 VALUES (2, 'master only');
156 INSERT INTO t6 VALUES (2, 'master only');
157 COMMIT;
158 BEGIN;
159 INSERT INTO t4 VALUES (3, 'master/slave');
160 INSERT INTO t5 VALUES (3, 'master/slave');
161 INSERT INTO t6 VALUES (3, 'master/slave');
162 COMMIT;
163 SELECT * FROM t4 ORDER BY a;
164 a b
165 2 master only
166 3 master/slave
167 SELECT * FROM t5 ORDER BY a;
168 a b
169 2 master only
170 3 master/slave
171 SELECT * FROM t6 ORDER BY a;
172 a b
173 2 master only
174 3 master/slave
175 connection slave;
176 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
177 include/start_slave.inc
178 SELECT * FROM t4 ORDER BY a;
179 a b
180 3 master/slave
181 SELECT * FROM t5 ORDER BY a;
182 a b
183 3 master/slave
184 SELECT * FROM t6 ORDER BY a;
185 a b
186 3 master/slave
187 connection slave;
188 include/stop_slave.inc
189 connection master;
190 BEGIN;
191 INSERT INTO t4 VALUES (6, 'master only');
192 INSERT INTO t5 VALUES (6, 'master only');
193 INSERT INTO t6 VALUES (6, 'master only');
194 COMMIT;
195 BEGIN;
196 INSERT INTO t4 VALUES (7, 'master only');
197 INSERT INTO t5 VALUES (7, 'master only');
198 INSERT INTO t6 VALUES (7, 'master only');
199 COMMIT;
200 SELECT * FROM t4 ORDER BY a;
201 a b
202 2 master only
203 3 master/slave
204 6 master only
205 7 master only
206 SELECT * FROM t5 ORDER BY a;
207 a b
208 2 master only
209 3 master/slave
210 6 master only
211 7 master only
212 SELECT * FROM t6 ORDER BY a;
213 a b
214 2 master only
215 3 master/slave
216 6 master only
217 7 master only
218 connection slave;
219 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=12;
220 include/start_slave.inc
221 SELECT * FROM t4 ORDER BY a;
222 a b
223 3 master/slave
224 SELECT * FROM t5 ORDER BY a;
225 a b
226 3 master/slave
227 SELECT * FROM t6 ORDER BY a;
228 a b
229 3 master/slave
230 connection slave;
231 include/stop_slave.inc
232 connection master;
233 SET AUTOCOMMIT=0;
234 INSERT INTO t4 VALUES (4, 'master only');
235 INSERT INTO t5 VALUES (4, 'master only');
236 INSERT INTO t6 VALUES (4, 'master only');
237 COMMIT;
238 INSERT INTO t4 VALUES (5, 'master/slave');
239 INSERT INTO t5 VALUES (5, 'master/slave');
240 INSERT INTO t6 VALUES (5, 'master/slave');
241 COMMIT;
242 SELECT * FROM t4 ORDER BY a;
243 a b
244 2 master only
245 3 master/slave
246 4 master only
247 5 master/slave
248 6 master only
249 7 master only
250 SELECT * FROM t5 ORDER BY a;
251 a b
252 2 master only
253 3 master/slave
254 4 master only
255 5 master/slave
256 6 master only
257 7 master only
258 SELECT * FROM t6 ORDER BY a;
259 a b
260 2 master only
261 3 master/slave
262 4 master only
263 5 master/slave
264 6 master only
265 7 master only
266 connection slave;
267 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
268 include/start_slave.inc
269 SELECT * FROM t4 ORDER BY a;
270 a b
271 3 master/slave
272 5 master/slave
273 SELECT * FROM t5 ORDER BY a;
274 a b
275 3 master/slave
276 5 master/slave
277 SELECT * FROM t6 ORDER BY a;
278 a b
279 3 master/slave
280 5 master/slave
281 connection master;
282 DROP TABLE t4, t5, t6;
283 connection slave;
284 **** Case 3: Statement logging format and LOAD DATA with non-transactional table ****
285 connection master;
286 CREATE TABLE t10 (a INT, b VARCHAR(20)) ENGINE=myisam;
287 connection slave;
288 include/stop_slave.inc
289 connection master;
290 SET SESSION BINLOG_FORMAT=STATEMENT;
291 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_bug28618.dat' INTO TABLE t10 FIELDS TERMINATED BY '|';
292 SELECT * FROM t10 ORDER BY a;
293 a b
294 1 master only
295 2 master only
296 3 master only
297 connection slave;
298 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
299 include/start_slave.inc
300 SELECT * FROM t10 ORDER BY a;
301 a b
302 connection master;
303 DROP TABLE t10;
304 connection slave;
305 include/rpl_end.inc