Page 1 of 1

Vertica connection timeout error

Posted: Tue Nov 05, 2013 12:39 am
by sree
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?

Re: Vertica connection timeout error

Posted: Tue Nov 05, 2013 1:40 pm
by JimKnicely
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)

Re: Vertica connection timeout error

Posted: Sun Nov 24, 2013 11:08 pm
by sree
Thanks knicely87. I changed the tcp_keepalive_time variable on all the three nodes. Connections are not getting dropped now.