Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_split_statements_debug.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 CALL mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
7 CALL mtr.add_suppression('Cannot execute statement because it needs to be written to the binary log as multiple statements');
8 CALL mtr.add_suppression('DROP DATABASE failed; some tables may have been dropped but the database directory remains.');
9 CALL mtr.add_suppression("Error dropping database");
10 CALL mtr.add_suppression("Can't drop database '.*'; database doesn't exist");
11 CALL mtr.add_suppression("Replica SQL for channel '': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state. .* Error_code: MY-001756");
12 CALL mtr.add_suppression("Replica SQL for channel '': .* Error_code: MY-001105");
13 ==== Case 2: DROP TABLES ====
14 ==== Case 2D: Failing DROP TABLES for base tables with and without atomic DDL support ====
15 CREATE TABLE base_1_n (a INT) ENGINE = MyISAM;
16 CREATE TABLE base_2_n (a INT) ENGINE = MyISAM;
17 CREATE TABLE base_3_a (a INT) ENGINE = InnoDB;
18 CREATE TABLE base_4_a (pk INT PRIMARY KEY) ENGINE = InnoDB;
19 include/rpl_sync.inc
20 ---- GTID_MODE=AUTOMATIC ----
21 include/gtid_step_reset.inc
22 SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
23 DROP TABLES base_1_n, base_2_n, base_3_a, base_4_a;
24 ERROR HY000: Unknown error
25 SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
26 # In AUTOMATIC mode the above statement should be split into
27 # two statements for each of MyISAM tables.
28 # There should be no statement for dropping base_3_a or
29 # base_4_a as their removal is rolled back.
30 include/gtid_step_assert.inc [count=2., only_count=0]
31 # base_3_a and base_4_a should still be there on master
32 SHOW CREATE TABLE base_3_a;
33 Table Create Table
34 base_3_a CREATE TABLE `base_3_a` (
35 `a` int DEFAULT NULL
36 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
37 SHOW CREATE TABLE base_4_a;
38 Table Create Table
39 base_4_a CREATE TABLE `base_4_a` (
40 `pk` int NOT NULL,
41 PRIMARY KEY (`pk`)
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 include/rpl_sync.inc
44 # base_3_a and base_4_a should still be there on slave
45 SHOW CREATE TABLE base_3_a;
46 Table Create Table
47 base_3_a CREATE TABLE `base_3_a` (
48 `a` int DEFAULT NULL
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
50 SHOW CREATE TABLE base_4_a;
51 Table Create Table
52 base_4_a CREATE TABLE `base_4_a` (
53 `pk` int NOT NULL,
54 PRIMARY KEY (`pk`)
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 CREATE TABLE base_1_n (a INT) ENGINE = MyISAM;
57 CREATE TABLE base_2_n (a INT) ENGINE = MyISAM;
58 include/rpl_sync.inc
59 ---- GTID_NEXT=non-automatic ----
60 include/gtid_step_reset.inc
61 SET GTID_NEXT = '#';
62 SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
63 DROP TABLES base_1_n, base_2_n, base_3_a, base_4_a;
64 ERROR HY000: Unknown error
65 SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
66 SET GTID_NEXT= 'AUTOMATIC';
67 # With GTID assigned the above statement should not be split.
68 include/gtid_step_assert.inc [count=1, only_count=0]
69 # base_3_a and base_4_a should still be there on master
70 SHOW CREATE TABLE base_3_a;
71 Table Create Table
72 base_3_a CREATE TABLE `base_3_a` (
73 `a` int DEFAULT NULL
74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
75 SHOW CREATE TABLE base_4_a;
76 Table Create Table
77 base_4_a CREATE TABLE `base_4_a` (
78 `pk` int NOT NULL,
79 PRIMARY KEY (`pk`)
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
81 include/rpl_sync.inc
82 # base_3_a and base_4_a should still be there on slave
83 SHOW CREATE TABLE base_3_a;
84 Table Create Table
85 base_3_a CREATE TABLE `base_3_a` (
86 `a` int DEFAULT NULL
87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
88 SHOW CREATE TABLE base_4_a;
89 Table Create Table
90 base_4_a CREATE TABLE `base_4_a` (
91 `pk` int NOT NULL,
92 PRIMARY KEY (`pk`)
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
94 ---- Clean up ----
95 DROP TABLE base_4_a, base_3_a;
96 include/rpl_sync.inc
97 ==== Case 3: DROP DATABASE ====
98 ---- Initialize ----
99 # db1, db2, db3: no tables.
100 CREATE DATABASE db1;
101 CREATE DATABASE db2;
102 CREATE DATABASE db3;
103 include/rpl_sync.inc
104 # db4, db5, db6: one table.
105 CREATE DATABASE db4;
106 CREATE DATABASE db5;
107 CREATE DATABASE db6;
108 CREATE TABLE db4.t1 (a INT);
109 CREATE TABLE db5.t1 (a INT);
110 CREATE TABLE db6.t1 (a INT);
111 include/rpl_sync.inc
112 # db7, db8, db9: one MyISAM and one InnoDB table.
113 CREATE DATABASE db7;
114 CREATE DATABASE db8;
115 CREATE DATABASE db9;
116 CREATE TABLE db7.t1 (a INT) ENGINE=InnoDB;
117 CREATE TABLE db8.t1 (a INT) ENGINE=InnoDB;
118 CREATE TABLE db9.t1 (a INT) ENGINE=InnoDB;
119 CREATE TABLE db7.t2 (a INT) ENGINE=MyISAM;
120 CREATE TABLE db8.t2 (a INT) ENGINE=MyISAM;
121 CREATE TABLE db9.t2 (a INT) ENGINE=MyISAM;
122 include/rpl_sync.inc
123 # db10, db11, db12: two MyISAM and one InnoDB table.
124 CREATE DATABASE db10;
125 CREATE DATABASE db11;
126 CREATE DATABASE db12;
127 CREATE TABLE db10.t1 (a INT) ENGINE=MyISAM;
128 CREATE TABLE db11.t1 (a INT) ENGINE=MyISAM;
129 CREATE TABLE db12.t1 (a INT) ENGINE=MyISAM;
130 CREATE TABLE db10.t2 (a INT) ENGINE=MyISAM;
131 CREATE TABLE db11.t2 (a INT) ENGINE=MyISAM;
132 CREATE TABLE db12.t2 (a INT) ENGINE=MyISAM;
133 CREATE TABLE db10.t3 (a INT) ENGINE=InnoDB;
134 CREATE TABLE db11.t3 (a INT) ENGINE=InnoDB;
135 CREATE TABLE db12.t3 (a INT) ENGINE=InnoDB;
136 include/rpl_sync.inc
137 # db13, db14: not a database, but the directory and the entry exist.
138 # db15 is not a database, but the empty directory exists on master.
139 include/rpl_sync.inc
140 # db19, db20: one MyISAM and one InnoDB table (successfull case).
141 CREATE DATABASE db19;
142 CREATE DATABASE db20;
143 CREATE TABLE db19.t1 (a INT) ENGINE=InnoDB;
144 CREATE TABLE db20.t1 (a INT) ENGINE=InnoDB;
145 CREATE TABLE db19.t2 (a INT) ENGINE=MyISAM;
146 CREATE TABLE db20.t2 (a INT) ENGINE=MyISAM;
147 include/rpl_sync.inc
148 ---- DROP DATABASE is split on master; GTID_NEXT=AUTOMATIC ----
149 # db1: no table.
150 include/save_binlog_position.inc
151 SET GTID_NEXT = 'AUTOMATIC';
152 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
153 DROP DATABASE db1;
154 ERROR HY000: Unknown error
155 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
156 include/assert_binlog_events.inc [()]
157 # db4: one InnoDB table.
158 include/save_binlog_position.inc
159 SET GTID_NEXT = 'AUTOMATIC';
160 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
161 DROP DATABASE db4;
162 ERROR HY000: Unknown error
163 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
164 include/assert_binlog_events.inc [()]
165 # db7: one MyISAM and one InnoDB table.
166 include/save_binlog_position.inc
167 SET GTID_NEXT = 'AUTOMATIC';
168 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
169 DROP DATABASE db7;
170 ERROR HY000: Unknown error
171 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
172 include/assert_binlog_events.inc [Gtid # !Q(DROP TABLE.*)]
173 # db10: two MyISAM and one InnoDB table.
174 include/save_binlog_position.inc
175 SET GTID_NEXT = 'AUTOMATIC';
176 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
177 DROP DATABASE db10;
178 ERROR HY000: Unknown error
179 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
180 include/assert_binlog_events.inc [Gtid # !Q(DROP TABLE.*) # Gtid # !Q(DROP TABLE.*)]
181 # db13: not a database, but directory exists.
182 include/save_binlog_position.inc
183 SET GTID_NEXT = 'AUTOMATIC';
184 DROP DATABASE db13;
185 ERROR HY000: Schema 'db13' does not exist, but schema directory './db13/' was found. This must be resolved manually (e.g. by moving the schema directory to another location).
186 include/assert_binlog_events.inc [()]
187 # db16: not a database.
188 include/save_binlog_position.inc
189 SET GTID_NEXT = 'AUTOMATIC';
190 DROP DATABASE db16;
191 ERROR HY000: Can't drop database 'db16'; database doesn't exist
192 include/assert_binlog_events.inc [()]
193 # db19: Successfull DROP DATABASE for one MyISAM and one InnoDB table.
194 include/save_binlog_position.inc
195 SET GTID_NEXT = 'AUTOMATIC';
196 DROP DATABASE db19;
197 include/assert_binlog_events.inc [Gtid # !Q(DROP TABLE.*) # Gtid # !Q(DROP DATABASE.*)]
198 ---- DROP DATABASE is split on master; GTID_NEXT=non-automatic ----
199 # db2: no table.
200 include/save_binlog_position.inc
201 SET GTID_NEXT = '#';
202 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
203 DROP DATABASE db2;
204 ERROR HY000: Unknown error
205 SHOW WARNINGS;
206 Level Code Message
207 Error 1105 Unknown error
208 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
209 include/assert_binlog_events.inc [()]
210 SET GTID_NEXT = 'AUTOMATIC';
211 # db5: one InnoDB table.
212 include/save_binlog_position.inc
213 SET GTID_NEXT = '#';
214 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
215 DROP DATABASE db5;
216 ERROR HY000: Unknown error
217 SHOW WARNINGS;
218 Level Code Message
219 Error 1105 Unknown error
220 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
221 include/assert_binlog_events.inc [()]
222 SET GTID_NEXT = 'AUTOMATIC';
223 # db8: one MyISAM and one InnoDB table.
224 include/save_binlog_position.inc
225 SET GTID_NEXT = '#';
226 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
227 DROP DATABASE db8;
228 ERROR HY000: Unknown error
229 SHOW WARNINGS;
230 Level Code Message
231 Error 1105 Unknown error
232 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
233 include/assert_binlog_events.inc [()]
234 SET GTID_NEXT = 'AUTOMATIC';
235 # db11: two MyISAM and one InnoDB tables.
236 include/save_binlog_position.inc
237 SET GTID_NEXT = '#';
238 SET DEBUG= '+d, rm_db_fail_after_dropping_tables';
239 DROP DATABASE db11;
240 ERROR HY000: Unknown error
241 SHOW WARNINGS;
242 Level Code Message
243 Error 1105 Unknown error
244 SET DEBUG= '-d, rm_db_fail_after_dropping_tables';
245 include/assert_binlog_events.inc [()]
246 SET GTID_NEXT = 'AUTOMATIC';
247 # db14: not a database, but directory exists.
248 include/save_binlog_position.inc
249 SET GTID_NEXT = '#';
250 DROP DATABASE db14;
251 ERROR HY000: Schema 'db14' does not exist, but schema directory './db14/' was found. This must be resolved manually (e.g. by moving the schema directory to another location).
252 include/assert_binlog_events.inc [()]
253 SET GTID_NEXT = 'AUTOMATIC';
254 # db17: not a database.
255 include/save_binlog_position.inc
256 SET GTID_NEXT = '#';
257 DROP DATABASE db17;
258 ERROR HY000: Can't drop database 'db17'; database doesn't exist
259 include/assert_binlog_events.inc [()]
260 SET GTID_NEXT = 'AUTOMATIC';
261 # db20: Successfull DROP DATABASE for one MyISAM and one InnoDB table.
262 # No splitting if GTID is assigned.
263 include/save_binlog_position.inc
264 SET GTID_NEXT = '#';
265 DROP DATABASE db20;
266 include/assert_binlog_events.inc [Gtid # !Q(DROP DATABASE.*)]
267 SET GTID_NEXT = 'AUTOMATIC';
268 include/rpl_sync.inc
269 ---- DROP DATABASE is split on slave ----
270 SET GTID_NEXT = 'AUTOMATIC';
271 SET GLOBAL DEBUG= '+d, rm_db_fail_after_dropping_tables';
272 [connection master]
273 # db3: no table.
274 DROP DATABASE db3;
275 include/sync_slave_io_with_master.inc
276 include/wait_for_slave_sql_error.inc [errno=1105]
277 include/include/rpl_skip_to_end_of_relay_log.inc
278 [connection master]
279 # db6: one InnoDB table.
280 DROP DATABASE db6;
281 include/sync_slave_io_with_master.inc
282 include/wait_for_slave_sql_error.inc [errno=1105]
283 include/include/rpl_skip_to_end_of_relay_log.inc
284 [connection master]
285 # db9: one MyISAM and one InnoDB table.
286 DROP DATABASE db9;
287 include/sync_slave_io_with_master.inc
288 include/wait_for_slave_sql_error.inc [errno=1105]
289 include/include/rpl_skip_to_end_of_relay_log.inc
290 [connection master]
291 # db12: two MyISAM and one InnoDB table.
292 DROP DATABASE db12;
293 include/sync_slave_io_with_master.inc
294 include/wait_for_slave_sql_error.inc [errno=1105]
295 include/include/rpl_skip_to_end_of_relay_log.inc
296 SET GLOBAL DEBUG= '-d, rm_db_fail_after_dropping_tables';
297 [connection master]
298 # db15: not a database, but an empty directory exists.
299 DROP DATABASE db15;
300 ERROR HY000: Schema 'db15' does not exist, but schema directory './db15/' was found. This must be resolved manually (e.g. by moving the schema directory to another location).
301 ---- Clean up ----
302 DROP DATABASE db1;
303 DROP DATABASE db2;
304 DROP DATABASE IF EXISTS db3;
305 Warnings:
306 Note 1008 Can't drop database 'db3'; database doesn't exist
307 DROP DATABASE db4;
308 DROP DATABASE db5;
309 DROP DATABASE IF EXISTS db6;
310 Warnings:
311 Note 1008 Can't drop database 'db6'; database doesn't exist
312 DROP DATABASE db7;
313 DROP DATABASE db8;
314 DROP DATABASE IF EXISTS db9;
315 Warnings:
316 Note 1008 Can't drop database 'db9'; database doesn't exist
317 DROP DATABASE db10;
318 DROP DATABASE db11;
319 DROP DATABASE IF EXISTS db12;
320 Warnings:
321 Note 1008 Can't drop database 'db12'; database doesn't exist
322 include/rpl_sync.inc
323 include/rpl_end.inc