Vertica connection timeout error
Posted: 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?
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?