Could not increase number of max_open_files to more than 1024 (request: 1835) - Source

Revision: 42380
User: Glenn Baker
Date: 2014-09-22 19:55

Hello I'm new to mariadb and currently establishing openstack.  I'm investigating an issue and I'm hoping the community can help me resolve the following error.  I have increased the limits.conf and restarted mariadb however it doesn't appear to have resolved the problem as suggested in various posts I have read.

Error from log

40917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
140917 15:40:19 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835)

Results of clustercheck

[root@servername~]# clustercheck
HTTP/1.1 200 OK
Content-Type: text/plain
Connection: close
Content-Length: 32

Galera cluster node is synced.

Limits.conf
cat /etc/security/limits.conf

*          soft    nproc   65536
*          hard    nproc   65536
*          soft    nofile  1048576
*          hard    nofile  1048576
*          soft    stack   10240

[root@lservername ~]# pcs cluster status
Cluster Status:
 Last updated: Wed Sep 17 16:08:35 2014
 Last change: Wed Sep 17 16:08:14 2014 via crm_attribute on lshkvm40a
 Stack: corosync
 Current DC: servername (3) - partition with quorum
 Version: 1.1.10-32.el7_0-368c726
 3 Nodes configured
 85 Resources configured

PCSD Status:
  10.25.167.207: Online
  10.25.167.209: Online
  10.25.167.211: Online

mariadb.log

140917 15:40:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140917 15:40:19 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.MVaILy' --pid-file='/var/lib/mysql/lshkvm40a-recover.pid'
140917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
140917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
140917 15:40:19 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835)
/usr/libexec/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later
140917 15:40:21 mysqld_safe WSREP: Recovered position 87e05b4e-3437-11e4-b636-9b7b2bb055fc:1282018
140917 15:40:21 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
140917 15:40:21 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
140917 15:40:21 [Note] WSREP: wsrep_start_position var submitted: '87e05b4e-3437-11e4-b636-9b7b2bb055fc:1282018'
140917 15:40:21 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835)
/usr/libexec/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later
140917 15:40:21 [Note] WSREP: Read nil XID from storage engines, skipping position init
140917 15:40:21 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
140917 15:40:21 [Note] WSREP: wsrep_load(): Galera 3.5(rXXXX) by Codership Oy <info@codership.com> loaded successfully.
140917 15:40:21 [Note] WSREP: CRC-32C: using hardware acceleration.

Thanks for your time and assistance.

Answer

From the [[https://launchpad.net/~maria-discuss|mailing list]]:

with systemd you can just set "LimitNOFILE=infinity"
<<code>>
[root@srv-rhsoft:~]$ cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MariaDB Database
Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service

[Service]
Type=simple
User=mysql
Group=mysql
NoNewPrivileges=yes
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/run/mysqld/mysqld.pid
ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID
Environment="LANG=en_GB.UTF-8"
Restart=always
RestartSec=1
TimeoutSec=300
LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
SysVStartPriority=64
PrivateTmp=true
CapabilityBoundingSet=~CAP_AUDIT_CONTROL CAP_AUDIT_WRITE CAP_DAC_OVERRIDE CAP_NET_ADMIN CAP_NET_BIND_SERVICE
CAP_SETGID CAP_SETUID CAP_SYS_ADMIN CAP_SYS_BOOT CAP_SYS_MODULE CAP_SYS_PTRACE
ReadOnlyDirectories=/etc
ReadOnlyDirectories=/usr
ReadOnlyDirectories=/proc
ReadOnlyDirectories=/sys
ReadOnlyDirectories=/var/lib
ReadWriteDirectories=/var/lib/mysql
InaccessibleDirectories=/boot

InaccessibleDirectories=/home

InaccessibleDirectories=/root

InaccessibleDirectories=/media

[Install]
WantedBy=multi-user.target
<</code>>

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Could not increase number of max_open_files to more than 1024 (request: 1835) - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB