Seven Stars

Auto Reconnect option for Vertiva

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.

9 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Auto Reconnect option for Vertiva

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.


TRF
Seven Stars

Re: Auto Reconnect option for Vertiva

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.

 

Twelve Stars TRF
Twelve Stars

Re: Auto Reconnect option for Vertiva

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
Twelve Stars TRF
Twelve Stars

Re: Auto Reconnect option for Vertiva

Can you share the result?

TRF
Seven Stars

Re: Auto Reconnect option for Vertiva

You mean the error i got.

 

Twelve Stars TRF
Twelve Stars

Re: Auto Reconnect option for Vertiva

I mean the result of changing the value for tcp_keepalive_time

TRF
Highlighted
Seven Stars

Re: Auto Reconnect option for Vertiva

Hi,

 

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

 

Thanks,

Bharath.

Moderator

Re: Auto Reconnect option for Vertiva

Hello,

Is there any update for your tcp_keepalive_time implement?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Auto Reconnect option for Vertiva

Not Yet.