Vertica connection timeout error

Moderator: NorbertKrupa

Post Reply
sree
Newbie
Newbie
Posts: 2
Joined: Mon Nov 04, 2013 2:54 am

Vertica connection timeout error

Post by sree » Tue Nov 05, 2013 12:39 am

Hi,

Has anyone seen an issue where the client applications getting disconnected from Vertica database after being idle for a period of time?

We have an ETL process that runs for a long time (more than an hour) and finally it gets failed with the below error.

Error:java.sql.SQLException: [Vertica][VJDBC](100024) IOException while communicating with server: Broken pipe

It looks like the connection is getting closed due to inactivity. Do we have an option to increase the idle query processing time?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Vertica connection timeout error

Post by JimKnicely » Tue Nov 05, 2013 1:40 pm

Hi,

I do not think there are any Vertica parameters that control session timeouts.

See if one of these links helps:

viewtopic.php?f=43&t=1137 (Eliminating the ssh client timeout)

viewtopic.php?f=20&t=252 (Connection reset by peer)
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

sree
Newbie
Newbie
Posts: 2
Joined: Mon Nov 04, 2013 2:54 am

Re: Vertica connection timeout error

Post by sree » Sun Nov 24, 2013 11:08 pm

Thanks knicely87. I changed the tcp_keepalive_time variable on all the three nodes. Connections are not getting dropped now.

Post Reply

Return to “JDBC”