Vertica Analytics Platform Version 10.0.x Documentation
System Max Open Files Limit
This topic details how to modify the limit for the number of open files on your system so that it meets Vertica requirements. The installer reports this issue with the identifier: S0120.
Vertica opens many files. Some platforms have global limits on the number of open files. The open file limit must be set sufficiently high so as not to interfere with database operations.
The recommended value is at least the amount of memory in MB, but not less than 65536.
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.
To manually set the open file limit:
/sbin/sysctl fs.file-maxto determine the current limit.
- If the limit is not 65536 or the amount of system memory in MB (whichever is higher), then edit or add
fs.file-max=max number of filesto
sysctl -pto apply the changes in
# Controls the maximum number of open files fs.file-max=65536
These steps will need to be replicated for each node in the cluster.
Was this topic helpful?