Debian Codegraph @

mysql-test/suite/innodb/r/log_file.result

raw
1 # Testcase for the following bugs
2 # Bug#16691130 - ASSERT WHEN INNODB_LOG_GROUP_HOME_DIR DOES NOT EXIST
3 # Bug#16418661 - CHANGING NAME IN FOR INNODB_DATA_FILE_PATH SHOULD NOT SUCCEED WITH LOG FILES
4 # Start mysqld without the possibility to create innodb_undo_tablespaces
5 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
6 SELECT * FROM INFORMATION_SCHEMA.ENGINES
7 WHERE engine = 'innodb'
8 AND support IN ('YES', 'DEFAULT', 'ENABLED');
9 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
10 FOUND 1 /\[ERROR\] InnoDB: Could not create undo tablespace '.*undo002'/ in mysqld.1.err
11 # Remove undo001,undo002,ibdata1,ibdata2,ib_logfile101
12 # Start mysqld with non existent innodb_log_group_home_dir
13 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend --innodb_log_group_home_dir=/path/to/non-existent/
14 SELECT * FROM INFORMATION_SCHEMA.ENGINES
15 WHERE engine = 'innodb'
16 AND support IN ('YES', 'DEFAULT', 'ENABLED');
17 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
18 FOUND 1 /Cannot create /path/to/non-existent/ib_logfile101/ in mysqld.1.err
19 # Successfully let InnoDB create tablespaces
20 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
21 SELECT COUNT(*) `1` FROM INFORMATION_SCHEMA.ENGINES
22 WHERE engine='innodb'
23 AND support IN ('YES', 'DEFAULT', 'ENABLED');
24 1
25 1
26 # Backup tmp/logfile/*
27 # 1. With ibdata2, Without ibdata1
28 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
29 SELECT * FROM INFORMATION_SCHEMA.ENGINES
30 WHERE engine = 'innodb'
31 AND support IN ('YES', 'DEFAULT', 'ENABLED');
32 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
33 FOUND 1 /The data file '.*ibdata1' was not found but one of the other data files '.*ibdata2' exists/ in mysqld.1.err
34 bak_ib_logfile0
35 bak_ibdata1
36 bak_ibdata2
37 bak_undo001
38 bak_undo002
39 bak_undo003
40 ib_buffer_pool
41 ib_logfile0
42 ibdata2
43 undo001
44 undo002
45 undo003
46 # 2. With ibdata1, without ibdata2
47 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
48 SELECT * FROM INFORMATION_SCHEMA.ENGINES
49 WHERE engine = 'innodb'
50 AND support IN ('YES', 'DEFAULT', 'ENABLED');
51 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
52 FOUND 1 /InnoDB: Tablespace size stored in header is \d+ pages, but the sum of data file sizes is \d+ pages/ in mysqld.1.err
53 FOUND 1 /InnoDB: Cannot start InnoDB. The tail of the system tablespace is missing/ in mysqld.1.err
54 bak_ib_logfile0
55 bak_ibdata1
56 bak_ibdata2
57 bak_undo001
58 bak_undo002
59 bak_undo003
60 ib_buffer_pool
61 ib_logfile0
62 ibdata1
63 ibdata2
64 undo001
65 undo002
66 undo003
67 # 3. Without ibdata1 & ibdata2
68 bak_ib_logfile0
69 bak_ibdata1
70 bak_ibdata2
71 bak_undo001
72 bak_undo002
73 bak_undo003
74 ib_buffer_pool
75 ib_logfile0
76 undo001
77 undo002
78 undo003
79 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
80 SELECT * FROM INFORMATION_SCHEMA.ENGINES
81 WHERE engine = 'innodb'
82 AND support IN ('YES', 'DEFAULT', 'ENABLED');
83 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
84 FOUND 1 /InnoDB: undo tablespace .*undo001.* exists\. Creating system tablespace with existing undo tablespaces is not supported\. Please delete all undo tablespaces before creating new system tablespace\./ in mysqld.1.err
85 bak_ib_logfile0
86 bak_ibdata1
87 bak_ibdata2
88 bak_undo001
89 bak_undo002
90 bak_undo003
91 ib_buffer_pool
92 ib_logfile0
93 undo001
94 undo002
95 undo003
96 # 4. Without ibdata*, ib_logfile* and with undo00*
97 bak_ib_logfile0
98 bak_ibdata1
99 bak_ibdata2
100 bak_undo001
101 bak_undo002
102 bak_undo003
103 ib_buffer_pool
104 undo001
105 undo002
106 undo003
107 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
108 SELECT * FROM INFORMATION_SCHEMA.ENGINES
109 WHERE engine = 'innodb'
110 AND support IN ('YES', 'DEFAULT', 'ENABLED');
111 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
112 bak_ib_logfile0
113 bak_ibdata1
114 bak_ibdata2
115 bak_undo001
116 bak_undo002
117 bak_undo003
118 ib_buffer_pool
119 undo001
120 undo002
121 undo003
122 # 5. Without ibdata*,ib_logfile* files & Without undo002
123 bak_ib_logfile0
124 bak_ibdata1
125 bak_ibdata2
126 bak_undo001
127 bak_undo002
128 bak_undo003
129 ib_buffer_pool
130 undo001
131 undo003
132 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
133 SELECT * FROM INFORMATION_SCHEMA.ENGINES
134 WHERE engine = 'innodb'
135 AND support IN ('YES', 'DEFAULT', 'ENABLED');
136 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
137 bak_ib_logfile0
138 bak_ibdata1
139 bak_ibdata2
140 bak_undo001
141 bak_undo002
142 bak_undo003
143 ib_buffer_pool
144 undo001
145 undo003
146 # 6. Without ibdata*,ib_logfile* files & Without undo001, undo002
147 bak_ib_logfile0
148 bak_ibdata1
149 bak_ibdata2
150 bak_undo001
151 bak_undo002
152 bak_undo003
153 ib_buffer_pool
154 undo003
155 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
156 SELECT * FROM INFORMATION_SCHEMA.ENGINES
157 WHERE engine = 'innodb'
158 AND support IN ('YES', 'DEFAULT', 'ENABLED');
159 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
160 FOUND 1 /undo tablespace .*undo003.* exists\. Creating system tablespace with existing undo tablespaces is not supported\. Please delete all undo tablespaces before creating new system tablespace\./ in mysqld.1.err
161 bak_ib_logfile0
162 bak_ibdata1
163 bak_ibdata2
164 bak_undo001
165 bak_undo002
166 bak_undo003
167 ib_buffer_pool
168 undo003
169 # 7. With ibdata files & Without undo002
170 bak_ib_logfile0
171 bak_ibdata1
172 bak_ibdata2
173 bak_undo001
174 bak_undo002
175 bak_undo003
176 ib_buffer_pool
177 ib_logfile0
178 ibdata1
179 ibdata2
180 undo001
181 undo003
182 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
183 SELECT * FROM INFORMATION_SCHEMA.ENGINES
184 WHERE engine = 'innodb'
185 AND support IN ('YES', 'DEFAULT', 'ENABLED');
186 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
187 FOUND 1 /InnoDB: Failed to open the undo tablespace/ in mysqld.1.err
188 bak_ib_logfile0
189 bak_ibdata1
190 bak_ibdata2
191 bak_undo001
192 bak_undo002
193 bak_undo003
194 ib_buffer_pool
195 ib_logfile0
196 ibdata1
197 ibdata2
198 undo001
199 undo003
200 # 8. With ibdata files & Without undo001, undo002
201 bak_ib_logfile0
202 bak_ibdata1
203 bak_ibdata2
204 bak_undo001
205 bak_undo002
206 bak_undo003
207 ib_buffer_pool
208 ib_logfile0
209 ibdata1
210 ibdata2
211 undo003
212 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
213 SELECT * FROM INFORMATION_SCHEMA.ENGINES
214 WHERE engine = 'innodb'
215 AND support IN ('YES', 'DEFAULT', 'ENABLED');
216 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
217 FOUND 2 /InnoDB: Failed to open the undo tablespace/ in mysqld.1.err
218 bak_ib_logfile0
219 bak_ibdata1
220 bak_ibdata2
221 bak_undo001
222 bak_undo002
223 bak_undo003
224 ib_buffer_pool
225 ib_logfile0
226 ibdata1
227 ibdata2
228 undo003
229 # 9. Without ibdata*, without undo*
230 bak_ib_logfile0
231 bak_ibdata1
232 bak_ibdata2
233 bak_undo001
234 bak_undo002
235 bak_undo003
236 ib_buffer_pool
237 ib_logfile0
238 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
239 SELECT * FROM INFORMATION_SCHEMA.ENGINES
240 WHERE engine = 'innodb'
241 AND support IN ('YES', 'DEFAULT', 'ENABLED');
242 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
243 FOUND 1 /redo log file .*ib_logfile0.* exists\. Creating system tablespace with existing redo log file is not recommended\. Please delete redo log file before creating new system tablespace\./ in mysqld.1.err
244 bak_ib_logfile0
245 bak_ibdata1
246 bak_ibdata2
247 bak_undo001
248 bak_undo002
249 bak_undo003
250 ib_buffer_pool
251 ib_logfile0
252 # 10. With ibdata*, without ib_logfile0
253 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
254 SELECT * FROM INFORMATION_SCHEMA.ENGINES
255 WHERE engine = 'innodb'
256 AND support IN ('YES', 'DEFAULT', 'ENABLED');
257 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
258 bak_ib_logfile0
259 bak_ibdata1
260 bak_ibdata2
261 bak_undo001
262 bak_undo002
263 bak_undo003
264 ib_buffer_pool
265 ibdata1
266 ibdata2
267 undo001
268 undo002
269 undo003
270 # 11. With ibdata*
271 bak_ib_logfile0
272 bak_ibdata1
273 bak_ibdata2
274 bak_undo001
275 bak_undo002
276 bak_undo003
277 ib_buffer_pool
278 ib_logfile0
279 ibdata1
280 ibdata2
281 undo001
282 undo002
283 undo003
284 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-directory=MYSQLTEST_VARDIR/tmp/log_file --innodb-undo-logs=20 --innodb-undo-tablespaces=3 --innodb-data-file-path=ibdata1:16M;ibdata2:10M:autoextend
285 SELECT COUNT(*) `1` FROM INFORMATION_SCHEMA.ENGINES
286 WHERE engine='innodb'
287 AND support IN ('YES', 'DEFAULT', 'ENABLED');
288 1
289 1
290 # restart: --innodb-log-write-ahead-size=513
291 SELECT * FROM INFORMATION_SCHEMA.ENGINES
292 WHERE engine = 'innodb'
293 AND support IN ('YES', 'DEFAULT', 'ENABLED');
294 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
295 # restart: --innodb-log-write-ahead-size=4095
296 SELECT * FROM INFORMATION_SCHEMA.ENGINES
297 WHERE engine = 'innodb'
298 AND support IN ('YES', 'DEFAULT', 'ENABLED');
299 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
300 # restart: --innodb-log-write-ahead-size=10000
301 SELECT @@innodb_log_write_ahead_size;
302 @@innodb_log_write_ahead_size
303 4096
304 # Cleanup
305 bak_ib_logfile0
306 bak_ibdata1
307 bak_ibdata2
308 bak_undo001
309 bak_undo002
310 bak_undo003
311 ib_buffer_pool
312 ib_logfile0
313 ibdata1
314 ibdata2
315 undo001
316 undo002
317 undo003