Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Request Too Large:File Handles Exceeded

edited June 2019 in General Discussion

I have the following error:

java.sql.SQLTransientException: [Vertica]VJDBC ERROR: Insufficient resources to execute plan on pool my_pool [Request Too Large:File Handles Exceeded: Requested = 28490, Free = 27496 (Limit = 27496, Used = 0)]
at com.vertica.util.ServerErrorData.buildException(Unknown Source)

I obtain this error when I execute
select max(col_1), max(col_2) ....., max(col_1287) from

decreasing the number of columns , the value of 'Requested (File Handles)' decreases, also

What should be done in order to increase the 'Limit = 27496' ?

ulimit -n


    • as unlimited
  • hard nofile 65536
  • soft nofile 65536
    dbadmin - nice 0
    dbadmin - nofile 65536

Thank you,


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.