[MDEV-25446] mariabackup not work with " unsupported by option '--open_files_limit'" Created: 2021-04-19  Updated: 2021-04-27

Status: Open
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.5.6
Fix Version/s: None

Type: Bug Priority: Major
Reporter: wpf Assignee: Unassigned
Resolution: Unresolved Votes: 0
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]#



 Comments   
Comment by Anton Demenev [ 2021-04-27 ]

Hi!
We are experienced same issue on similar server setup.

It caused if mariabackup check options process found system restrictions for flags from config.
We avoided this error by removing autoset_open_files_limit option.

Generated at Thu Feb 08 09:37:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.