Debian Codegraph @

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

raw
1 --source include/innodb_page_size.inc
2 --source include/not_embedded.inc
3 --source include/have_symlink.inc
4 --source include/not_as_root.inc
5
6 let datadir= `select @@datadir`;
7 let page_size= `select @@innodb_page_size`;
8 let tmp_in_vardir=$MYSQLTEST_VARDIR/tmp;
9
10 --echo #
11 --echo # MDEV-15333 MariaDB (still) slow start
12 --echo #
13
14 # Ensure that on normal startup, no data files are read.
15 # Note: just like in MySQL, all .ibd files will still be
16 # opened at least once.
17
18 call mtr.add_suppression("\\[ERROR\\] InnoDB: MySQL-8\\.0 tablespace in ");
19 call mtr.add_suppression("\\[ERROR\\] InnoDB: Restart in MySQL for migration/recovery\\.");
20
21 CREATE TABLE tr(a INT)ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
22 CREATE TABLE tc(a INT)ENGINE=InnoDB ROW_FORMAT=COMPACT
23 PAGE_COMPRESSED=1 PAGE_COMPRESSION_LEVEL=9;
24 --replace_result $tmp_in_vardir MYSQL_TMP_DIR
25 eval CREATE TABLE td(a INT)ENGINE=InnoDB ROW_FORMAT=DYNAMIC
26 STATS_PERSISTENT=0 DATA DIRECTORY='$tmp_in_vardir';
27
28 --source include/shutdown_mysqld.inc
29
30 --move_file $datadir/test/tr.ibd $datadir/test/tr0.ibd
31 --move_file $datadir/test/tc.ibd $datadir/test/tc0.ibd
32 --move_file $tmp_in_vardir/test/td.ibd $datadir/test/td0.ibd
33 # TODO: test that MariaDB does not even attempt to open the files
34 #--mkdir $datadir/test/tr.ibd
35 #--mkdir $datadir/test/tc.ibd
36 #--mkdir $tmp_in_vardir/test/td.ibd
37
38 perl;
39 die unless open OUT, ">", "$ENV{datadir}/test/tr.ibd";
40 print OUT "foo " x $ENV{page_size};
41 close OUT or die;
42 die unless open OUT, ">", "$ENV{datadir}/test/tc.ibd";
43 print OUT "bar " x $ENV{page_size};
44 close OUT or die;
45 die unless open OUT, ">", "$ENV{tmp_in_vardir}/test/td.ibd";
46 print OUT "Xyz " x $ENV{page_size};
47 close OUT or die;
48 die unless open ISL, "+<", "$ENV{datadir}/test/td.isl";
49 $_=<ISL>;
50 if (m|^[a-zA-Z]:|)
51 {
52 tr|/|\\|;
53 seek(ISL, 0, SEEK_SET) or die;
54 print ISL or die;
55 }
56 close ISL or die;
57 EOF
58
59 --let $restart_parameters= --skip-innodb-buffer-pool-load-at-startup
60 --source include/start_mysqld.inc
61 --let $restart_parameters=
62
63 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
64 WHERE engine = 'innodb'
65 AND support IN ('YES', 'DEFAULT', 'ENABLED');
66
67 --source include/shutdown_mysqld.inc
68
69 # TODO: test that MariaDB does not even attempt to open the files
70 #--rmdir $datadir/test/tr.ibd
71 #--rmdir $datadir/test/tc.ibd
72 #--rmdir $tmp_in_vardir/test/td.ibd
73 --remove_file $datadir/test/tr.ibd
74 --remove_file $datadir/test/tc.ibd
75 --remove_file $tmp_in_vardir/test/td.ibd
76
77 --move_file $datadir/test/tr0.ibd $datadir/test/tr.ibd
78 --move_file $datadir/test/tc0.ibd $datadir/test/tc.ibd
79 --move_file $datadir/test/td0.ibd $tmp_in_vardir/test/td.ibd
80
81 --source include/start_mysqld.inc
82 SELECT * FROM tr;
83 SELECT * FROM tc;
84 SELECT * FROM td;
85 DROP TABLE tr,tc,td;
86
87 --echo #
88 --echo # MDEV-27882 Innodb - recognise MySQL-8.0 innodb flags and give a specific error message
89 --echo #
90
91 --let MYSQLD_DATADIR= `SELECT @@datadir`
92
93 --source include/shutdown_mysqld.inc
94
95 --move_file $MYSQLD_DATADIR/ibdata1 $MYSQLD_DATADIR/ibdata1.bak
96 --copy_file std_data/mysql80/ibdata1_$page_size $MYSQLD_DATADIR/ibdata1
97
98 perl;
99 use IO::Handle;
100 my $size = 9 * 1048576;
101 if ($ENV{MTR_COMBINATION_32K}) {
102 $size *= 2;
103 }
104 if ($ENV{MTR_COMBINATION_64K}) {
105 $size *= 4;
106 }
107 $size -= $ENV{page_size};
108 die unless open(FILE, ">>", "$ENV{MYSQLD_DATADIR}/ibdata1");
109 binmode FILE;
110
111 print FILE chr(0) x $size;
112 close(FILE);
113 EOF
114
115 --let ibdata_size='9M'
116 if ($MTR_COMBINATION_32K)
117 {
118 --let ibdata_size='18M'
119 }
120 if ($MTR_COMBINATION_64K)
121 {
122 --let ibdata_size='36M'
123 }
124
125 --error 1
126 exec $MYSQLD --no-defaults --skip-networking --innodb_data_file_path=ibdata1:$ibdata_size --innodb-page-size=$page_size --datadir=$MYSQLD_DATADIR --log-error=$tmp_in_vardir/attempted_start.err;
127
128 let SEARCH_FILE= $tmp_in_vardir/attempted_start.err;
129 let SEARCH_PATTERN= InnoDB: MySQL-8\.0 tablespace in \./ibdata1;
130 source include/search_pattern_in_file.inc;
131
132 --remove_file $tmp_in_vardir/attempted_start.err
133 --remove_file $MYSQLD_DATADIR/ibdata1
134 --move_file $MYSQLD_DATADIR/ibdata1.bak $MYSQLD_DATADIR/ibdata1
135
136 --source include/start_mysqld.inc
137
138 --echo #
139 --echo # End of 10.3 tests
140 --echo #