|
If a lot of partitions are quickly generated (>500) with engine=Aria, then the test fails with an error "Too many open files":
-- source include/have_partition.inc
|
|
create table t1 (x int) engine=Aria with system versioning
|
partition by system_time limit 1 auto;
|
|
delimiter //;
|
create procedure dowhile()
|
begin
|
declare i int default 1;
|
|
while i <= 500 DO
|
insert into t1 values (i);
|
delete from t1 where x=i;
|
set i = i + 1;
|
end while;
|
end//
|
delimiter ;//
|
call dowhile;
|
|
drop procedure dowhile;
|
drop table t1;
|
Error:
mysqltest: At line 18: query 'call dowhile' failed: <Unknown> (23): Out of resources when opening file './test/' (Errcode: 24 "Too many open files")
|
|