Debian Codegraph @

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

raw
1 CREATE TABLE t1 (id INT, PRIMARY KEY (id));
2 INSERT INTO t1(id) values(1);
3 # Shut down mysqld and then move the t1.ibd file to a different directory.
4 # Restart without validation using --skip-innodb-validate-tablespace-paths
5 # restart:--skip-innodb-validate-tablespace-paths --log-error=SEARCH_FILE
6 # Check for the skip validation warning in the log
7 Pattern "\[Note\] \[.*\] Skipping InnoDB tablespace path validation. Manually moved tablespace files will not be detected!" found
8 # Ensure we didn't receive a warning about the missing t1.ibd file
9 Pattern "\[Warning\] \[.*\] Tablespace .*, name 'test/t1', file '.*test.*t1.ibd' is missing!" not found
10 # Restart without validation using --innodb-validate-tablespace-paths=0
11 # restart:--innodb-validate-tablespace-paths=0 --log-error=SEARCH_FILE
12 # Check for the skip validation warning in the log
13 Pattern "\[Note\] \[.*\] Skipping InnoDB tablespace path validation. Manually moved tablespace files will not be detected!" found
14 # Ensure we didn't receive a warning about the missing t1.ibd file
15 Pattern "\[Warning\] \[.*\] Tablespace .*, name 'test/t1', file '.*test.*t1.ibd' is missing!" not found
16 # Restart with validation
17 # restart:--innodb-validate-tablespace-paths=1 --log-error=SEARCH_FILE
18 # Ensure the warning is visible now
19 Pattern "\[Warning\] \[.*\] Tablespace .*, name 'test/t1', file '.*test.*t1.ibd' is missing!" found
20 drop table t1;
21 # restart: