Debian Codegraph @

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

raw
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;