Too many open files error - VJDBC 100176

Dave_2Dave_2
in General Discussion
We're currently seeing the following error: [Vertica][VJDBC](100176) Failed to connect to host XXX on port 5433. Reason: Too many open files Is this an indication of not enough files on the client or the server? I assume client, but want to confirm. Thanks in advance.

Comments

  • [Deleted User][Deleted User]
    The problem is most likely on the server side. Check the unlimit -n setting as your dbadmin user on the machine running Vertica.
  • Dave_2Dave_2
    Thanks, Amy. It appears that the problem was actually on the client side. The ulimit value on our client machine was only 1024; however, each node in our cluster was already at 65536.
  • [Deleted User][Deleted User]
    Thanks for the update Dave. In the future we will make sure we recommend to check both sides.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...