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?
Vertica connection timeout error
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica connection timeout error
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)
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Vertica connection timeout error
Thanks knicely87. I changed the tcp_keepalive_time variable on all the three nodes. Connections are not getting dropped now.