call mtr.add_suppression("File '.*tablespaces.open..*' size is 0 bytes. Must be at least 12 bytes");
CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
# Kill the server
# Fault 1: Extra file in innodb_data_file_path
# restart
SHOW TABLES;
Tables_in_test
t1
# Recovery and clean shutdown with old data file path
Pattern "\[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option'" found
# Start with new data file path
INSERT INTO t1 VALUES (1);
# Kill the server
# Fault 2: Missing file in innodb_data_file_path
# restart
SHOW TABLES;
Tables_in_test
t1
# Recovery and shutdown with innodb-force-recovery (ignore unknown file)
Pattern "\[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option'" found
# Cleanup
# restart
# No log should be generated while persistent tablespaces are idle
# FIXME: Something occasionally violates this (log_write_requests=1)
CREATE TEMPORARY TABLE t (a SERIAL) ENGINE=InnoDB;
SELECT * FROM t1;
a
1
DROP TABLE t1;
SELECT count>0 FROM information_schema.innodb_metrics
WHERE name='log_write_requests';
count>0
1