Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28207

Auto-create: Many partitions generate error: Out of resources when opening file './test/' (Errcode: 24 "Too many open files")

    XMLWordPrintable

Details

    Description

      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")
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.