Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_slave_skip.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 **** On Slave ****
7 STOP SLAVE;
8 Warnings:
9 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
10 include/wait_for_slave_to_stop.inc
11 **** On Master ****
12 SET SESSION BINLOG_FORMAT='ROW';
13 Warnings:
14 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
15 CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM;
16 CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM;
17 INSERT INTO t1 VALUES (1,1),(2,4),(3,9);
18 INSERT INTO t2 VALUES (1,1),(2,8),(3,27);
19 UPDATE t1,t2 SET b = d, d = b * 2 WHERE a = c;
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM
23 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM
24 master-bin.000001 # Query # # BEGIN
25 master-bin.000001 # Table_map # # table_id: # (test.t1)
26 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
27 master-bin.000001 # Query # # COMMIT
28 master-bin.000001 # Query # # BEGIN
29 master-bin.000001 # Table_map # # table_id: # (test.t2)
30 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
31 master-bin.000001 # Query # # COMMIT
32 master-bin.000001 # Query # # BEGIN
33 master-bin.000001 # Table_map # # table_id: # (test.t1)
34 master-bin.000001 # Table_map # # table_id: # (test.t2)
35 master-bin.000001 # Update_rows # # table_id: #
36 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
37 master-bin.000001 # Query # # COMMIT
38 SELECT * FROM t1;
39 a b
40 1 1
41 2 8
42 3 27
43 SELECT * FROM t2;
44 c d
45 1 2
46 2 16
47 3 54
48 **** On Slave ****
49 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_LOG_POS;
50 Warnings:
51 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
52 include/wait_for_slave_sql_to_stop.inc
53 include/check_slave_param.inc [Exec_Master_Log_Pos]
54 include/check_slave_no_error.inc
55 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
56 START SLAVE;
57 Warnings:
58 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
59 include/wait_for_slave_to_start.inc
60 SELECT * FROM t1;
61 a b
62 1 1
63 2 4
64 3 9
65 SELECT * FROM t2;
66 c d
67 1 1
68 2 8
69 3 27
70 STOP SLAVE;
71 Warnings:
72 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
73 include/wait_for_slave_to_stop.inc
74 RESET SLAVE;
75 Warnings:
76 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
77 RESET MASTER;
78 SET SESSION BINLOG_FORMAT=STATEMENT;
79 Warnings:
80 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
81 SET @foo = 12;
82 INSERT INTO t1 VALUES(@foo, 2*@foo);
83 include/show_binlog_events.inc
84 Log_name Pos Event_type Server_id End_log_pos Info
85 master-bin.000001 # Query # # BEGIN
86 master-bin.000001 # User var # # @`foo`=12
87 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(@foo, 2*@foo)
88 master-bin.000001 # Query # # COMMIT
89 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_LOG_POS;
90 Warnings:
91 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
92 include/wait_for_slave_sql_to_stop.inc
93 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
94 START SLAVE;
95 Warnings:
96 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
97 include/wait_for_slave_to_start.inc
98 **** On Master ****
99 DROP TABLE t1, t2;
100 include/sync_slave_sql_with_master.inc
101 **** Case 2: Row binlog format and transactional tables ****
102 *** On Master ***
103 CREATE TABLE t4 (a INT, b VARCHAR(20)) ENGINE=innodb;
104 CREATE TABLE t5 (a INT, b VARCHAR(20)) ENGINE=innodb;
105 CREATE TABLE t6 (a INT, b VARCHAR(20)) ENGINE=innodb;
106 **** On Slave ****
107 include/sync_slave_sql_with_master.inc
108 include/stop_slave.inc
109 *** On Master ***
110 BEGIN;
111 INSERT INTO t4 VALUES (2, 'master only');
112 INSERT INTO t5 VALUES (2, 'master only');
113 INSERT INTO t6 VALUES (2, 'master only');
114 COMMIT;
115 BEGIN;
116 INSERT INTO t4 VALUES (3, 'master/slave');
117 INSERT INTO t5 VALUES (3, 'master/slave');
118 INSERT INTO t6 VALUES (3, 'master/slave');
119 COMMIT;
120 SELECT * FROM t4 ORDER BY a;
121 a b
122 2 master only
123 3 master/slave
124 SELECT * FROM t5 ORDER BY a;
125 a b
126 2 master only
127 3 master/slave
128 SELECT * FROM t6 ORDER BY a;
129 a b
130 2 master only
131 3 master/slave
132 *** On Slave ***
133 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
134 include/start_slave.inc
135 SELECT * FROM t4 ORDER BY a;
136 a b
137 3 master/slave
138 SELECT * FROM t5 ORDER BY a;
139 a b
140 3 master/slave
141 SELECT * FROM t6 ORDER BY a;
142 a b
143 3 master/slave
144 **** On Slave ****
145 include/stop_slave.inc
146 *** On Master ***
147 BEGIN;
148 INSERT INTO t4 VALUES (6, 'master only');
149 INSERT INTO t5 VALUES (6, 'master only');
150 INSERT INTO t6 VALUES (6, 'master only');
151 COMMIT;
152 BEGIN;
153 INSERT INTO t4 VALUES (7, 'master only');
154 INSERT INTO t5 VALUES (7, 'master only');
155 INSERT INTO t6 VALUES (7, 'master only');
156 COMMIT;
157 SELECT * FROM t4 ORDER BY a;
158 a b
159 2 master only
160 3 master/slave
161 6 master only
162 7 master only
163 SELECT * FROM t5 ORDER BY a;
164 a b
165 2 master only
166 3 master/slave
167 6 master only
168 7 master only
169 SELECT * FROM t6 ORDER BY a;
170 a b
171 2 master only
172 3 master/slave
173 6 master only
174 7 master only
175 *** On Slave ***
176 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=11;
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 include/stop_slave.inc
188 SET AUTOCOMMIT=0;
189 INSERT INTO t4 VALUES (4, 'master only');
190 INSERT INTO t5 VALUES (4, 'master only');
191 INSERT INTO t6 VALUES (4, 'master only');
192 COMMIT;
193 INSERT INTO t4 VALUES (5, 'master/slave');
194 INSERT INTO t5 VALUES (5, 'master/slave');
195 INSERT INTO t6 VALUES (5, 'master/slave');
196 COMMIT;
197 SELECT * FROM t4 ORDER BY a;
198 a b
199 2 master only
200 3 master/slave
201 4 master only
202 5 master/slave
203 6 master only
204 7 master only
205 SELECT * FROM t5 ORDER BY a;
206 a b
207 2 master only
208 3 master/slave
209 4 master only
210 5 master/slave
211 6 master only
212 7 master only
213 SELECT * FROM t6 ORDER BY a;
214 a b
215 2 master only
216 3 master/slave
217 4 master only
218 5 master/slave
219 6 master only
220 7 master only
221 *** On Slave ***
222 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
223 include/start_slave.inc
224 SELECT * FROM t4 ORDER BY a;
225 a b
226 3 master/slave
227 5 master/slave
228 SELECT * FROM t5 ORDER BY a;
229 a b
230 3 master/slave
231 5 master/slave
232 SELECT * FROM t6 ORDER BY a;
233 a b
234 3 master/slave
235 5 master/slave
236 DROP TABLE t4, t5, t6;
237 include/sync_slave_sql_with_master.inc
238 include/rpl_end.inc