Communications link failure

Anonymous — Sat, 16 Nov 2024 05:50:01 GMT

Hi,
I'm currently following this tutorial: https://help.talend.com/reader/q23BCE3W4MjloHD1RvMJ4A/53ZgjRgRIZBxKLOrSTD_CA?section=mlelandais-20120329-esb-trestrequest-scenario2
And I am at the 1st step called "save and execute job" but I am encoutering an error and can not figure out how to solve it.. Thanks in advance for the help!

Cordially.

Here are the logs:

Endpoint deployed at: http://localhost:8088/users
[statistics] connecting to socket on port 3456
[statistics] connected
Exception in component tDBOutput_1 (JobWebService)
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at webservicerest.jobwebservice_0_1.JobWebService.tFixedFlowInput_1Process(JobWebService.java:1195)
at webservicerest.jobwebservice_0_1.JobWebService.runJobInTOS(JobWebService.java:3429)
at webservicerest.jobwebservice_0_1.JobWebService.main(JobWebService.java:3278)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
... 8 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
... 11 more
[statistics] disconnected

Re: Communications link failure

vapukov — Thu, 16 May 2019 04:06:49 GMT

HI,

you have a database connection error, so you need to check:

do you have a prepared database server (and database and tables)?
do you use proper credentials?
do you use proper connection settings?
can you access this server with this credentials from this PC without Talend?

cheers

Re: Communications link failure

Anonymous — Tue, 28 Jan 2020 09:07:11 GMT

Hi,

Im facing the same issue.

My job is working fine for 1 yr data, however when i pass 2yrs i get this error.

Appreciate if you can help on this.

Re: Communications link failure

vapukov — Tue, 28 Jan 2020 10:07:12 GMT

Hi mahadev!

it is not possible to tell exactly what you need to change without knowing your job design!

usually, it happens when you define connection at the begin of the job and use it first time at the end, when a long time delay between opening connection and using it.

the solution could be:

define connection right before use it
or use connection settings right in the component

regards, Vlad

Re: Communications link failure

Anonymous — Wed, 29 Jan 2020 10:17:32 GMT

Hi Vapukov,

Appreciate your response, Will try the DB connection again right before the component and test it.

topic Re: Communications link failure in Installing and Upgrading

Communications link failure

Re: Communications link failure

Re: Communications link failure

Re: Communications link failure

Re: Communications link failure