| 1 |
--source include/have_64bit.inc |
| 2 |
|
| 3 |
--echo # Testcase for the following bugs |
| 4 |
--echo # Bug#16691130 - ASSERT WHEN INNODB_LOG_GROUP_HOME_DIR DOES NOT EXIST |
| 5 |
--echo # Bug#16418661 - CHANGING NAME IN FOR INNODB_DATA_FILE_PATH SHOULD NOT SUCCEED WITH LOG FILES |
| 6 |
|
| 7 |
let bugdir= $MYSQLTEST_VARDIR/tmp/log_file; |
| 8 |
--mkdir $bugdir |
| 9 |
--mkdir $bugdir/data |
| 10 |
|
| 11 |
--source include/shutdown_mysqld.inc |
| 12 |
let SEARCH_FILE = $bugdir/my_restart.err; |
| 13 |
let $args=--defaults-file=$bugdir/my.cnf --loose-console --innodb_dedicated_server=OFF --core-file --log-error-verbosity=3 > $SEARCH_FILE 2>&1 ; |
| 14 |
|
| 15 |
--echo # Write tmp/log_file/my.cnf |
| 16 |
--write_file $bugdir/my.cnf |
| 17 |
[mysqld] |
| 18 |
secure_file_priv="" |
| 19 |
innodb_fast_shutdown=0 |
| 20 |
innodb_data_file_path = ibdata1:16M;ibdata2:16M |
| 21 |
innodb_rollback_segments = 20 |
| 22 |
innodb_redo_log_capacity = 60M |
| 23 |
loose-skip-log-bin |
| 24 |
EOF |
| 25 |
|
| 26 |
--exec echo "datadir = $bugdir/data" >> $bugdir/my.cnf |
| 27 |
--exec echo "innodb_data_home_dir = $bugdir/data" >> $bugdir/my.cnf |
| 28 |
|
| 29 |
--echo # Start mysqld without the possibility to create undo tablespaces |
| 30 |
--echo # because a directory exists named 'undo_002'. |
| 31 |
--mkdir $bugdir/data/undo_002 |
| 32 |
# In scope of WL#9461,WL#9357, in place upgrade condition requires |
| 33 |
# mysql.plugin.frm file. Create the file manually here to allow |
| 34 |
# initialization of innodb. |
| 35 |
--mkdir $bugdir/data/mysql |
| 36 |
write_file $bugdir/data/mysql/plugin.frm; |
| 37 |
EOF |
| 38 |
|
| 39 |
--error 1,3,42 |
| 40 |
--exec $MYSQLD $args |
| 41 |
let SEARCH_PATTERN=\[ERROR\] .*MY-\\d+.* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation; |
| 42 |
--source include/search_pattern.inc |
| 43 |
|
| 44 |
--remove_file $bugdir/data/mysql_dd_upgrade_info |
| 45 |
--force-rmdir $bugdir/data/mysql |
| 46 |
--list_files $bugdir/data |
| 47 |
--rmdir $bugdir/data/undo_002 |
| 48 |
--remove_file $bugdir/data/auto.cnf |
| 49 |
|
| 50 |
--echo # Start mysqld to create tablespaces according to my.cnf |
| 51 |
--exec $MYSQLD $args --initialize-insecure |
| 52 |
|
| 53 |
--echo # Backup the datadir |
| 54 |
--force-cpdir $bugdir/data $bugdir/data_backup |
| 55 |
|
| 56 |
--echo # 1. Start mysqld with non existent innodb_log_group_home_dir |
| 57 |
--error 1,3,42 |
| 58 |
--exec $MYSQLD $args --innodb_log_group_home_dir=/path/to/non-existent/ --innodb-unknown-parameter-1 |
| 59 |
let SEARCH_PATTERN=\[ERROR\] .* Failed to list redo log files in the redo log directory .path.to.non-existent; |
| 60 |
--source include/search_pattern.inc |
| 61 |
let SEARCH_PATTERN=\[ERROR\] .* Aborting; |
| 62 |
--source include/search_pattern.inc |
| 63 |
|
| 64 |
--echo # 2. Start mysqld without ibdata1 |
| 65 |
--remove_file $bugdir/data/ibdata1 |
| 66 |
--error 1,3,42 |
| 67 |
--exec $MYSQLD $args --innodb-unknown-parameter-2 |
| 68 |
let SEARCH_PATTERN=\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation; |
| 69 |
--source include/search_pattern.inc |
| 70 |
--source ../include/bootstrap_cleanup.inc |
| 71 |
|
| 72 |
--echo # 3. Start mysqld without ibdata2 |
| 73 |
--remove_file $bugdir/data/ibdata2 |
| 74 |
--error 1,3,42 |
| 75 |
--exec $MYSQLD $args --innodb-unknown-parameter-3 |
| 76 |
let SEARCH_PATTERN=\[ERROR\] .* Tablespace size stored in header is \d+ pages, but; |
| 77 |
--source include/search_pattern.inc |
| 78 |
let SEARCH_PATTERN=\[ERROR\] .* Aborting; |
| 79 |
--source include/search_pattern.inc |
| 80 |
--source ../include/bootstrap_cleanup.inc |
| 81 |
|
| 82 |
--echo # 4. Start mysqld without ibdata1 & ibdata2 |
| 83 |
--remove_file $bugdir/data/ibdata1 |
| 84 |
--remove_file $bugdir/data/ibdata2 |
| 85 |
--error 1,3,42 |
| 86 |
--exec $MYSQLD $args --innodb-unknown-parameter-4 |
| 87 |
let SEARCH_PATTERN=\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation; |
| 88 |
--source include/search_pattern.inc |
| 89 |
--source ../include/bootstrap_cleanup.inc |
| 90 |
|
| 91 |
--echo # 5. Start mysqld without ibdata*, #ib_redo* and undo_00* |
| 92 |
--remove_files_wildcard $bugdir/data ibdata* |
| 93 |
--remove_files_wildcard $bugdir/data/#innodb_redo #ib_redo* |
| 94 |
--remove_files_wildcard $bugdir/data undo_00* |
| 95 |
--error 1,3,42 |
| 96 |
--exec $MYSQLD $args --innodb-unknown-parameter-5 |
| 97 |
let SEARCH_PATTERN=\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation; |
| 98 |
--source include/search_pattern.inc |
| 99 |
--source ../include/bootstrap_cleanup.inc |
| 100 |
|
| 101 |
--echo # 6. Start mysqld without undo_002 |
| 102 |
--remove_file $bugdir/data/undo_002 |
| 103 |
--error 1,3,42 |
| 104 |
--exec $MYSQLD $args --innodb-unknown-parameter-6 |
| 105 |
let SEARCH_PATTERN=\[Note\] .* Creating UNDO Tablespace .*undo_002; |
| 106 |
--source include/search_pattern.inc |
| 107 |
--source ../include/bootstrap_cleanup.inc |
| 108 |
|
| 109 |
--echo # 7. Start mysqld without undo_001, undo_002 |
| 110 |
--remove_file $bugdir/data/undo_001 |
| 111 |
--remove_file $bugdir/data/undo_002 |
| 112 |
--error 1,3,42 |
| 113 |
--exec $MYSQLD $args --innodb-unknown-parameter-7 |
| 114 |
let SEARCH_PATTERN=\[Note\] .* Creating UNDO Tablespace .*undo_001; |
| 115 |
--source include/search_pattern.inc |
| 116 |
let SEARCH_PATTERN=\[Note\] .* Creating UNDO Tablespace .*undo_002; |
| 117 |
--source include/search_pattern.inc |
| 118 |
--source ../include/bootstrap_cleanup.inc |
| 119 |
|
| 120 |
--echo # 8. Start mysqld without #ib_redo* |
| 121 |
--remove_files_wildcard $bugdir/data/#innodb_redo #ib_redo* |
| 122 |
--error 1 |
| 123 |
--exec $MYSQLD $args --innodb-unknown-parameter-8 |
| 124 |
let SEARCH_PATTERN=\[Note\] .* Apply batch completed; |
| 125 |
--source include/search_pattern.inc |
| 126 |
--source ../include/bootstrap_cleanup.inc |
| 127 |
|
| 128 |
--echo # 9. Add new datafile at the end |
| 129 |
--error 1,3,42 |
| 130 |
--exec $MYSQLD $args --innodb-data_file_path="ibdata1:16M;ibdata2:16M;ibdata3:20M:autoextend" --innodb-unknown-parameter-9 |
| 131 |
let SEARCH_PATTERN=\[Note\] .* File.*ibdata3. size is now 20 MB; |
| 132 |
--source include/search_pattern.inc |
| 133 |
|
| 134 |
--echo # 10. Show that --innodb-undo-directory cannot be an ancestor of the datadir |
| 135 |
--error 1,3,42 |
| 136 |
--exec $MYSQLD $args --innodb-undo-directory=.. --innodb-unknown-parameter-10 |
| 137 |
let SEARCH_PATTERN=\[ERROR\] .* The innodb_undo_directory is not allowed to be an ancestor of the datadir; |
| 138 |
--source include/search_pattern.inc |
| 139 |
|
| 140 |
--echo # 11. Try to initialize InnoDB in directory which has log files |
| 141 |
--mkdir $bugdir/step11 |
| 142 |
--mkdir $bugdir/step11-log |
| 143 |
--mkdir $bugdir/step11-log/#innodb_redo |
| 144 |
--write_file $bugdir/step11-log/#innodb_redo/#ib_redo42 |
| 145 |
I love MySQL. |
| 146 |
EOF |
| 147 |
--error 1,42 |
| 148 |
--exec $MYSQLD $args --initialize-insecure --innodb_log_group_home_dir=$bugdir/step11-log/ --innodb_data_home_dir=$bugdir/step11/ --datadir=$bugdir/step11 --innodb-unknown-parameter-11 |
| 149 |
let SEARCH_PATTERN=--initialize specified but the redo log directory .* has redo log files inside; |
| 150 |
--source include/search_pattern.inc |
| 151 |
--force-rmdir $bugdir/step11-log |
| 152 |
--force-rmdir $bugdir/step11 |
| 153 |
--source ../include/bootstrap_cleanup.inc |
| 154 |
|
| 155 |
--echo # 12. Rename log file after shutdown and start MySQL (should succeed) |
| 156 |
let MYSQLD_DATADIR= $bugdir/data; |
| 157 |
perl; |
| 158 |
require 'include/ib_redo_log_files.inc'; |
| 159 |
use File::Copy qw(move); |
| 160 |
my $files = []; |
| 161 |
foreach (log_get_non_tmp_files()) { |
| 162 |
if ($_ =~ /#ib_redo(\d+)$/) { |
| 163 |
push @{$files}, {id=>$1,name=>$_}; |
| 164 |
} |
| 165 |
} |
| 166 |
@$files_ordered_by_id_desc = (sort {$b->{id} <=> $a->{id}} @{$files}); |
| 167 |
foreach $file (@{$files_ordered_by_id_desc}) { |
| 168 |
my $old_file_no = $file->{id}; |
| 169 |
my $old_file_name = $file->{name}; |
| 170 |
my $new_file_no = $file->{id} + 1; |
| 171 |
(my $new_file_name = $file->{name}) =~ s/^(.*#ib_redo)(\d+)$/$1$new_file_no/; |
| 172 |
move $old_file_name, $new_file_name; |
| 173 |
} |
| 174 |
EOF |
| 175 |
--error 1,42 |
| 176 |
--exec $MYSQLD $args --skip-networking --socket=$MYSQL_TMP_DIR/tmp.sock --innodb-unknown-parameter-12 |
| 177 |
let SEARCH_PATTERN=[ERROR].*innodb-unknown-parameter-12.*; |
| 178 |
--source include/search_pattern.inc |
| 179 |
--source ../include/bootstrap_cleanup.inc |
| 180 |
|
| 181 |
--echo # Cleanup |
| 182 |
--force-rmdir $bugdir |
| 183 |
|
| 184 |
--source include/start_mysqld.inc |