| 1 |
--source include/innodb_page_size.inc |
| 2 |
--source include/not_embedded.inc |
| 3 |
|
| 4 |
let INNODB_PAGE_SIZE=`select @@innodb_page_size`; |
| 5 |
let MYSQLD_DATADIR=`select @@datadir`; |
| 6 |
let MYSQLD_IS_DEBUG=`select version() like '%debug%'`; |
| 7 |
--source include/no_checkpoint_start.inc |
| 8 |
SET GLOBAL innodb_file_per_table=0; |
| 9 |
CREATE TABLE t(a INT)ENGINE=InnoDB; |
| 10 |
let INNODB_ROOT_PAGE= `SELECT page_no FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE name='GEN_CLUST_INDEX'`; |
| 11 |
SET GLOBAL innodb_file_per_table=1; |
| 12 |
|
| 13 |
CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB; |
| 14 |
CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB; |
| 15 |
CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB; |
| 16 |
|
| 17 |
let $drop_tables= DROP TABLE t,ibd4,ibd4f,ibd5; |
| 18 |
--let CLEANUP_IF_CHECKPOINT= $drop_tables; |
| 19 |
--source ../include/no_checkpoint_end.inc |
| 20 |
|
| 21 |
perl; |
| 22 |
use Fcntl 'SEEK_CUR', 'SEEK_END'; |
| 23 |
|
| 24 |
my $page_size = $ENV{'INNODB_PAGE_SIZE'}; |
| 25 |
my $restart; |
| 26 |
open(FILE, "+<", "$ENV{'MYSQLD_DATADIR'}ibdata1") or die; |
| 27 |
if ($ENV{'MYSQLD_IS_DEBUG'}) |
| 28 |
{ |
| 29 |
# It is impractical to ensure that CREATE TABLE t will extend ibdata1. |
| 30 |
# We rely on innodb_system_tablespace_extend_debug=1 |
| 31 |
# to recover from this fault injection if no size change was redo-logged. |
| 32 |
my $root = $ENV{'INNODB_ROOT_PAGE'}; |
| 33 |
my $size = sysseek(FILE, 0, SEEK_END) / $page_size; |
| 34 |
seek(FILE, $page_size * ($root + 1), SEEK_SET) or die; |
| 35 |
my $empty_tail= 1; |
| 36 |
while(<FILE>) { unless (/\0*/gso) { $empty_tail= 0; last } } |
| 37 |
if ($empty_tail) |
| 38 |
{ |
| 39 |
$restart = "--innodb-data-file-size-debug=$size"; |
| 40 |
truncate(FILE, $page_size * $root); |
| 41 |
} |
| 42 |
} |
| 43 |
# Clear the doublewrite buffer entries for our tables. |
| 44 |
sysseek(FILE, 6 * $page_size - 190, 0)||die "Unable to seek ibdata1\n"; |
| 45 |
sysread(FILE, $_, 12) == 12||die "Unable to read TRX_SYS\n"; |
| 46 |
my($magic,$d1,$d2)=unpack "NNN", $_; |
| 47 |
die "magic=$magic, $d1, $d2\n" unless $magic == 536853855 && $d2 >= $d1 + 64; |
| 48 |
sysseek(FILE, $d1 * $page_size, 0)||die "Unable to seek ibdata1\n"; |
| 49 |
# Find the pages in the doublewrite buffer |
| 50 |
for (my $d = $d1; $d < $d2 + 64; $d++) { |
| 51 |
sysread(FILE, $_, $page_size)==$page_size||die "Cannot read doublewrite\n"; |
| 52 |
my($space_id,$offset)=unpack "x[4]Nx[26]N",$_; |
| 53 |
next unless $space_id && $offset > 3; |
| 54 |
sysseek(FILE, $d * $page_size, 0)||die "Unable to seek ibdata1\n"; |
| 55 |
syswrite(FILE, chr(0) x $page_size)==$page_size||die; |
| 56 |
} |
| 57 |
close FILE; |
| 58 |
open(FILE, ">$ENV{MYSQLTEST_VARDIR}/log/start_mysqld.txt") || die; |
| 59 |
print FILE "--let \$restart_parameters=$restart\n" if $restart; |
| 60 |
print FILE "--let \$restart_noprint=2\n"; |
| 61 |
print FILE "--source include/start_mysqld.inc\n"; |
| 62 |
close FILE; |
| 63 |
open(FILE, "+<", "$ENV{'MYSQLD_DATADIR'}test/ibd4.ibd") or die; |
| 64 |
truncate(FILE, $page_size * 4); |
| 65 |
close FILE; |
| 66 |
open(FILE, "+<", "$ENV{'MYSQLD_DATADIR'}test/ibd4f.ibd") or die; |
| 67 |
truncate(FILE, $page_size * 4 + 1234); |
| 68 |
# Work around MDEV-12699 and ensure that the truncated page is all-zero. |
| 69 |
sysseek(FILE, $page_size * 4, 0); |
| 70 |
syswrite(FILE, chr(0) x 1234); |
| 71 |
close FILE; |
| 72 |
open(FILE, "+<", "$ENV{'MYSQLD_DATADIR'}test/ibd5.ibd") or die; |
| 73 |
truncate(FILE, $page_size * 5); |
| 74 |
close FILE; |
| 75 |
EOF |
| 76 |
|
| 77 |
--source $MYSQLTEST_VARDIR/log/start_mysqld.txt |
| 78 |
--remove_file $MYSQLTEST_VARDIR/log/start_mysqld.txt |
| 79 |
|
| 80 |
eval $drop_tables; |