Vertica Analytics Platform Version 10.0.x Documentation
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.
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
There is also an open file limit on the system. See System Max Open Files Limit.
Was this topic helpful?