Auto Reconnect option for Vertiva

Highlighted
Eight 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.

Highlighted
Sixteen Stars
Sixteen 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
Highlighted
Eight 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.

 

Highlighted
Sixteen Stars
Sixteen 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
Highlighted
Sixteen Stars
Sixteen Stars

Re: Auto Reconnect option for Vertiva

Can you share the result?

TRF
Highlighted
Eight Stars

Re: Auto Reconnect option for Vertiva

You mean the error i got.

 

Highlighted
Sixteen Stars
Sixteen Stars

Re: Auto Reconnect option for Vertiva

I mean the result of changing the value for tcp_keepalive_time

TRF
Highlighted
Eight 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.

Highlighted
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.
Highlighted
Eight Stars

Re: Auto Reconnect option for Vertiva

Not Yet.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog