User Max Open Files Limit

This topic details how to change the user max open-files limit setting to meet Vertica requirements. The installer reports this issue with the identifier: S0060.

The installer automatically configures the correct setting if the default value does not meet system requirements. If there is an issue setting this value, or you have used the --no-system-configuration argument to the installer and the current setting is incorrect, then the installer reports this as an issue.

Vertica requires that the dbadmin user not be limited when opening files.The open file limit should be at least 1 file open per MB of RAM, 65536, or the amount of RAM in MB; whichever is greater. Vertica sets this to the minimum recommended value of 65536 or the amount of RAM in MB.

All Systems

The open file limit can be determined by running ulimit -n as the dbadmin user. For example:

dbadmin@localhost:$ ulimit -n

To manually set the limit, edit /etc/security/limits.conf and edit/add the line for the nofile setting for the user you configured as the database admin (default dbadmin). The setting must be at least 65536.

dbadmin -       nofile  65536

Note: There is also an open file limit on the system. See System Max Open Files Limit.