CALL mtr.add_suppression("innodb_open_files should not be greater than the open_files_limit."); CALL mtr.add_suppression("You must raise the value of innodb_open_files in my.cnf! Remember that InnoDB keeps all"); CALL mtr.add_suppression("redo log files and all system tablespace files open for the whole time mysqld is running, and"); CALL mtr.add_suppression("needs to open also some .ibd files if the file-per-table storage model is used. Current open files .*, max allowed open files 1."); CALL mtr.add_suppression("Too many (.*) files stay open while the maximum allowed value would be 1. You may need to raise the value of innodb_open_files in my.cnf."); CALL mtr.add_suppression("Cannot close file ./mysql/tables.ibd, because modification"); CALL mtr.add_suppression("Open files .* exceeds the limit 1"); CALL mtr.add_suppression("Cannot close file"); DROP TABLE IF EXISTS `t1`; # Bug#46922: crash when adding partitions and open_files_limit is reached CREATE TABLE t1 (a INT PRIMARY KEY) PARTITION BY KEY () PARTITIONS 1; INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11); ALTER TABLE t1 ADD PARTITION PARTITIONS 50; SELECT * FROM t1; a 1 10 11 2 3 4 5 6 7 8 9 DROP TABLE t1;