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

mariabackup - confusing error message when running out of file handles with partitioned MyISAM

Details

    Description

      When having a MyISAM table with many partitions the backup process seems to want to open all the related MYD and MYI partition files and keep them open simultaneously until the full table has been copied.

      Unlike with InnoDB and Aria tables, where a proper "Too many open files" message (or similar) is logged, with MyISAM things fail with just:

      Error on file ./test/t1#P#p513.MYD open during `test`.`t1` table copy

      How to reproduce: create a partitioned MyISAM table as:

      CREATE TABLE `t1` (
        `id` bigint(20) NOT NULL AUTO_INCREMENT,
        PRIMARY KEY (`id`)
      ) ENGINE=MyISAM
       PARTITION BY HASH (`id`)
       PARTITIONS 600;
      

      then try to run mariabackup with an open files limit too small for this:

      mariabackup --backup --user=root --open-files-limit=500
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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