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