topic Re: Auto Reconnect option for Vertiva in Talend Studio

Auto Reconnect option for Vertiva

javvaji — Tue, 27 Jun 2017 12:34:12 GMT

Hi,

As i was continuously getting the following error, do we have option like auto reconnect in Additional JDBC Parameters.

Error is:

[FATAL]: local_project.j_sample_0_1.j_Sample - tAsyncOut_tVerticaOutput_1 An existing connection was forcibly closed by the remote host
org.netezza.error.NzSQLException: An existing connection was forcibly closed by the remote host

Thanks,
Bharath.

Re: Auto Reconnect option for Vertiva

TRF — Tue, 27 Jun 2017 14:22:18 GMT

Hi,

You probably have to change tcp_keepalive_time parameter to avoid a connection close while your process is waiting for a response from the db server.

The following command set the keppalive parameter to 30 minutes

echo 1800 > /proc/sys/net/ipv4/tcp_keepalive_time

You may refer to this post from Vertica forum.

Re: Auto Reconnect option for Vertiva

javvaji — Tue, 27 Jun 2017 15:16:07 GMT

As per my understanding to your comment we need to change it in the server where the Netezza was installed.If i am correct. Please correct me if i am wrong.

Thanks,

Bharath.

Re: Auto Reconnect option for Vertiva

TRF — Tue, 27 Jun 2017 15:35:36 GMT

You are right.

Also, as the result is not garanted, save the current value for tcp_keepalive_time to be able to restore it in case the problem is not solved with that.

In case of multi-nodes, do the same thing for each node.

Re: Auto Reconnect option for Vertiva

TRF — Wed, 28 Jun 2017 23:21:45 GMT

Can you share the result?

Re: Auto Reconnect option for Vertiva

javvaji — Thu, 29 Jun 2017 09:29:07 GMT

You mean the error i got.

Re: Auto Reconnect option for Vertiva

TRF — Thu, 29 Jun 2017 21:41:32 GMT

I mean the result of changing the value for tcp_keepalive_time

Re: Auto Reconnect option for Vertiva

javvaji — Fri, 30 Jun 2017 09:59:35 GMT

Hi,

tcp_keepalive_time is not yet implemented. I will let you know once i am done with it.

Thanks,

Bharath.

Re: Auto Reconnect option for Vertiva

Anonymous — Wed, 05 Jul 2017 06:51:30 GMT

Hello,

Is there any update for your tcp_keepalive_time implement?

Best regards

Sabrina

Re: Auto Reconnect option for Vertiva

javvaji — Wed, 05 Jul 2017 13:00:49 GMT

Not Yet.