Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/big_test.inc
3 --source include/not_embedded.inc
4 call mtr.add_suppression("InnoDB: The change buffer is corrupted");
5 call mtr.add_suppression("InnoDB: Tablespace size stored in header is 768 pages, but the sum of data file sizes is 384 pages");
6 call mtr.add_suppression("InnoDB: adjusting FSP_SPACE_FLAGS of file");
7 --source include/shutdown_mysqld.inc
8 let bugdir= $MYSQLTEST_VARDIR/tmp/log_upgrade;
9 --mkdir $bugdir
10 --let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err
11 --let $dirs= --innodb-data-home-dir=$bugdir --innodb-log-group-home-dir=$bugdir --innodb-undo-directory=$bugdir
12
13 # Test case similar to log_upgrade.test
14 perl;
15 do "$ENV{MTR_SUITE_DIR}/../innodb/include/crc32.pl";
16 my $polynomial = 0x82f63b78; # CRC-32C
17
18 die unless open OUT, ">", "$ENV{bugdir}/ibdata1";
19 binmode OUT;
20
21 my $head = pack("Nx[18]", 0);
22 # Add FSP_SPACE_FLAGS as 49152 (10.1.0...10.1.20), page_size = 32k
23 my $body = pack("x[8]Nx[4]Nx[2]Nx[32696]", 768, 49152, 97937874);
24 my $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
25 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
26
27 # Dummy change buffer header page (page 3).
28 die unless seek(OUT, 3 * 32768, 0);
29 ## FIL_PAGE_OFFSET, FIL_PAGE_PREV, FIL_PAGE_NEXT, FIL_PAGE_TYPE
30 my $head = pack("NNNx[8]n", 3, 0xffffffff, 0xffffffff, 6);
31 my $body = pack("x[62]nnx[32656]", 2, 50);
32 my $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
33 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
34
35 # Dummy change buffer root page (page 4).
36 ## FIL_PAGE_OFFSET, FIL_PAGE_PREV, FIL_PAGE_NEXT
37 my $head = pack("NNNx[10]", 4, 0xffffffff, 0xffffffff);
38 my $body = chr(0) x 32722;
39 my $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
40 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
41
42
43 # Dictionary header page (page 7).
44 die unless seek(OUT, 7 * 32768, 0);
45 $head = pack("Nx[18]", 7);
46 $body = pack("x[32]Nx[8]Nx[32674]", 8, 9);
47 $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
48 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
49
50 # Empty SYS_TABLES page (page 8).
51 $head = pack("NNNx[8]n", 8, ~0, ~0, 17855);
52 $body = pack("nnx[31]Cx[20]", 2, 124, 1);
53 $body .= pack("nxnn", 0x801, 3, 116) . "infimum";
54 $body .= pack("xnxnxx", 0x901, 0x803) . "supremum";
55 $body .= pack("x[32632]nn", 116, 101);
56 $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
57 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
58
59 # Empty SYS_INDEXES page (page 9).
60 $head = pack("NNNx[8]n", 9, ~0, ~0, 17855);
61 $body = pack("nnx[31]Cx[20]", 2, 124, 3);
62 $body .= pack("nxnn", 0x801, 3, 116) . "infimum";
63 $body .= pack("xnxnxx", 0x901, 0x803) . "supremum";
64 $body .= pack("x[32632]nn", 116, 101);
65 $ck = mycrc32($head, 0, $polynomial) ^ mycrc32($body, 0, $polynomial);
66 print OUT pack("N",$ck).$head.pack("x[12]").$body.pack("Nx[4]",$ck);
67
68 die unless seek(OUT, 768 * 16384 - 1, 0);
69 print OUT chr(0);
70 close OUT or die;
71
72 die unless open OUT, ">", "$ENV{bugdir}/ib_logfile0";
73 binmode OUT;
74 $_= pack("Nx[5]nx[5]", 1, 0x1286) . "BogoDB 4.3.2.1" . chr(0) x 478;
75 print OUT $_, pack("N", mycrc32($_, 0, $polynomial));
76 # checkpoint page 1 and all-zero checkpoint 2
77 $_= pack("x[13]nCNNx[484]", 0x1286, 12, 2, 0x80c);
78 print OUT $_, pack("N", mycrc32($_, 0, $polynomial));
79 die unless seek(OUT, 0x1FFFFFFFF, 0);
80 print OUT chr(0);
81 close OUT or die;
82 die unless open OUT, ">", "$ENV{bugdir}/ib_logfile1";
83 binmode OUT;
84 die unless seek(OUT, 0x800, 0); # the first 2048 bytes are unused!
85 $_= pack("Nnnx[500]", 0x80000944, 12, 12);
86 print OUT $_, pack("N", mycrc32($_, 0, $polynomial));
87 die unless seek(OUT, 0x1FFFFFFFF, 0);
88 print OUT chr(0);
89 close OUT or die;
90 EOF
91
92 --let $restart_parameters= $dirs --innodb-force-recovery=5 --innodb-log-file-size=4m --innodb_page_size=32k --innodb_buffer_pool_size=11M
93 --source include/start_mysqld.inc
94 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
95 WHERE engine = 'innodb'
96 AND support IN ('YES', 'DEFAULT', 'ENABLED');
97 --source include/shutdown_mysqld.inc
98 --let SEARCH_PATTERN= InnoDB: Upgrading redo log:
99 --source include/search_pattern_in_file.inc
100 --let $restart_parameters= $dirs
101
102 --remove_files_wildcard $bugdir
103 --rmdir $bugdir
104 --let $restart_parameters=
105 --source include/start_mysqld.inc
106
107 --echo # End of 10.5 tests