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

mariabackup not work with " unsupported by option '--open_files_limit'"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.6
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Environment:
      Centos7 with kernel 4.12.14

      Description

      1. setup MariaDB cluster with galera 4, and the cluster works
      2. failed to execute mariabackup as flow

      [root@node1 ~]# mariabackup
      mariabackup: automatic setup request is unsupported by option '--open_files_limit'
      [root@node1 ~]# mariabackup --help
      mariabackup: automatic setup request is unsupported by option '--open_files_limit'
      [root@node1 ~]# mariabackup --target-dir=/opt --user=root --password=mypassword
      mariabackup: automatic setup request is unsupported by option '--open_files_limit'

      [root@node1 ~]# rpm -qa|grep MariaDB
      MariaDB-server-10.5.6-1.el7.centos.x86_64
      MariaDB-compat-10.5.6-1.el7.centos.x86_64
      MariaDB-backup-10.5.6-1.el7.centos.x86_64
      MariaDB-common-10.5.6-1.el7.centos.x86_64
      MariaDB-client-10.5.6-1.el7.centos.x86_64

      [root@node1 ~]# cd /etc/my.cnf.d/
      [root@node1 my.cnf.d]# ls
      enable_encryption.preset mysql-clients.cnf server.cnf spider.cnf z-abc.cnf
      [root@node1 my.cnf.d]# cat z-abc.cnf

      [mariadb]
      default-storage-engine=INNODB
      default-time-zone='+8:00'
      skip-name-resolve
      wait_timeout=20
      max_connections=5000
       
      # determine a good value for open_files_limit automatically
      autoset_open_files_limit
      max_allowed_packet=1G
       
       
      # Server Configuration
      log_error                = mariadbd.err
      innodb_buffer_pool_size  = 1G
      innodb_log_file_size=64M
      innodb_flush_method=O_DIRECT
      innodb_file_per_table           = 1
       
      # Cluster Configuration
      wsrep_provider           = /usr/lib64/galera-4/libgalera_smm.so
      wsrep_cluster_address="gcomm://192.168.11.178,192.168.11.179,192.168.11.201"
      wsrep_cluster_name       = abcCluster
      wsrep_on                 = ON
       
      binlog_format            = ROW
      innodb_autoinc_lock_mode = 2
       
      wsrep_node_address = 192.168.11.178
      wsrep_sst_method=rsync
       
      [mariabackup]
      open_files_limit=65535
      

      [root@node1 my.cnf.d]#

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            wpf wpf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration