⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
max_parts
/
t
/
View File Name :
partition_open_files_limit.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc --source include/have_myisam.inc --source include/not_windows.inc --source include/have_partition.inc 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("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 7 exceeds the limit 1"); --disable_warnings DROP TABLE IF EXISTS `t1`; --enable_warnings # On some platforms the lowest possible open_files_limit is too high... let $max_open_files_limit= `SELECT @@open_files_limit > 1024`; if ($max_open_files_limit) { skip Need open_files_limit to be lower than 1025; } --echo # Bug#46922: crash when adding partitions and open_files_limit is reached # # Note: # The test script ask for open_files_limit=5 # The server silently increase that to 5000 before asking the OS. # The OS may (or may not) reduce/increase open_files_limit, typically to 1024 # (Linux, see 'ulimit -n') # So, for the ADD PARTITIONS to really reach the 'Too many open files' # error, the test script attempts 600 partitions. # CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=MyISAM PARTITION BY KEY () PARTITIONS 1; INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11); --echo # if the bug exists, then crash will happen here --replace_regex /file '.*'/file '<partition file>'/ --error 23 ALTER TABLE t1 ADD PARTITION PARTITIONS 600; --sorted_result SELECT * FROM t1; DROP TABLE t1;