| 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: |