The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Request Too Large:File Handles Exceeded

vcarusivcarusi
edited June 19 in General Discussion

Hi,
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
65536

/etc/security/limits.conf

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

Thank you,
Veronica

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.