Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 # The embedded server tests do not support restarting.
3 --source include/not_embedded.inc
4 --source include/have_debug.inc
5 --source include/have_debug_sync.inc
6
7 FLUSH TABLES;
8
9 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
10 let MYSQLD_DATADIR=`select @@datadir`;
11
12 --echo #
13 --echo # MDEV-11369: Instant ADD COLUMN for InnoDB
14 --echo #
15
16 CREATE TABLE t1(id INT PRIMARY KEY, c2 INT UNIQUE)
17 ENGINE=InnoDB STATS_PERSISTENT=0 ROW_FORMAT=REDUNDANT;
18 CREATE TABLE t2 LIKE t1;
19 INSERT INTO t1 VALUES(0,2);
20 INSERT INTO t2 VALUES(2,1);
21 ALTER TABLE t2 ADD COLUMN (c3 TEXT NOT NULL DEFAULT 'De finibus bonorum');
22 BEGIN;
23 INSERT INTO t2 VALUES(3,4,'accusantium doloremque laudantium');
24
25 connect ddl, localhost, root;
26 SET DEBUG_SYNC='innodb_alter_inplace_before_commit SIGNAL ddl WAIT_FOR ever';
27 --send
28 ALTER TABLE t1 ADD COLUMN (c3 TEXT NOT NULL DEFAULT ' et malorum');
29
30 connection default;
31 SET DEBUG_SYNC='now WAIT_FOR ddl';
32 SET GLOBAL innodb_flush_log_at_trx_commit=1;
33 COMMIT;
34
35 --source include/kill_mysqld.inc
36 disconnect ddl;
37 --source include/start_mysqld.inc
38
39 SELECT * FROM t1;
40 SELECT * FROM t2;
41 BEGIN;
42 DELETE FROM t1;
43 ROLLBACK;
44 --source include/wait_all_purged.inc
45
46 INSERT INTO t2 VALUES
47 (16,1551,'Omnium enim rerum'),(128,1571,' principia parva sunt');
48
49 BEGIN;
50 UPDATE t1 SET c2=c2+1;
51
52 connect ddl, localhost, root;
53 SET DEBUG_SYNC='innodb_alter_inplace_before_commit SIGNAL ddl WAIT_FOR ever';
54 --send
55 ALTER TABLE t2 DROP COLUMN c3, ADD COLUMN c5 TEXT DEFAULT 'naturam abhorrere';
56
57 connection default;
58 SET DEBUG_SYNC='now WAIT_FOR ddl';
59 SET GLOBAL innodb_flush_log_at_trx_commit=1;
60 COMMIT;
61
62 --source include/kill_mysqld.inc
63 disconnect ddl;
64 --source include/start_mysqld.inc
65
66 SELECT * FROM t1;
67 SELECT * FROM t2;
68 BEGIN;
69 INSERT INTO t1 SET id=1;
70 DELETE FROM t2;
71 ROLLBACK;
72 --source include/wait_all_purged.inc
73
74 INSERT INTO t2 VALUES (64,42,'De finibus bonorum'), (347,33101,' et malorum');
75 BEGIN;
76 DELETE FROM t1;
77
78 connect ddl, localhost, root;
79 ALTER TABLE t2 DROP COLUMN c3;
80 SET DEBUG_SYNC='innodb_alter_inplace_before_commit SIGNAL ddl WAIT_FOR ever';
81 --send
82 ALTER TABLE t2 ADD COLUMN (c4 TEXT NOT NULL DEFAULT ' et malorum');
83
84 connection default;
85 SET DEBUG_SYNC='now WAIT_FOR ddl';
86 SET GLOBAL innodb_flush_log_at_trx_commit=1;
87 COMMIT;
88
89 --source include/kill_mysqld.inc
90 disconnect ddl;
91 --source include/start_mysqld.inc
92
93 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
94 let SEARCH_PATTERN= \[Note\] InnoDB: Rolled back recovered transaction ;
95 -- source include/search_pattern_in_file.inc
96
97 SELECT * FROM t1;
98 SELECT * FROM t2;
99 BEGIN;
100 INSERT INTO t1 SET id=1;
101 DELETE FROM t2;
102 ROLLBACK;
103 --source include/wait_all_purged.inc
104
105 FLUSH TABLE t1,t2 FOR EXPORT;
106
107 # At this point, t1 is empty and t2 contains a 'default row'.
108
109 # The following is based on innodb.table_flags and innodb.dml_purge:
110 --perl
111 use strict;
112 my $ps= $ENV{INNODB_PAGE_SIZE};
113 foreach my $table ('t1','t2') {
114 my $file= "$ENV{MYSQLD_DATADIR}/test/$table.ibd";
115 open(FILE, "<", $file) || die "Unable to open $file\n";
116 my $page;
117 sysseek(FILE, 3*$ps, 0) || die "Unable to seek $file";
118 die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
119 print "$table clustered index root page";
120 print "(type ", unpack("n", substr($page,24,2)), "):\n";
121 print "N_RECS=", unpack("n", substr($page,38+16,2));
122 print "; LEVEL=", unpack("n", substr($page,38+26,2)), "\n";
123 my @fields=("id","DB_TRX_ID","DB_ROLL_PTR", "c2","c3","c4");
124 for (my $offset= 0x65; $offset;
125 $offset= unpack("n", substr($page,$offset-2,2)))
126 {
127 print "header=0x", unpack("H*",substr($page,$offset-6,6)), " (";
128 my $n_fields= unpack("n", substr($page,$offset-4,2)) >> 1 & 0x3ff;
129 my $start= 0;
130 my $name;
131 if (unpack("C", substr($page,$offset-3,1)) & 1) {
132 for (my $i= 0; $i < $n_fields; $i++) {
133 my $end= unpack("C", substr($page, $offset-7-$i, 1));
134 print ",\n " if $i;
135 print "$fields[$i]=";
136 if ($end & 0x80) {
137 print "NULL(", ($end & 0x7f) - $start, " bytes)"
138 } else {
139 print "0x", unpack("H*", substr($page,$offset+$start,$end-$start))
140 }
141 $start= $end & 0x7f;
142 }
143 } else {
144 for (my $i= 0; $i < $n_fields; $i++) {
145 my $end= unpack("n", substr($page, $offset-8-2*$i, 2));
146 print ",\n " if $i;
147 if ($i > 2 && !(~unpack("C",substr($page,$offset-6,1)) & 0x30)) {
148 if ($i == 3) {
149 print "BLOB=";
150 $start += 8; # skip the space_id,page_number
151 } else {
152 print "$fields[$i - 1]=";
153 }
154 } else {
155 print "$fields[$i]=";
156 }
157 if ($end & 0x8000) {
158 print "NULL(", ($end & 0x7fff) - $start, " bytes)"
159 } else {
160 print "0x", unpack("H*", substr($page,$offset+$start,($end-$start) & 0x3fff))
161 }
162 $start= $end & 0x3fff;
163 }
164 }
165 print ")\n";
166 }
167 close(FILE) || die "Unable to close $file\n";
168 }
169 EOF
170
171 UNLOCK TABLES;
172
173 DELETE FROM t2;
174 --source include/wait_all_purged.inc
175
176 --echo #
177 --echo # MDEV-24323 Crash on recovery after kill during instant ADD COLUMN
178 --echo #
179 BEGIN;
180 INSERT INTO t1 VALUES(0,0);
181
182 connect ddl, localhost, root;
183 CREATE TABLE t3(id INT PRIMARY KEY, c2 INT, v2 INT AS(c2) VIRTUAL, UNIQUE(v2))
184 ENGINE=InnoDB;
185 INSERT INTO t3 SET id=1,c2=1;
186
187 SET DEBUG_SYNC='innodb_alter_inplace_before_commit SIGNAL ddl WAIT_FOR ever';
188 --send
189 ALTER TABLE t3 ADD COLUMN c3 TEXT NOT NULL DEFAULT 'sic transit gloria mundi';
190
191 connection default;
192 SET DEBUG_SYNC='now WAIT_FOR ddl';
193 SET GLOBAL innodb_flush_log_at_trx_commit=1;
194 COMMIT;
195
196 --source include/kill_mysqld.inc
197 disconnect ddl;
198 --source include/start_mysqld.inc
199
200 SHOW CREATE TABLE t1;
201 SHOW CREATE TABLE t2;
202 SHOW CREATE TABLE t3;
203 DROP TABLE t2,t3;
204
205 --echo #
206 --echo # MDEV-29440 InnoDB instant ALTER TABLE recovery wrongly uses
207 --echo # READ COMMITTED isolation level instead of READ UNCOMMITTED
208 --echo #
209 CREATE TABLE t2(a INT UNSIGNED PRIMARY KEY) ENGINE=InnoDB;
210 INSERT INTO t2 VALUES (1),(2),(3),(4),(5),(6);
211
212 BEGIN;
213 DELETE FROM t1;
214
215 connect ddl, localhost, root;
216 SET DEBUG_SYNC='innodb_alter_inplace_before_commit SIGNAL ddl WAIT_FOR ever';
217 --send
218 ALTER TABLE t2 ADD COLUMN b TINYINT UNSIGNED NOT NULL DEFAULT 42 FIRST;
219
220 connection default;
221 SET DEBUG_SYNC='now WAIT_FOR ddl';
222 SET GLOBAL innodb_flush_log_at_trx_commit=1;
223 COMMIT;
224
225 --source include/kill_mysqld.inc
226 disconnect ddl;
227 --source include/start_mysqld.inc
228
229 CHECK TABLE t2;
230 DROP TABLE t1,t2;
231
232 --list_files $MYSQLD_DATADIR/test