Debian Codegraph @

mysql-test/suite/rpl/r/rpl_half_atomic_ddl_no_binlog.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 call mtr.add_suppression("The replica coordinator and worker threads are stopped");
8 call mtr.add_suppression("Replica worker thread has failed to apply an event");
9 call mtr.add_suppression("Error writing relay log configuration");
10 call mtr.add_suppression("Table 't_2' already exists");
11 call mtr.add_suppression("Operating system error number .* in a file operation");
12 call mtr.add_suppression("Cannot open datafile for read-onl");
13 call mtr.add_suppression("The error means the system cannot");
14 [connection master]
15 CREATE DATABASE master_db;
16 USE master_db;
17 CREATE TABLE IF NOT EXISTS t_checks (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, ddl_query TEXT, pre_binlog_check TEXT, post_binlog_check TEXT);;
18 USE test;
19 include/sync_slave_sql_with_master.inc
20 include/stop_slave_sql.inc
21 [connection master]
22 include/gtid_step_reset.inc
23 FLUSH LOGS;
24 CREATE TABLE t_2 (a int auto_increment primary key);
25 include/show_binlog_events.inc
26 Log_name Pos Event_type Server_id End_log_pos Info
27 # # Rotate # # master-bin.000002;pos=POS
28 include/gtid_step_assert.inc [count=1, only_count=0]
29 include/gtid_step_reset.inc
30 FLUSH LOGS;
31 ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added';
32 include/show_binlog_events.inc
33 Log_name Pos Event_type Server_id End_log_pos Info
34 # # Rotate # # master-bin.000002;pos=POS
35 include/gtid_step_assert.inc [count=1, only_count=0]
36 include/gtid_step_reset.inc
37 FLUSH LOGS;
38 ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added';
39 include/show_binlog_events.inc
40 Log_name Pos Event_type Server_id End_log_pos Info
41 # # Rotate # # master-bin.000002;pos=POS
42 include/gtid_step_assert.inc [count=1, only_count=0]
43 include/gtid_step_reset.inc
44 FLUSH LOGS;
45 ALTER TABLE t_2 RENAME t_3;
46 include/show_binlog_events.inc
47 Log_name Pos Event_type Server_id End_log_pos Info
48 # # Rotate # # master-bin.000002;pos=POS
49 include/gtid_step_assert.inc [count=1, only_count=0]
50 include/gtid_step_reset.inc
51 FLUSH LOGS;
52 RENAME TABLE t_3 TO t_2 /* Name restored */;
53 include/show_binlog_events.inc
54 Log_name Pos Event_type Server_id End_log_pos Info
55 # # Rotate # # master-bin.000002;pos=POS
56 include/gtid_step_assert.inc [count=1, only_count=0]
57 include/gtid_step_reset.inc
58 FLUSH LOGS;
59 INSERT INTO t_2 SET a=1,b=1;
60 include/show_binlog_events.inc
61 Log_name Pos Event_type Server_id End_log_pos Info
62 # # Rotate # # master-bin.000002;pos=POS
63 include/gtid_step_assert.inc [count=1, only_count=0]
64 include/gtid_step_reset.inc
65 FLUSH LOGS;
66 TRUNCATE TABLE t_2;
67 include/show_binlog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 # # Rotate # # master-bin.000002;pos=POS
70 include/gtid_step_assert.inc [count=1, only_count=0]
71 include/gtid_step_reset.inc
72 FLUSH LOGS;
73 CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd';
74 include/show_binlog_events.inc
75 Log_name Pos Event_type Server_id End_log_pos Info
76 # # Rotate # # master-bin.000002;pos=POS
77 include/gtid_step_assert.inc [count=1, only_count=0]
78 include/gtid_step_reset.inc
79 FLUSH LOGS;
80 DROP TABLESPACE ts_0;
81 include/show_binlog_events.inc
82 Log_name Pos Event_type Server_id End_log_pos Info
83 # # Rotate # # master-bin.000002;pos=POS
84 include/gtid_step_assert.inc [count=1, only_count=0]
85 include/gtid_step_reset.inc
86 FLUSH LOGS;
87 CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci;
88 include/show_binlog_events.inc
89 Log_name Pos Event_type Server_id End_log_pos Info
90 # # Rotate # # master-bin.000002;pos=POS
91 include/gtid_step_assert.inc [count=1, only_count=0]
92 include/gtid_step_reset.inc
93 FLUSH LOGS;
94 ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci;
95 Warnings:
96 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
97 include/show_binlog_events.inc
98 Log_name Pos Event_type Server_id End_log_pos Info
99 # # Rotate # # master-bin.000002;pos=POS
100 include/gtid_step_assert.inc [count=1, only_count=0]
101 include/gtid_step_reset.inc
102 FLUSH LOGS;
103 DROP DATABASE db_0;
104 include/show_binlog_events.inc
105 Log_name Pos Event_type Server_id End_log_pos Info
106 # # Rotate # # master-bin.000002;pos=POS
107 include/gtid_step_assert.inc [count=1, only_count=0]
108 include/gtid_step_reset.inc
109 FLUSH LOGS;
110 DROP TABLE t_2;
111 include/show_binlog_events.inc
112 Log_name Pos Event_type Server_id End_log_pos Info
113 # # Rotate # # master-bin.000002;pos=POS
114 include/gtid_step_assert.inc [count=1, only_count=0]
115 [connection slave]
116 include/start_slave_io.inc
117 Warnings:
118 Note 3083 Replication thread(s) for channel '' are already runnning.
119 [connection master]
120 include/sync_slave_io_with_master.inc
121 [connection slave]
122 include/stop_slave_io.inc
123 CREATE TABLE t_2 (a int);
124 START SLAVE SQL_THREAD;
125 Warnings:
126 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
127 include/wait_for_slave_sql_error.inc [errno=1050]
128 DROP TABLE t_2;
129 [connection master]
130 Loop: 1 out of 13; current query: 'CREATE TABLE t_2 (a int auto_increment primary key)'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.tables WHERE table_name = 't_2'';
131 [connection slave]
132 *** Query: 'CREATE TABLE t_2 (a int auto_increment primary key)'. Crash right before the query gets committed. ***
133 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
134 include/gtid_step_reset.inc
135 START SLAVE SQL_THREAD;
136 Warnings:
137 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
138 include/rpl_start_server.inc [server_number=2]
139 [connection slave]
140 include/gtid_step_assert.inc [count=1, only_count=1]
141 [connection master]
142 Loop: 2 out of 13; current query: 'ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added''; pre-binlog check: ''; pre-commit check: 'select TABLE_COMMENT LIKE 'Col b copy-added' FROM information_schema.tables where table_name = 't_2'';
143 [connection slave]
144 *** Query: 'ALTER TABLE t_2 ADD COLUMN b INT NOT NULL, ALGORITHM=COPY, COMMENT 'Col b copy-added''. Crash right before the query gets committed. ***
145 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
146 include/gtid_step_reset.inc
147 START SLAVE SQL_THREAD;
148 Warnings:
149 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
150 include/rpl_start_server.inc [server_number=2]
151 [connection slave]
152 include/gtid_step_assert.inc [count=1, only_count=1]
153 [connection master]
154 Loop: 3 out of 13; current query: 'ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added''; pre-binlog check: ''; pre-commit check: 'select TABLE_COMMENT LIKE 'Index on b inplace-added' FROM information_schema.tables where table_name = 't_2'';
155 [connection slave]
156 *** Query: 'ALTER TABLE t_2 ADD INDEX idx(b), ALGORITHM= INPLACE, COMMENT 'Index on b inplace-added''. Crash right before the query gets committed. ***
157 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
158 include/gtid_step_reset.inc
159 START SLAVE SQL_THREAD;
160 Warnings:
161 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
162 include/rpl_start_server.inc [server_number=2]
163 [connection slave]
164 include/gtid_step_assert.inc [count=1, only_count=1]
165 [connection master]
166 Loop: 4 out of 13; current query: 'ALTER TABLE t_2 RENAME t_3'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.tables WHERE table_name = 't_3'';
167 [connection slave]
168 *** Query: 'ALTER TABLE t_2 RENAME t_3'. Crash right before the query gets committed. ***
169 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
170 include/gtid_step_reset.inc
171 START SLAVE SQL_THREAD;
172 Warnings:
173 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
174 include/rpl_start_server.inc [server_number=2]
175 [connection slave]
176 include/gtid_step_assert.inc [count=1, only_count=1]
177 [connection master]
178 Loop: 5 out of 13; current query: 'RENAME TABLE t_3 TO t_2 /* Name restored */'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.tables WHERE table_name = 't_2'';
179 [connection slave]
180 *** Query: 'RENAME TABLE t_3 TO t_2 /* Name restored */'. Crash right before the query gets committed. ***
181 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
182 include/gtid_step_reset.inc
183 START SLAVE SQL_THREAD;
184 Warnings:
185 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
186 include/rpl_start_server.inc [server_number=2]
187 [connection slave]
188 include/gtid_step_assert.inc [count=1, only_count=1]
189 [connection master]
190 Loop: 6 out of 13; current query: 'INSERT INTO t_2 SET a=1,b=1'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM t_2';
191 [connection slave]
192 *** Query: 'INSERT INTO t_2 SET a=1,b=1'. Crash right before the query gets committed. ***
193 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
194 include/gtid_step_reset.inc
195 START SLAVE SQL_THREAD;
196 Warnings:
197 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
198 include/rpl_start_server.inc [server_number=2]
199 [connection slave]
200 include/gtid_step_assert.inc [count=1, only_count=1]
201 [connection master]
202 Loop: 7 out of 13; current query: 'TRUNCATE TABLE t_2'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 0 FROM t_2';
203 [connection slave]
204 *** Query: 'TRUNCATE TABLE t_2'. Crash right before the query gets committed. ***
205 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
206 include/gtid_step_reset.inc
207 START SLAVE SQL_THREAD;
208 Warnings:
209 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
210 include/rpl_start_server.inc [server_number=2]
211 [connection slave]
212 include/gtid_step_assert.inc [count=1, only_count=1]
213 [connection master]
214 Loop: 8 out of 13; current query: 'CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd''; pre-binlog check: ''; pre-commit check: 'SELECT COUNT(*) = 1 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts_0'';
215 [connection slave]
216 *** Query: 'CREATE TABLESPACE ts_0 ADD DATAFILE 'ts_0.ibd''. Crash right before the query gets committed. ***
217 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
218 include/gtid_step_reset.inc
219 START SLAVE SQL_THREAD;
220 Warnings:
221 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
222 include/rpl_start_server.inc [server_number=2]
223 [connection slave]
224 include/gtid_step_assert.inc [count=1, only_count=1]
225 [connection master]
226 Loop: 9 out of 13; current query: 'DROP TABLESPACE ts_0'; pre-binlog check: ''; pre-commit check: 'SELECT COUNT(*) = 0 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts_0'';
227 [connection slave]
228 *** Query: 'DROP TABLESPACE ts_0'. Crash right before the query gets committed. ***
229 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
230 include/gtid_step_reset.inc
231 START SLAVE SQL_THREAD;
232 Warnings:
233 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
234 include/rpl_start_server.inc [server_number=2]
235 [connection slave]
236 include/gtid_step_assert.inc [count=1, only_count=1]
237 [connection master]
238 Loop: 10 out of 13; current query: 'CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.SCHEMATA WHERE schema_name = 'db_0'';
239 [connection slave]
240 *** Query: 'CREATE DATABASE db_0 DEFAULT COLLATE latin1_general_ci'. Crash right before the query gets committed. ***
241 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
242 include/gtid_step_reset.inc
243 START SLAVE SQL_THREAD;
244 Warnings:
245 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
246 include/rpl_start_server.inc [server_number=2]
247 [connection slave]
248 include/gtid_step_assert.inc [count=1, only_count=1]
249 [connection master]
250 Loop: 11 out of 13; current query: 'ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.SCHEMATA WHERE schema_name = 'db_0' and default_collation_name = 'utf8mb3_general_ci'';
251 [connection slave]
252 *** Query: 'ALTER DATABASE db_0 DEFAULT COLLATE utf8mb3_general_ci'. Crash right before the query gets committed. ***
253 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
254 include/gtid_step_reset.inc
255 START SLAVE SQL_THREAD;
256 Warnings:
257 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
258 include/rpl_start_server.inc [server_number=2]
259 [connection slave]
260 include/gtid_step_assert.inc [count=1, only_count=1]
261 [connection master]
262 Loop: 12 out of 13; current query: 'DROP DATABASE db_0'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.SCHEMATA WHERE schema_name = 'db_0'';
263 [connection slave]
264 *** Query: 'DROP DATABASE db_0'. Crash right before the query gets committed. ***
265 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
266 include/gtid_step_reset.inc
267 START SLAVE SQL_THREAD;
268 Warnings:
269 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
270 include/rpl_start_server.inc [server_number=2]
271 [connection slave]
272 include/gtid_step_assert.inc [count=1, only_count=1]
273 [connection master]
274 Loop: 13 out of 13; current query: 'DROP TABLE t_2'; pre-binlog check: ''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.tables WHERE table_name = 't_2'';
275 [connection slave]
276 *** Query: 'DROP TABLE t_2'. Crash right before the query gets committed. ***
277 SET @@GLOBAL.debug="+d,replica_crash_after_commit";
278 include/gtid_step_reset.inc
279 START SLAVE SQL_THREAD;
280 Warnings:
281 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
282 include/rpl_start_server.inc [server_number=2]
283 [connection slave]
284 include/gtid_step_assert.inc [count=1, only_count=1]
285 [connection slave]
286 include/start_slave.inc
287 [connection master]
288 DROP DATABASE master_db;
289 include/sync_slave_sql_with_master.inc
290 include/rpl_end.inc