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