Debian Codegraph @

mysql-test/suite/innodb/t/alter_crash.test

raw
1 # Crash-safe InnoDB ALTER operations
2
3 --source include/not_valgrind.inc
4 --source include/not_embedded.inc
5 --source include/have_innodb.inc
6 --source include/have_debug.inc
7 --source include/have_debug_sync.inc
8 --source include/not_crashrep.inc
9
10 --disable_query_log
11 call mtr.add_suppression('InnoDB: Flagged corruption of `c[23]`');
12 call mtr.add_suppression('InnoDB: Index `c[23]` .*is corrupted');
13 --enable_query_log
14
15 --echo #
16 --echo # Bug#20015132 ALTER TABLE FAILS TO CHECK IF TABLE IS CORRUPTED
17 --echo #
18
19 CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CHAR(1), c3 INT UNSIGNED) ENGINE=InnoDB;
20 SET @saved_debug_dbug = @@SESSION.debug_dbug;
21 SET DEBUG_DBUG='+d,create_index_metadata_fail';
22 --error ER_RECORD_FILE_FULL
23 ALTER TABLE t1 ADD INDEX (c2), ADD INDEX (c3);
24
25 SET DEBUG_DBUG='+d,ib_create_table_fail_too_many_trx';
26 --error ER_TOO_MANY_CONCURRENT_TRXS
27 ALTER TABLE t1 ADD INDEX (c2), ADD INDEX (c3);
28
29 SET DEBUG_DBUG=@saved_debug_dbug;
30 ALTER TABLE t1 ADD INDEX (c2), ADD INDEX (c3);
31 # Flag the secondary indexes corrupted.
32 SET DEBUG_DBUG='+d,dict_set_index_corrupted';
33 CHECK TABLE t1;
34
35 # Ensure that the corruption is permanent.
36 --source include/restart_mysqld.inc
37 CHECK TABLE t1;
38 ALTER TABLE t1 DROP INDEX c2;
39 CHECK TABLE t1;
40 # We refuse an ALTER TABLE that would modify the InnoDB data dictionary
41 # while leaving some of the table corrupted.
42 --error ER_INDEX_CORRUPT
43 ALTER TABLE t1 ADD INDEX (c2,c3);
44 # This will rebuild the table, uncorrupting all secondary indexes.
45 ALTER TABLE t1 CHANGE c3 c3 INT NOT NULL;
46 CHECK TABLE t1;
47 ALTER TABLE t1 ADD INDEX (c2,c3);
48 DROP TABLE t1;
49
50 let $MYSQLD_DATADIR= `select @@datadir`;
51 let datadir= `select @@datadir`;
52
53 # These are from include/shutdown_mysqld.inc and allow to call start_mysqld.inc
54 --let $_expect_file_name= `select regexp_replace(@@tmpdir, '^.*/','')`
55 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/$_expect_file_name.expect
56
57 --echo #
58 --echo # Bug #14669848 CRASH DURING ALTER MAKES ORIGINAL TABLE INACCESSIBLE
59 --echo #
60 --echo # -- Scenario 1:
61 --echo # Crash the server in ha_innobase::commit_inplace_alter_table()
62 --echo # just after committing the dictionary changes.
63
64 CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=innodb;
65 INSERT INTO t1 VALUES (1,2),(3,4);
66 SET DEBUG_DBUG='+d,innodb_alter_commit_crash_after_commit';
67
68 let $orig_table_id = `SELECT table_id
69 FROM information_schema.innodb_sys_tables
70 WHERE name = 'test/t1'`;
71
72 # Write file to make mysql-test-run.pl expect crash
73 --write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
74
75 --error 2013
76 ALTER TABLE t1 ADD PRIMARY KEY (f2, f1);
77
78 --echo # Restart mysqld after the crash and reconnect.
79 --source include/start_mysqld.inc
80
81 --replace_result $orig_table_id ID
82 eval SELECT * FROM information_schema.innodb_sys_tables
83 WHERE table_id = $orig_table_id;
84
85 --echo # Files in datadir after manual recovery.
86 --list_files $MYSQLD_DATADIR/test
87
88 SHOW TABLES;
89 SHOW CREATE TABLE t1;
90 INSERT INTO t1 VALUES (5,6),(7,8);
91 SELECT * FROM t1;
92 DROP TABLE t1;
93
94 CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=InnoDB;
95 ALTER TABLE t1 ADD PRIMARY KEY (f2, f1);
96 DROP TABLE t1;
97
98 --echo # -- Scenario 2:
99 --echo # Crash the server in ha_innobase::commit_inplace_alter_table()
100 --echo # just before committing the dictionary changes, but after
101 --echo # writing the MLOG_FILE_RENAME records. As the mini-transaction
102 --echo # is not committed, the renames will not be replayed.
103
104 CREATE TABLE t2 (f1 int not null, f2 int not null) ENGINE=InnoDB;
105 INSERT INTO t2 VALUES (1,2),(3,4);
106 SET DEBUG_DBUG='+d,innodb_alter_commit_crash_before_commit';
107
108 let $orig_table_id = `SELECT table_id
109 FROM information_schema.innodb_sys_tables
110 WHERE name = 'test/t2'`;
111
112 # Write file to make mysql-test-run.pl expect crash
113 --write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
114
115 --error 2013
116 ALTER TABLE t2 ADD PRIMARY KEY (f2, f1);
117
118 --echo # Startup the server after the crash
119 --source include/start_mysqld.inc
120
121 SELECT * FROM information_schema.innodb_sys_tables
122 WHERE name LIKE 'test/#sql-%';
123
124 SHOW TABLES;
125 INSERT INTO t2 VALUES (5,6),(7,8);
126 SELECT * from t2;
127 SHOW CREATE TABLE t2;
128 DROP TABLE t2;
129
130 CREATE TABLE t2 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=InnoDB;
131 ALTER TABLE t2 ADD PRIMARY KEY (f2, f1);
132 DROP TABLE t2;
133 --list_files $MYSQLD_DATADIR/test
134
135 --echo # -------------------------
136 --echo # End of Testing Scenario 2
137 --echo # -------------------------
138
139 --echo #
140 --echo # Bug#19330255 WL#7142 - CRASH DURING ALTER TABLE LEADS TO
141 --echo # DATA DICTIONARY INCONSISTENCY
142 --echo #
143
144 CREATE TABLE t1(a int PRIMARY KEY, b varchar(255), c int NOT NULL)
145 ENGINE=InnoDB;
146 INSERT INTO t1 SET a=1,c=2;
147 SET DEBUG_DBUG='+d,innodb_alter_commit_crash_after_commit';
148
149 let $orig_table_id = `select table_id from
150 information_schema.innodb_sys_tables where name = 'test/t1'`;
151
152 # Write file to make mysql-test-run.pl expect crash
153 --write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
154 #
155 --error 2013
156 ALTER TABLE t1 ADD INDEX (b), CHANGE c d int, ALGORITHM=INPLACE;
157
158 --echo # Restart mysqld after the crash and reconnect.
159 --source include/start_mysqld.inc
160
161 --replace_result $orig_table_id ID
162 eval SELECT * FROM information_schema.innodb_sys_tables
163 WHERE table_id = $orig_table_id;
164
165 --list_files $MYSQLD_DATADIR/test
166
167 SHOW TABLES;
168 SHOW CREATE TABLE t1;
169 UPDATE t1 SET d=NULL;
170 SELECT * FROM t1;
171 DROP TABLE t1;
172
173 --echo #
174 --echo # MDEV-22637 Rollback of insert fails when column reorder happens
175 --echo #
176 SET @@SQL_MODE = REPLACE(@@SQL_MODE, 'STRICT_TRANS_TABLES', '');
177 SET @@SQL_MODE = REPLACE(@@SQL_MODE, 'STRICT_ALL_TABLES', '');
178 CREATE TABLE t1(f1 INT NOT NULL, f2 CHAR(100),
179 f3 CHAR(100), f4 CHAR(100))ENGINE=InnoDB;
180 INSERT INTO t1 VALUES(1, "This is column2", "This is column3",
181 "This is column4");
182 set DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL scanned WAIT_FOR insert_done';
183 --send ALTER TABLE t1 ADD COLUMN f6 int after f3, add primary key(f6, f4(3), f3(3))
184 connect(con1,localhost,root,,);
185 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
186 BEGIN;
187 INSERT INTO t1(f1, f2) VALUES(2, "This is column2 value");
188 ROLLBACK;
189 set DEBUG_SYNC = 'now SIGNAL insert_done';
190
191 connection default;
192 reap;
193 SHOW CREATE TABLE t1;
194 SELECT COUNT(*) FROM t1;
195 disconnect con1;
196 DROP TABLE t1;
197 SET DEBUG_SYNC = 'RESET';
198 SET SQL_MODE=DEFAULT;
199
200 --echo #
201 --echo # MDEV-26936 Recovery crash on rolling back DELETE FROM SYS_INDEXES
202 --echo #
203
204 CREATE TABLE t1(a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
205 INSERT INTO t1 VALUES(1,1);
206
207 connect ddl, localhost, root;
208 SET DEBUG_SYNC = 'row_merge_after_scan SIGNAL scanned WAIT_FOR commit';
209 SET DEBUG_SYNC = 'before_commit_rollback_inplace SIGNAL c WAIT_FOR ever';
210 send ALTER TABLE t1 ADD UNIQUE INDEX(b), ALGORITHM=INPLACE;
211
212 connection default;
213 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
214 BEGIN;
215 INSERT INTO t1 VALUES(2,1);
216 COMMIT;
217 SET DEBUG_SYNC = 'now SIGNAL commit';
218 SET DEBUG_SYNC = 'now WAIT_FOR c';
219 # Make all pending changes durable for recovery.
220 SET GLOBAL innodb_fil_make_page_dirty_debug=0;
221
222 --source include/kill_mysqld.inc
223 disconnect ddl;
224 --source include/start_mysqld.inc
225
226 CHECK TABLE t1;
227 SHOW CREATE TABLE t1;
228 SELECT * FROM t1;
229
230 connect ddl, localhost, root;
231 SET DEBUG_SYNC = 'fil_ibd_create_logged SIGNAL stuck WAIT_FOR ever';
232 send ALTER TABLE t1 FORCE;
233 connection default;
234 SET DEBUG_SYNC = 'now WAIT_FOR stuck';
235
236 --source include/kill_mysqld.inc
237 disconnect ddl;
238 --source include/start_mysqld.inc
239
240 CHECK TABLE t1;
241 SHOW CREATE TABLE t1;
242 SELECT * FROM t1;
243 DROP TABLE t1;
244
245 --echo #
246 --echo # MDEV-38079 Crash recovery fails after ALTER TABLE…PAGE_COMPRESSED=1
247 --echo #
248 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
249 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
250 ALTER TABLE t1 PAGE_COMPRESSED=1, ALGORITHM=INSTANT;
251 DROP TABLE t1;
252
253 --echo #
254 --echo # MDEV-38928 Assertion undo_no <= 1 in reset_and_truncate_undo
255 --echo # during ALTER IGNORE on temporary table
256 --echo #
257 CREATE TEMPORARY TABLE t1 (f1 INT) ENGINE=INNODB;
258 INSERT INTO t1 (f1) VALUES (0),(0);
259 ALTER IGNORE TABLE t1 FORCE;
260 DROP TABLE t1;
261
262 --echo #
263 --echo # MDEV-38951 Assertion `0' upon ALTER IGNORE handling duplicate keys
264 --echo #
265 CREATE TABLE t1(f1 INT)ENGINE=InnoDB;
266 INSERT INTO t1 VALUES(1), (1);
267 ALTER IGNORE TABLE t1 ADD UNIQUE(f1);
268 CHECK TABLE t1 EXTENDED;
269 DROP TABLE t1;
270
271 --echo #
272 --echo # MDEV-38993 Assertion `trx->undo_no == 1' fails upon ALTER IGNORE
273 --echo #
274 CREATE TABLE t (a INT) ENGINE=InnoDB;
275 INSERT INTO t VALUES (1),(2),(1),(2);
276 ALTER IGNORE TABLE t ADD UNIQUE(a);
277 DROP TABLE t;