The Vertica Database Forums

Posted: **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:

[root@vertica-01 ~]# su - dbadmin
su: /bin/bash: Too many open files in system

Is there an easy way to fix this?

Posted: **Fri Aug 23, 2013 1:24 am**

Hi,

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

Example:

[root@Vertica1 ~]# ulimit -n
1024

You can increase this limit by editing the /etc/security/limits.conf file as root, and adding the lines:

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!

Posted: **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

Too many open files in system