Debian Codegraph @

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

raw
1 # Test invalid size of redo log files.
2
3 let MYSQLD_DATADIR= `select @@datadir`;
4 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
5 let args=--console --log-error-verbosity=3 > $SEARCH_FILE 2>&1;
6
7 --echo #
8 --echo # Do clean shutdown of MySQL and remove log files.
9 --echo #
10
11 --source include/shutdown_mysqld.inc
12
13 --remove_files_wildcard $MYSQLD_DATADIR/#innodb_redo #ib_redo*
14
15 let MYSQLD_REDODIR = $MYSQLD_DATADIR/#innodb_redo;
16
17 perl;
18 foreach (0, 1, 64*1024-1, 64*1024+1) {
19 my $expected_file_size = $_;
20 my $file_name = "$ENV{MYSQLD_REDODIR}/#ib_redo_prepared_$expected_file_size";
21 open($file, '>:raw', $file_name) or die "Unable to open: $!";
22 vec($byte, 0, 8) = 255;
23 print $file $byte for (1..$expected_file_size);
24 close($file);
25 my $actual_file_size = -s $file_name;
26 print "Prepared a file with size = $actual_file_size bytes\n";
27 }
28 EOF
29
30 --echo #
31 --echo # Create #ib_redo0 as empty file and start MySQL.
32 --echo # We should detect that #ib_redo0 is empty.
33 --echo #
34
35 --move_file $MYSQLD_REDODIR/#ib_redo_prepared_0 $MYSQLD_REDODIR/#ib_redo0
36 --error 1,42
37 --exec $MYSQLD_CMD $args
38 let SEARCH_PATTERN= redo log file .*#ib_redo0 is empty;
39 --source include/search_pattern.inc
40 --remove_file $SEARCH_FILE
41 --remove_file $MYSQLD_REDODIR/#ib_redo0
42
43 --echo #
44 --echo # Create #ib_redo0 with 1 byte inside and start MySQL.
45 --echo # We should detect that #ib_redo0 is too small.
46 --echo #
47
48 --move_file $MYSQLD_REDODIR/#ib_redo_prepared_1 $MYSQLD_REDODIR/#ib_redo0
49 --error 1,42
50 --exec $MYSQLD_CMD $args
51 let SEARCH_PATTERN= redo log file .*#ib_redo0 is smaller than 65536 bytes;
52 --source include/search_pattern.inc
53 --remove_file $SEARCH_FILE
54 --remove_file $MYSQLD_REDODIR/#ib_redo0
55
56 --echo #
57 --echo # Create #ib_redo0 with 64kB-1 bytes inside and start MySQL.
58 --echo # We should detect that #ib_redo0 is too small.
59 --echo #
60
61 --move_file $MYSQLD_REDODIR/#ib_redo_prepared_65535 $MYSQLD_REDODIR/#ib_redo0
62 --error 1,42
63 --exec $MYSQLD_CMD $args
64 let SEARCH_PATTERN= redo log file .*#ib_redo0 is smaller than 65536 bytes;
65 --source include/search_pattern.inc
66 --remove_file $SEARCH_FILE
67 --remove_file $MYSQLD_REDODIR/#ib_redo0
68
69 --echo #
70 --echo # Create #ib_redo0 with 64kB+1 bytes inside and start MySQL.
71 --echo # We should detect that #ib_redo0's size is not divisible by page size.
72 --echo #
73
74 --move_file $MYSQLD_REDODIR/#ib_redo_prepared_65537 $MYSQLD_REDODIR/#ib_redo0
75 --error 1,42
76 --exec $MYSQLD_CMD $args
77 let SEARCH_PATTERN= .*#ib_redo0 size 65537 is not a multiple of innodb_page_size;
78 --source include/search_pattern.inc
79 --remove_file $SEARCH_FILE
80 --remove_file $MYSQLD_REDODIR/#ib_redo0
81
82 --echo
83
84 --echo #
85 --echo # Start MySQL afterwards.
86 --echo #
87
88 --let $restart_parameters= restart:
89 --source include/start_mysqld.inc