Too many open files in system

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Too many open files in system

Post by sarah » Thu Aug 22, 2013 6:52 am

Hello,

When I log into my server as root and then try to su to the dbdmin user, I get the following error:

Code: Select all

[root@vertica-01 ~]# su - dbadmin
su: /bin/bash: Too many open files in system
Is there an easy way to fix this?
Have a GREAT day!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1806
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Too many open files in system

Post by JimKnicely » Fri Aug 23, 2013 1:24 am

Hi,

Issue the Linux ulimit -n command to find out the number of open files.

Example:

Code: Select all

[root@Vertica1 ~]# ulimit -n
1024
You can increase this limit by editing the /etc/security/limits.conf file as root, and adding the lines:
  • * soft nofile <value>
    * hard nofile <value>
Replace <value> with the number of MB of RAM on the host, or 65536, whichever is higher.

Any new shell logins should get the new value!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: Too many open files in system

Post by sarah » Fri Aug 23, 2013 8:17 am

Thanks you, Jim. That worked. I thought that when I installed Vertica it had already made those changes? Weird. But all is well now :) :) :)
Have a GREAT day!

Post Reply

Return to “Vertica and the Operating System”