Auto Reconnect option for Vertiva

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.

Fifteen Stars TRF
Fifteen 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
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.

 

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

Re: Auto Reconnect option for Vertiva

Can you share the result?

TRF
Eight Stars

Re: Auto Reconnect option for Vertiva

You mean the error i got.

 

Fifteen Stars TRF
Fifteen Stars

Re: Auto Reconnect option for Vertiva

I mean the result of changing the value for tcp_keepalive_time

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

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

Re: Auto Reconnect option for Vertiva

Not Yet.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads