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

mariabackup SST fails, open-files-limit limited by that of mysqld

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.12
    • 10.4
    • Galera SST, mariabackup
    • None
    • gentoo gnu/linux

    Description

      0) galera cluster of three nodes
      1) config:
      [mysqld]open_files_limit is unset, i.e. using the default calculated value
      [mysqld]wsrep_sst_method=mariabackup
      [mariabackup]open-files-limit = 35000
      2) cat /proc/<pid of mysqld>/limits | grep files
      Max open files 10640 10640 files
      3) find /var/lib/mysql -type f | wc -l
      31303
      4) start SST - it fails - /var/lib/mysql/mariabackup.backup.log on the donor says:
      [00] 2020-04-12 13:33:13 open files limit requested 35000, set to 10640
      ...
      2020-04-12 13:33:25 0 [ERROR] InnoDB: Operating system error number 24 in a file operation.
      2020-04-12 13:33:25 0 [ERROR] InnoDB: Error number 24 means 'Too many open files'

      [mariabackup]open-files-limit is limited by the current limit of mysqld during SST. Seems like a bug.

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            apurkrt Adam Purkrt
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.