The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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