Auto Reconnect option for Vertiva

[javvaji]

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.

[TRF]

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.

[javvaji]

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.

[TRF]

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.

[TRF]

Can you share the result?

[javvaji]

You mean the error i got.

[TRF]

I mean the result of changing the value for tcp_keepalive_time

[javvaji]

Hi,

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

Thanks,

Bharath.

[Anonymous]

Hello,

Is there any update for your tcp_keepalive_time implement?

Best regards

Sabrina

[javvaji]

Not Yet.