Debian Codegraph @

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

raw
1 --echo #
2 --echo # ALLOW IN-PLACE DDL OPERATIONS ON MISSING AND/OR DISCARDED TABLESPACES
3 --echo #
4
5 let $MYSQLD_DATADIR=`select @@datadir`;
6 SET GLOBAL innodb_file_per_table=1;
7
8 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
9 INSERT INTO t1 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
10
11 CREATE TABLE t2 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
12 INSERT INTO t2 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
13
14 CREATE TABLE t3 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
15 INSERT INTO t3 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
16
17 CREATE TABLE t4 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
18 INSERT INTO t4 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
19
20 --echo # Check also with tables having special characters
21 CREATE TABLE `t_.._a` (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
22 INSERT INTO `t_.._a` VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
23
24 CREATE TABLE `t_.._b` (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
25 INSERT INTO `t_.._b` VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
26
27 --echo #
28 --echo # Remove and Discard tablespaces
29 --echo #
30 --source include/shutdown_mysqld.inc
31 --remove_file $MYSQLD_DATADIR/test/t1.ibd
32 --remove_file $MYSQLD_DATADIR/test/t2.ibd
33 --remove_file $MYSQLD_DATADIR/test/t_@002e@002e_a.ibd
34 --source include/start_mysqld.inc
35 ALTER TABLE t3 DISCARD TABLESPACE;
36 ALTER TABLE t4 DISCARD TABLESPACE;
37 ALTER TABLE `t_.._b` DISCARD TABLESPACE;
38
39 --echo #
40 --echo # SELECT * FROM __
41 --echo #
42 # The ER_NO_SUCH_TABLE is being thrown by ha_innobase::open().
43 # The table does exist, only the tablespace does not exist.
44 --error ER_TABLESPACE_MISSING
45 SELECT * FROM t1;
46 SHOW WARNINGS;
47 --error ER_TABLESPACE_MISSING
48 SELECT * FROM t2;
49 SHOW WARNINGS;
50 --error ER_TABLESPACE_DISCARDED
51 SELECT * FROM t3;
52 SHOW WARNINGS;
53 --error ER_TABLESPACE_DISCARDED
54 SELECT * FROM t4;
55 SHOW WARNINGS;
56 --error ER_TABLESPACE_MISSING
57 SELECT * FROM `t_.._a`;
58 SHOW WARNINGS;
59 --error ER_TABLESPACE_DISCARDED
60 SELECT * FROM `t_.._b`;
61 SHOW WARNINGS;
62
63 --echo #
64 --echo # ALTER TABLE __ TABLESPACE innodb_system
65 --echo #
66 --error ER_TABLESPACE_MISSING
67 ALTER TABLE t1 TABLESPACE innodb_system, ALGORITHM=INPLACE;
68 SHOW WARNINGS;
69 --error ER_TABLESPACE_MISSING
70 ALTER TABLE t2 TABLESPACE innodb_system, ALGORITHM=COPY;
71 SHOW WARNINGS;
72 --error ER_TABLESPACE_DISCARDED
73 ALTER TABLE t3 TABLESPACE innodb_system, ALGORITHM=INPLACE;
74 SHOW WARNINGS;
75 --error ER_TABLESPACE_DISCARDED
76 ALTER TABLE t4 TABLESPACE innodb_system, ALGORITHM=COPY;
77 SHOW WARNINGS;
78
79 --echo #
80 --echo # ALTER TABLE __ TABLESPACE ts1
81 --echo #
82 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
83 --error ER_TABLESPACE_MISSING
84 ALTER TABLE t1 TABLESPACE ts1, ALGORITHM=INPLACE;
85 SHOW WARNINGS;
86 --error ER_TABLESPACE_MISSING
87 ALTER TABLE t2 TABLESPACE ts1, ALGORITHM=COPY;
88 SHOW WARNINGS;
89 --error ER_TABLESPACE_DISCARDED
90 ALTER TABLE t3 TABLESPACE ts1, ALGORITHM=INPLACE;
91 SHOW WARNINGS;
92 --error ER_TABLESPACE_DISCARDED
93 ALTER TABLE t4 TABLESPACE ts1, ALGORITHM=COPY;
94 SHOW WARNINGS;
95
96 --echo #
97 --echo # ALTER TABLE __ ADD INDEX
98 --echo #
99 --error ER_TABLESPACE_MISSING
100 ALTER TABLE t1 ADD INDEX (a), ALGORITHM=INPLACE;
101 SHOW WARNINGS;
102 --error ER_TABLESPACE_MISSING
103 ALTER TABLE t2 ADD INDEX (a), ALGORITHM=COPY;
104 SHOW WARNINGS;
105 --error ER_KEY_COLUMN_DOES_NOT_EXITS
106 ALTER TABLE t3 ADD INDEX (a), ALGORITHM=INPLACE;
107 SHOW WARNINGS;
108 --error ER_KEY_COLUMN_DOES_NOT_EXITS
109 ALTER TABLE t4 ADD INDEX (a), ALGORITHM=COPY;
110 SHOW WARNINGS;
111
112 --echo #
113 --echo # ALTER TABLE __ DROP INDEX
114 --echo #
115 --error ER_TABLESPACE_MISSING
116 ALTER TABLE t1 DROP INDEX c2, ALGORITHM=INPLACE;
117 SHOW WARNINGS;
118 --error ER_TABLESPACE_MISSING
119 ALTER TABLE t2 DROP INDEX c2, ALGORITHM=COPY;
120 SHOW WARNINGS;
121
122 ALTER TABLE t3 DROP INDEX c2, ALGORITHM=INPLACE;
123
124 --error ER_TABLESPACE_DISCARDED
125 ALTER TABLE t4 DROP INDEX c2, ALGORITHM=COPY;
126 SHOW WARNINGS;
127
128 --echo #
129 --echo # ALTER TABLE __ ADD COLUMN
130 --echo #
131 --error ER_TABLESPACE_MISSING
132 ALTER TABLE t1 ADD COLUMN c3 INT, ALGORITHM=INPLACE;
133 SHOW WARNINGS;
134 --error ER_TABLESPACE_MISSING
135 ALTER TABLE t2 ADD COLUMN c3 INT, ALGORITHM=COPY;
136 SHOW WARNINGS;
137 --error ER_TABLESPACE_DISCARDED
138 ALTER TABLE t3 ADD COLUMN c3 INT, ALGORITHM=INPLACE;
139 SHOW WARNINGS;
140 --error ER_TABLESPACE_DISCARDED
141 ALTER TABLE t4 ADD COLUMN c3 INT, ALGORITHM=COPY;
142 SHOW WARNINGS;
143
144 --echo #
145 --echo # ALTER TABLE __ DROP COLUMN
146 --echo #
147 --error ER_TABLESPACE_MISSING
148 ALTER TABLE t1 DROP COLUMN ct, ALGORITHM=INPLACE;
149 SHOW WARNINGS;
150 --error ER_TABLESPACE_MISSING
151 ALTER TABLE t2 DROP COLUMN ct, ALGORITHM=COPY;
152 SHOW WARNINGS;
153 --error ER_TABLESPACE_DISCARDED
154 ALTER TABLE t3 DROP COLUMN ct, ALGORITHM=INPLACE;
155 SHOW WARNINGS;
156 --error ER_TABLESPACE_DISCARDED
157 ALTER TABLE t4 DROP COLUMN ct, ALGORITHM=COPY;
158 SHOW WARNINGS;
159
160 --echo #
161 --echo # ALTER TABLE __ ALTER c2 DROP DEFAULT
162 --echo #
163 --error ER_TABLESPACE_MISSING
164 ALTER TABLE t1 ALTER c2 DROP DEFAULT, ALGORITHM=INPLACE;
165 SHOW WARNINGS;
166 --error ER_TABLESPACE_MISSING
167 ALTER TABLE t2 ALTER c2 DROP DEFAULT, ALGORITHM=COPY;
168 SHOW WARNINGS;
169
170 ALTER TABLE t3 ALTER c2 DROP DEFAULT, ALGORITHM=INPLACE;
171
172 --error ER_TABLESPACE_DISCARDED
173 ALTER TABLE t4 ALTER c2 DROP DEFAULT, ALGORITHM=COPY;
174 SHOW WARNINGS;
175
176 --echo #
177 --echo # ALTER TABLE __ ALTER c2 SET DEFAULT 42
178 --echo #
179 --error ER_TABLESPACE_MISSING
180 ALTER TABLE t1 ALTER c2 SET DEFAULT 42, ALGORITHM=INPLACE;
181 SHOW WARNINGS;
182 --error ER_TABLESPACE_MISSING
183 ALTER TABLE t2 ALTER c2 SET DEFAULT 42, ALGORITHM=COPY;
184 SHOW WARNINGS;
185
186 ALTER TABLE t3 ALTER c2 SET DEFAULT 42, ALGORITHM=INPLACE;
187
188 --error ER_TABLESPACE_DISCARDED
189 ALTER TABLE t4 ALTER c2 SET DEFAULT 42, ALGORITHM=COPY;
190 SHOW WARNINGS;
191
192 --echo #
193 --echo # ALTER TABLE __ ADD FULLTEXT INDEX
194 --echo #
195 #--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
196 --error ER_TABLESPACE_MISSING
197 ALTER TABLE t1 ADD FULLTEXT INDEX (ct), ALGORITHM=INPLACE;
198 SHOW WARNINGS;
199 --error ER_TABLESPACE_MISSING
200 ALTER TABLE t2 ADD FULLTEXT INDEX (ct), ALGORITHM=COPY;
201 SHOW WARNINGS;
202
203 ALTER TABLE t3 ADD FULLTEXT INDEX (ct), ALGORITHM=INPLACE;
204
205 --error ER_TABLESPACE_DISCARDED
206 ALTER TABLE t4 ADD FULLTEXT INDEX (ct), ALGORITHM=COPY;
207 SHOW WARNINGS;
208
209 --echo #
210 --echo # ALTER TABLE __ CHANGE c2 c2 INT AFTER c1
211 --echo #
212 --error ER_TABLESPACE_MISSING
213 ALTER TABLE t1 CHANGE c2 c2 INT AFTER c1, ALGORITHM=INPLACE;
214 SHOW WARNINGS;
215 --error ER_TABLESPACE_MISSING
216 ALTER TABLE t2 CHANGE c2 c2 INT AFTER c1, ALGORITHM=COPY;
217 SHOW WARNINGS;
218
219 ALTER TABLE t3 CHANGE c2 c2 INT AFTER c1, ALGORITHM=INPLACE;
220
221 --error ER_TABLESPACE_DISCARDED
222 ALTER TABLE t4 CHANGE c2 c2 INT AFTER c1, ALGORITHM=COPY;
223 SHOW WARNINGS;
224
225 --echo #
226 --echo # ALTER TABLE __ CHANGE c1 c1 INT FIRST
227 --echo #
228 --error ER_TABLESPACE_MISSING
229 ALTER TABLE t1 CHANGE c1 c1 INT FIRST, ALGORITHM=INPLACE;
230 SHOW WARNINGS;
231 --error ER_TABLESPACE_MISSING
232 ALTER TABLE t2 CHANGE c1 c1 INT FIRST, ALGORITHM=COPY;
233 SHOW WARNINGS;
234
235 ALTER TABLE t3 CHANGE c1 c1 INT FIRST, ALGORITHM=INPLACE;
236
237 --error ER_TABLESPACE_DISCARDED
238 ALTER TABLE t4 CHANGE c1 c1 INT FIRST, ALGORITHM=COPY;
239 SHOW WARNINGS;
240
241 --echo #
242 --echo # ALTER TABLE __ CHANGE c2 c3 INT
243 --echo #
244 --error ER_TABLESPACE_MISSING
245 ALTER TABLE t1 CHANGE c2 c3 INT, ALGORITHM=INPLACE;
246 SHOW WARNINGS;
247 --error ER_TABLESPACE_MISSING
248 ALTER TABLE t2 CHANGE c2 c3 INT, ALGORITHM=COPY;
249 SHOW WARNINGS;
250
251 ALTER TABLE t3 CHANGE c2 c3 INT, ALGORITHM=INPLACE;
252
253 --error ER_TABLESPACE_DISCARDED
254 ALTER TABLE t4 CHANGE c2 c3 INT, ALGORITHM=COPY;
255 SHOW WARNINGS;
256
257 --echo #
258 --echo # ALTER TABLE __ ROW_FORMAT=REDUNDANT
259 --echo #
260 --error ER_TABLESPACE_MISSING
261 ALTER TABLE t1 ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE;
262 SHOW WARNINGS;
263 --error ER_TABLESPACE_MISSING
264 ALTER TABLE t2 ROW_FORMAT=REDUNDANT, ALGORITHM=COPY;
265 SHOW WARNINGS;
266 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
267 ALTER TABLE t3 ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE;
268 SHOW WARNINGS;
269 --error ER_TABLESPACE_DISCARDED
270 ALTER TABLE t4 ROW_FORMAT=REDUNDANT, ALGORITHM=COPY;
271 SHOW WARNINGS;
272
273 --echo #
274 --echo # ALTER TABLE __ RENAME TO __
275 --echo #
276 --error ER_TABLESPACE_MISSING
277 ALTER TABLE t1 RENAME TO t11, ALGORITHM=INPLACE;
278 SHOW WARNINGS;
279 --error ER_TABLESPACE_MISSING
280 ALTER TABLE t2 RENAME TO t22, ALGORITHM=COPY;
281 SHOW WARNINGS;
282
283 ALTER TABLE t3 RENAME TO t33, ALGORITHM=INPLACE;
284 ALTER TABLE t33 RENAME TO t3, ALGORITHM=INPLACE;
285
286 --error ER_TABLESPACE_DISCARDED
287 ALTER TABLE t4 RENAME TO t44, ALGORITHM=COPY;
288 SHOW WARNINGS;
289
290 --echo #
291 --echo # DISCARD an already missing tablespace;
292 --echo #
293 ALTER TABLE t1 DISCARD TABLESPACE;
294
295 --echo #
296 --echo # Show the resultant tables before dropping them
297 --echo #
298 SHOW CREATE TABLE t1;
299 --error ER_TABLESPACE_MISSING
300 SHOW CREATE TABLE t2;
301 SHOW WARNINGS;
302 SHOW CREATE TABLE t3;
303 SHOW CREATE TABLE t4;
304 --error ER_TABLESPACE_MISSING
305 SHOW CREATE TABLE `t_.._a`;
306 SHOW WARNINGS;
307 SHOW CREATE TABLE `t_.._b`;
308
309 --echo #
310 --echo # DROP TABLE __ while mising or discarded
311 --echo #
312 DROP TABLE t1;
313 DROP TABLE t2;
314 DROP TABLE t3;
315 DROP TABLE t4;
316 DROP TABLE `t_.._a`;
317 DROP TABLE `t_.._b`;
318
319
320 --echo #
321 --echo # Recreate the 6 tables; 1 & 2 missing, 3 & 4 discarded, 5 & 6 normal
322 --echo #
323 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
324 CREATE TABLE t2 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
325 CREATE TABLE t3 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
326 CREATE TABLE t4 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
327 CREATE TABLE t5 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
328 CREATE TABLE t6 (c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2));
329 INSERT INTO t1 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
330 INSERT INTO t2 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
331 INSERT INTO t3 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
332 INSERT INTO t4 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
333 INSERT INTO t5 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
334 INSERT INTO t6 VALUES (1, 1, 'one'), (2, 2, 'two'), (3, 3, 'three');
335 CREATE TABLE t1p LIKE t1;
336 CREATE TABLE t2p LIKE t1;
337 CREATE TABLE t3p LIKE t1;
338 CREATE TABLE t4p LIKE t1;
339 CREATE TABLE t5p LIKE t1;
340 CREATE TABLE t6p LIKE t1;
341
342 --echo #
343 --echo # Remove t1 and Discard t3 & t4
344 --echo #
345 --source include/shutdown_mysqld.inc
346 --remove_file $MYSQLD_DATADIR/test/t1.ibd
347 --source include/start_mysqld.inc
348 ALTER TABLE t3 DISCARD TABLESPACE;
349 ALTER TABLE t4 DISCARD TABLESPACE;
350
351 --echo #
352 --echo # Add some foreign key constraints
353 --echo #
354 CREATE TABLE t1c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
355 CONSTRAINT t1c2 FOREIGN KEY (c2) REFERENCES t1(c2),
356 CONSTRAINT t1c3 FOREIGN KEY (c3) REFERENCES t1p(c2));
357 CREATE TABLE t2c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
358 CONSTRAINT t2c2 FOREIGN KEY (c2) REFERENCES t2(c2),
359 CONSTRAINT t2c3 FOREIGN KEY (c3) REFERENCES t2p(c2));
360 CREATE TABLE t3c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
361 CONSTRAINT t3c2 FOREIGN KEY (c2) REFERENCES t3(c2),
362 CONSTRAINT t3c3 FOREIGN KEY (c3) REFERENCES t3p(c2));
363 CREATE TABLE t4c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
364 CONSTRAINT t4c2 FOREIGN KEY (c2) REFERENCES t4(c2),
365 CONSTRAINT t4c3 FOREIGN KEY (c3) REFERENCES t4p(c2));
366 CREATE TABLE t5c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
367 CONSTRAINT t5c2 FOREIGN KEY (c2) REFERENCES t5(c2),
368 CONSTRAINT t5c3 FOREIGN KEY (c3) REFERENCES t5p(c2));
369 CREATE TABLE t6c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
370 CONSTRAINT t6c2 FOREIGN KEY (c2) REFERENCES t6(c2),
371 CONSTRAINT t6c3 FOREIGN KEY (c3) REFERENCES t6p(c2));
372
373 --echo #
374 --echo # Remove t2, try to discard t3 & t4 already discarded
375 --echo #
376 --source include/shutdown_mysqld.inc
377 --remove_file $MYSQLD_DATADIR/test/t2.ibd
378 --source include/start_mysqld.inc
379 --error ER_ROW_IS_REFERENCED_2
380 ALTER TABLE t3 DISCARD TABLESPACE;
381 SHOW WARNINGS;
382 --error ER_ROW_IS_REFERENCED_2
383 ALTER TABLE t4 DISCARD TABLESPACE;
384 SHOW WARNINGS;
385 --error ER_ROW_IS_REFERENCED_2
386 ALTER TABLE t5 DISCARD TABLESPACE;
387 SHOW WARNINGS;
388
389 --echo #
390 --echo # ALTER TABLE __ DROP FOREIGN KEY
391 --echo #
392 ALTER TABLE t1c DROP FOREIGN KEY t1c2, ALGORITHM=INPLACE;
393 ALTER TABLE t2c DROP FOREIGN KEY t2c2, ALGORITHM=COPY;
394 ALTER TABLE t3c DROP FOREIGN KEY t3c2, ALGORITHM=INPLACE;
395 ALTER TABLE t4c DROP FOREIGN KEY t4c2, ALGORITHM=COPY;
396 ALTER TABLE t5c DROP FOREIGN KEY t5c2, ALGORITHM=INPLACE;
397 ALTER TABLE t6c DROP FOREIGN KEY t6c2, ALGORITHM=COPY;
398
399 --echo #
400 --echo # Cleanup
401 --echo #
402 DROP TABLE t1;
403 DROP TABLE t2;
404 DROP TABLE t3;
405 DROP TABLE t4;
406 DROP TABLE t5;
407 DROP TABLE t6;
408 DROP TABLE t1c;
409 DROP TABLE t2c;
410 DROP TABLE t3c;
411 DROP TABLE t4c;
412 DROP TABLE t5c;
413 DROP TABLE t6c;
414 DROP TABLE t1p;
415 DROP TABLE t2p;
416 DROP TABLE t3p;
417 DROP TABLE t4p;
418 DROP TABLE t5p;
419 DROP TABLE t6p;
420 DROP TABLESPACE ts1;
421
422
423 --disable_query_log
424 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Tablespace for table `test`.`.*` is set as discarded");
425 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Tablespace .*, name '.*', file '.*' is missing");
426 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Cannot calculate statistics for table `test`\.`.*` because the \.ibd file is missing");
427 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Cannot delete tablespace [0-9]+ in DISCARD TABLESPACE: Tablespace not found");
428 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Ignoring tablespace .* because it could not be opened");
429 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Cannot delete tablespace [0-9]+ because it is not found in the tablespace memory cache");
430 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Cannot open datafile for read-only:");
431 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Could not find a valid tablespace file for");
432 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Failed to find tablespace for table `test`.`.*` in the cache");
433 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
434 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Operating system error number 2 in a file operation.");
435 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Tablespace open failed for `test`\.`t`, ignored");
436 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The error means the system cannot find the path specified.");
437 --enable_query_log
438