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!

Stuck in socketRead0 Vertica JDBC

I have a rocess that got stuck with this stack trace:

"Timer-3" #110 prio=5 os_prio=0 tid=0x00007fa2520dd000 nid=0x3a1e runnable [0x00007fa176af6000]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)

        at java.net.SocketInputStream.read(SocketInputStream.java:170)

        at java.net.SocketInputStream.read(SocketInputStream.java:141)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:265)

        - locked <0x00000002dc138f38> (a java.io.BufferedInputStream)

        at com.vertica.io.VStream.ReceiveChar(Unknown Source)

        ...

It appears to be waiting for Vertica to respond, however when I look at the connection in Vertica I find no listing for a connection from this machine.

 

Is there a way to set a socket timeout on connections via the Vertica JDBC driver configuraiton?

Leave a Comment

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