Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_replica_skip_errors.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 #
7 # Initialize
8 #
9 [connection slave]
10 include/suppress_messages.inc
11 # Connection 2 suppresses message <Replica SQL for channel .*: Worker 1 failed executing transaction.*>.
12 #
13 # R1.1. CREATE TABLE fails because table exists on replica
14 #
15 [connection slave]
16 CREATE TABLE t (a INT PRIMARY KEY);
17 include/save_binlog_position.inc
18 [connection master]
19 CREATE TABLE t (a INT PRIMARY KEY);
20 include/sync_slave_sql_with_master.inc
21 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
22 [connection master]
23 DROP table t;
24 include/sync_slave_sql_with_master.inc
25 #
26 # R1.2. CREATE TABLE ... SELECT fails because table exists on replica
27 # with binlog_format=STATEMENT
28 #
29 [connection master]
30 CREATE TABLE t0 (a INT PRIMARY KEY);
31 INSERT INTO t0 VALUES (1), (2);
32 include/sync_slave_sql_with_master.inc
33 CREATE TABLE t (a TEXT);
34 include/save_binlog_position.inc
35 [connection master]
36 SET @@session.binlog_format = STATEMENT;
37 Warnings:
38 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
39 CREATE TABLE t (a INT PRIMARY KEY) SELECT * FROM t0;
40 SET @@session.binlog_format = ROW;
41 Warnings:
42 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
43 include/sync_slave_sql_with_master.inc
44 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
45 [connection master]
46 DROP TABLE t;
47 include/sync_slave_sql_with_master.inc
48 #
49 # R1.3. CREATE TABLE ... SELECT fails because table exists on replica
50 # with binlog_format=ROW
51 #
52 [connection slave]
53 CREATE TABLE t (a TEXT);
54 include/save_binlog_position.inc
55 [connection master]
56 CREATE TABLE t (a INT PRIMARY KEY) SELECT * FROM t0;
57 include/sync_slave_sql_with_master.inc
58 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
59 [connection master]
60 DROP TABLE t0;
61 include/sync_slave_sql_with_master.inc
62 #
63 # R2. ALTER TABLE fails because table does not exist on replica
64 #
65 [connection slave]
66 DROP TABLE t;
67 include/save_binlog_position.inc
68 [connection master]
69 ALTER TABLE t ADD COLUMN b INT;
70 include/sync_slave_sql_with_master.inc
71 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
72 include/save_binlog_position.inc
73 #
74 # R3. OPTIMIZE TABLE fails because table does not exist on replica
75 #
76 [connection master]
77 OPTIMIZE TABLE t;
78 Table Op Msg_type Msg_text
79 test.t optimize note Table does not support optimize, doing recreate + analyze instead
80 test.t optimize status OK
81 include/sync_slave_sql_with_master.inc
82 include/assert_binlog_events.inc [Gtid # Query/.*OPTIMIZE TABLE t]
83 include/save_binlog_position.inc
84 #
85 # R4. CREATE TRIGGER fails because table does not exist on replica
86 #
87 [connection master]
88 CREATE TRIGGER trig BEFORE UPDATE ON t FOR EACH ROW SET @tmp := 1;
89 include/sync_slave_sql_with_master.inc
90 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
91 include/save_binlog_position.inc
92 #
93 # R5. DROP TABLE fails because table does not exist on replica
94 #
95 [connection master]
96 DROP TABLE t;
97 include/sync_slave_sql_with_master.inc
98 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
99 #
100 # R6.1 INSERT fails because row exists: ROW (InnoDB)
101 #
102 [connection master]
103 CREATE TABLE t (a INT PRIMARY KEY) ENGINE = InnoDB;
104 include/sync_slave_sql_with_master.inc
105 INSERT INTO t VALUES (1);
106 include/save_binlog_position.inc
107 [connection master]
108 INSERT INTO t VALUES (1);
109 include/sync_slave_sql_with_master.inc
110 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
111 include/save_binlog_position.inc
112 #
113 # R7.1 INSERT fails because table does not exist: ROW (InnoDB)
114 #
115 [connection slave]
116 DROP TABLE t;
117 include/save_binlog_position.inc
118 [connection master]
119 INSERT INTO t VALUES (2);
120 include/sync_slave_sql_with_master.inc
121 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
122 [connection master]
123 DROP TABLE IF EXISTS t;
124 include/sync_slave_sql_with_master.inc
125 #
126 # R6.2 INSERT fails because row exists: STATEMENT (InnoDB)
127 #
128 [connection master]
129 CREATE TABLE t (a INT PRIMARY KEY) ENGINE = InnoDB;
130 include/sync_slave_sql_with_master.inc
131 INSERT INTO t VALUES (1);
132 include/save_binlog_position.inc
133 [connection master]
134 INSERT INTO t VALUES (1);
135 include/sync_slave_sql_with_master.inc
136 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
137 include/save_binlog_position.inc
138 #
139 # R7.2 INSERT fails because table does not exist: STATEMENT (InnoDB)
140 #
141 [connection slave]
142 DROP TABLE t;
143 include/save_binlog_position.inc
144 [connection master]
145 INSERT INTO t VALUES (2);
146 include/sync_slave_sql_with_master.inc
147 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
148 [connection master]
149 DROP TABLE IF EXISTS t;
150 include/sync_slave_sql_with_master.inc
151 #
152 # R8. A DDL statement fails with parse error
153 #
154 [connection slave]
155 include/save_binlog_position.inc
156 [connection master]
157 # Adding debug point 'binlog_corrupt_query' to @@GLOBAL.debug
158 CREATE TABLE t (a INT);
159 # Removing debug point 'binlog_corrupt_query' from @@GLOBAL.debug
160 include/sync_slave_sql_with_master.inc
161 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
162 [connection master]
163 DROP TABLE IF EXISTS t;
164 include/sync_slave_sql_with_master.inc
165 #
166 # R9. A DML statement fails with parse error
167 #
168 [connection master]
169 CREATE TABLE t (a INT);
170 include/sync_slave_sql_with_master.inc
171 include/save_binlog_position.inc
172 [connection master]
173 SET @@session.binlog_format = STATEMENT;
174 Warnings:
175 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
176 # Adding debug point 'binlog_corrupt_query' to @@GLOBAL.debug
177 INSERT INTO t VALUES (1);
178 # Removing debug point 'binlog_corrupt_query' from @@GLOBAL.debug
179 SET @@session.binlog_format = ROW;
180 Warnings:
181 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
182 include/sync_slave_sql_with_master.inc
183 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
184 [connection master]
185 DROP TABLE t;
186 include/sync_slave_sql_with_master.inc
187 #
188 # R10. CREATE USER fails because the user exists
189 #
190 [connection slave]
191 CREATE USER user1;
192 include/save_binlog_position.inc
193 [connection master]
194 CREATE USER user1;
195 include/sync_slave_sql_with_master.inc
196 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
197 [connection master]
198 DROP USER user1;
199 include/sync_slave_sql_with_master.inc
200 #
201 # R11. XA COMMIT fails because the XID does not exist
202 #
203 [connection master]
204 CREATE TABLE t (a INT PRIMARY KEY);
205 XA START 'a';
206 INSERT INTO t VALUES (2);
207 XA END 'a';
208 XA PREPARE 'a';
209 include/sync_slave_sql_with_master.inc
210 [connection slave]
211 include/wait_for_xa_prepared_count.inc
212 XA ROLLBACK 'a';
213 include/save_binlog_position.inc
214 [connection master]
215 XA COMMIT 'a';
216 include/sync_slave_sql_with_master.inc
217 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
218 #
219 # R12. XA ROLLBACK fails because the XID does not exist
220 #
221 [connection master]
222 XA START 'a';
223 INSERT INTO t VALUES (3);
224 XA END 'a';
225 XA PREPARE 'a';
226 include/sync_slave_sql_with_master.inc
227 include/wait_for_xa_prepared_count.inc
228 XA ROLLBACK 'a';
229 include/save_binlog_position.inc
230 [connection master]
231 XA ROLLBACK 'a';
232 include/sync_slave_sql_with_master.inc
233 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
234 #
235 # R13. INSERT fails within XA START ... XA END ; XA PREPARE
236 #
237 [connection slave]
238 INSERT INTO t VALUES (4);
239 include/save_binlog_position.inc
240 [connection master]
241 XA START 'a';
242 INSERT INTO t VALUES (4);
243 XA END 'a';
244 XA PREPARE 'a';
245 include/sync_slave_sql_with_master.inc
246 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
247 [connection master]
248 XA ROLLBACK 'a';
249 DROP TABLE t;
250 include/sync_slave_sql_with_master.inc
251 #
252 # R14. CREATE DATABASE fails because the database exists
253 #
254 [connection slave]
255 CREATE DATABASE db;
256 include/save_binlog_position.inc
257 [connection master]
258 CREATE DATABASE db;
259 include/sync_slave_sql_with_master.inc
260 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
261 #
262 # R15. DROP DATABASE fails because the database does not exist
263 #
264 [connection slave]
265 DROP DATABASE db;
266 include/save_binlog_position.inc
267 [connection master]
268 DROP DATABASE db;
269 include/sync_slave_sql_with_master.inc
270 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
271 #
272 # R16. Incident fails
273 #
274 [connection slave]
275 include/save_binlog_position.inc
276 [connection master]
277 include/save_binlog_position.inc
278 include/save_error_log_position.inc
279 # Adding debug point 'binlog_inject_incident' to @@GLOBAL.debug
280 CREATE TABLE t (a INT);
281 # Removing debug point 'binlog_inject_incident' from @@GLOBAL.debug
282 include/assert_binlog_events.inc [Gtid # Incident]
283 include/assert_error_log.inc [server: 1, pattern: Non-transactional changes were not written to the binlog. An incident event has been written to the binary log which will stop the replicas.]
284 include/sync_slave_sql_with_master.inc
285 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
286 [connection master]
287 DROP TABLE IF EXISTS t;
288 include/sync_slave_sql_with_master.inc
289 #
290 # Clean up
291 #
292 include/rpl_end.inc