Debian Codegraph @

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

raw
1 # Test the detection of innodb_data_file_path mismatch.
2
3 --source include/not_valgrind.inc
4 --source include/have_innodb_16k.inc
5
6 # Can be 0, depends on where the mysqld process was killed
7 --disable_query_log
8 call mtr.add_suppression("File '.*tablespaces.open..*' size is 0 bytes. Must be at least 12 bytes");
9
10 # Work around Bug#18605064 INNODB CREATES NEW DATA FILE BEFORE APPLYING REDO LOG
11 call mtr.add_suppression("Tablespace size stored in header is [0-9]* pages, but the sum of data file sizes is [0-9]* pages");
12 --enable_query_log
13
14 let BASEDIR= `select @@basedir`;
15 let DATADIR= $MYSQLTEST_VARDIR/tmp/mydatadir;
16 let BOOTSTRAP_SQL=$MYSQLTEST_VARDIR/tmp/create_test_db;
17 --let extra_args=--no-defaults --innodb_dedicated_server=OFF --console --loose-skip-auto_generate_certs --loose-skip-sha256_password_auto_generate_rsa_keys --skip-ssl --basedir=$BASEDIR --lc-messages-dir=$MYSQL_SHAREDIR
18 write_file $BOOTSTRAP_SQL;
19 CREATE SCHEMA test;
20 EOF
21
22 --source include/shutdown_mysqld.inc
23 --exec $MYSQLD $extra_args --initialize-insecure --datadir=$DATADIR --init-file=$BOOTSTRAP_SQL > $MYSQLTEST_VARDIR/bootstrap.log 2>&1
24 --exec echo "restart: --datadir=$DATADIR" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
25 --enable_reconnect
26 --source include/wait_until_connected_again.inc
27
28 let OLD_IBDATA= `select @@innodb_data_file_path`;
29 let NEW_IBDATA_PREFIX= `select replace(@@innodb_data_file_path, 'ibdata1:12M:autoextend', 'ibdata1:12M')`;
30
31 let NEW_CNF= $MYSQLTEST_VARDIR/tmp/new-my.cnf;
32
33 if ($OLD_IBDATA == $NEW_IBDATA_PREFIX)
34 {
35 --skip Needs default innodb_data_file_path
36 }
37
38
39 perl;
40 my $cmd = $ENV{MYSQLD_CMD};
41 my $cnf = $cmd;
42 my $new_cnf = $ENV{NEW_CNF};
43 $cnf =~ s/.*--defaults-file=([^ ]*).*/$1/ || die "no --defaults-file in $cmd";
44 $cmd =~ s/--defaults-file=([^ ]*)/--defaults-file=$ENV{NEW_CNF}/ || die;
45
46 $ENV{NEW_IBDATA_PREFIX} =~ s/:[0-9]+[MG]$//;
47 my @files = split(';', $ENV{NEW_IBDATA_PREFIX});
48 my $file = $ENV{DATADIR} . '/' . $files[$#files];
49
50 my $size = (stat($file))[7] || die "cannot stat $file";
51
52 my $path = "$ENV{NEW_IBDATA_PREFIX}:" . ($size / 1048576) . "M;foo:1M";
53
54 open(CNF, "<$cnf") || die "cannot read $cnf";
55 my @rec= <CNF>;
56 close(CNF);
57
58 open(NEW_CNF, ">$new_cnf") || die "cannot write $new_cnf";
59 foreach (@rec){
60 print NEW_CNF;
61 if($_ =~ /\[mysqld\]/){
62 print NEW_CNF "innodb_data_file_path=$path;\n";
63 }
64 }
65 close(NEW_CNF);
66 EOF
67
68 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
69
70 # Kill the server to inject faults.
71 --source include/kill_mysqld.inc
72
73 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
74 let $old_mysqld=$MYSQLD_CMD --datadir=$DATADIR --console > $SEARCH_FILE 2>&1;
75
76 --echo # Fault 1: Extra file in innodb_data_file_path
77
78 --exec echo "restart: --datadir=$DATADIR" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
79 --enable_reconnect
80 --source include/wait_until_connected_again.inc
81 SHOW TABLES;
82 --source include/shutdown_mysqld.inc
83
84 --echo # Recovery and clean shutdown with old data file path
85
86 # Empty the undo logs and the change buffer with innodb_fast_shutdown=0.
87 # Otherwise, log_write_requests=0 could be violated after the last restart.
88 --error 1
89 --exec $old_mysqld --innodb-fast-shutdown=0 --innodb-nonexistent-option
90
91 let SEARCH_PATTERN= \[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option';
92 --source include/search_pattern.inc
93
94 --remove_file $SEARCH_FILE
95
96 # Create empty data file
97 perl;
98 die unless open(FILE, ">$ENV{DATADIR}/foo");
99 print FILE "\0" x 1048576;
100 close(FILE);
101 EOF
102
103 --echo # Start with new data file path
104
105 --exec echo "restart: --datadir=$DATADIR --defaults-file=$NEW_CNF" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
106 --enable_reconnect
107 --source include/wait_until_connected_again.inc
108 --disable_reconnect
109
110 INSERT INTO t1 VALUES (1);
111
112 # Kill the server to inject faults.
113 --source include/kill_mysqld.inc
114
115 --echo # Fault 2: Missing file in innodb_data_file_path
116
117 --exec echo "restart: --datadir=$DATADIR" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
118 --enable_reconnect
119 --source include/wait_until_connected_again.inc
120 SHOW TABLES;
121 --source include/shutdown_mysqld.inc
122
123 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
124
125 --echo # Recovery and shutdown with innodb-force-recovery (ignore unknown file)
126 --error 1
127 --exec $old_mysqld --innodb-force-recovery=1 --innodb-fast-shutdown=0 --innodb-nonexistent-option
128
129 let SEARCH_PATTERN= \[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option';
130 --source include/search_pattern.inc
131
132 --remove_file $SEARCH_FILE
133
134 --echo # Cleanup
135
136 --remove_file $DATADIR/foo
137 --remove_file $NEW_CNF
138
139 --exec echo "restart: --datadir=$DATADIR" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
140 --enable_reconnect
141 --source include/wait_until_connected_again.inc
142
143 --echo # No log should be generated while persistent tablespaces are idle
144 --echo # FIXME: Something occasionally violates this (log_write_requests=1)
145
146 CREATE TEMPORARY TABLE t (a SERIAL) ENGINE=InnoDB;
147
148 SELECT * FROM t1;
149
150 DROP TABLE t1;
151
152 SELECT count>0 FROM information_schema.innodb_metrics
153 WHERE name='log_write_requests';
154
155 --source include/shutdown_mysqld.inc
156 --force-rmdir $DATADIR
157 --source include/start_mysqld.inc
158
159 --echo #
160 --echo # Bug#33508534: ADDITION OF A NEW DATAFILE TO SYSTEM TABLESPACE IS NOT
161 --echo # REFLECTED IN I_S.FILES
162 --echo #
163
164 --let $MYSQLD_LOG=$MYSQLTEST_VARDIR/log/server.log
165 --source include/shutdown_mysqld.inc
166 --exec $MYSQLD $extra_args --initialize-insecure --datadir=$DATADIR --init-file=$BOOTSTRAP_SQL > $MYSQLD_LOG 2>&1
167 --exec echo "restart: --datadir=$DATADIR" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
168 --enable_reconnect
169 --source include/wait_until_connected_again.inc
170
171 SELECT @@innodb_data_file_path;
172 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
173 WHERE TABLESPACE_NAME='innodb_system';
174
175 # Restart the server by adding a data file to system tablespace via innodb-data-file-path.
176 # Case 1: Data file added to end of the innodb-data-file-path list.
177 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $MYSQLD_LOG MYSQLD_LOG
178 --let $restart_parameters = restart: --datadir=$DATADIR --log-error=$MYSQLD_LOG --innodb-data-file-path=ibdata1:12M;ibdata2:12M:autoextend
179 --source include/restart_mysqld.inc
180
181 # Verify that the data file is reflected in I_S.Files
182 SELECT @@innodb_data_file_path;
183 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
184 WHERE TABLESPACE_NAME='innodb_system';
185
186 --source include/shutdown_mysqld.inc
187 # Case 2: Data file (foo) added to the beginning of the innodb-data-file-path list.
188 --let SEARCH_FILE=$MYSQLD_LOG
189 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $MYSQLD_LOG MYSQLD_LOG
190 --let $restart_params = --datadir=$DATADIR --log-error=$MYSQLD_LOG --innodb-data-file-path="foo:12M;ibdata1:12M;ibdata2:12M:autoextend"
191 --error 1,3
192 --exec $MYSQLD_CMD $restart_params
193
194 --let SEARCH_PATTERN= \[ERROR\] .* File .*foo: 'open' returned OS error 71. Cannot continue operation
195 --source include/search_pattern.inc
196
197 # The following scenario is currently not considered valid by InnoDB SE and not being restricted.
198 # Case 3: Data file (myibdata) added to the middle of the innodb-data-file-path list.
199 # --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $MYSQLD_LOG MYSQLD_LOG
200 # --let $restart_parameters = restart: --datadir=$DATADIR --log-error=$MYSQLD_LOG --innodb-data-file-path=ibdata1:12M;myibdata:12M;ibdata2:12M:autoextend
201 # --source include/start_mysqld.inc
202
203 # SELECT @@innodb_data_file_path;
204 # SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
205 # WHERE TABLESPACE_NAME='innodb_system';
206
207 # --source include/shutdown_mysqld.inc
208 --force-rmdir $DATADIR
209 --remove_file $MYSQLD_LOG
210 --remove_file $BOOTSTRAP_SQL
211 --let $restart_parameters = restart:
212 --source include/start_mysqld.inc