"Too many open files...erno24" error

This can happen in Linux environments where the limit of open files per user is set too low. HEAVY.AI recommends using systemd, which avoids this issue. If you need to set this manually, try setting your nofile limit to 50,000 as a starting point for the user that's running the server.

You can set an appropriate value by editing the limit.conf file located in the /etc/security folder, using a privileged user.

For example, if the heavyai is the user running the heavydb and heavy immerse, add the following lines to the file to up the limit to 120000.

heavyai soft nofile 120000
heavyai hard nofile 120000