Debian Codegraph @

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

raw
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