maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "MariaDB community" by glennbaker1:
--------------------------------
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@xxxxxxxxxxxxx> loaded successfully.
140917 15:40:21 [Note] WSREP: CRC-32C: using hardware acceleration.


Thanks for your time and assistance.

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/could-not-increase-number-of-max_open_files-to-more-than-1024-request-1835/