Talend error

Anonymous — Mon, 12 Jun 2017 17:44:09 GMT

I am getting below error and unable to understand anything. Can anyone help?

Starting job WF_Count_New at 12:52 12/06/2017.
 
[statistics] connecting to socket on port 3764
[statistics] connected
Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
 
The last packet successfully received from the server was 56 milliseconds ago.  The last packet sent successfully to the server was 3,704,051 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3715)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3604)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4155)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
      at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:2051)
[statistics] disconnected
      at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:408)
      at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:387)
      at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:165)
      at com.mysql.jdbc.ResultSetImpl.realClose(ResultSetImpl.java:7471)
      at com.mysql.jdbc.ResultSetImpl.close(ResultSetImpl.java:918)
      at local_project.WF_count_new_0_1.WF_Count_New.tMysqlInput_1Process(WF_Count_New.java:4085)
      at local_project.WF_count_new_0_1.WF_Count_New.runJobInTOS(WF_Count_New.java:7279)
      at local_project.WF_count_new_0_1.WF_Count_New.main(WF_Count_New.java:7136)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3161)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3615)
      ... 12 more

Re: Talend error

cterenzi — Mon, 12 Jun 2017 19:55:20 GMT

Looks like the network link between the Talend process and the Mysql database failed.

Re: Talend error

Anonymous — Tue, 13 Jun 2017 02:39:47 GMT

How do i fix this? I got this multiple times and even restarted the server where i am using it. The server even has 61GB RAM

@cterenzi wrote:
Looks like the network link between the Talend process and the Mysql database failed.

Re: Talend error

cterenzi — Tue, 13 Jun 2017 14:10:20 GMT

Does this happen consistently? Is it always the same error message? How long does your query run? Does the same query run to completion in an external SQL tool?

Re: Talend error

Aukema — Tue, 13 Jun 2017 14:14:23 GMT

Are you using a database connection component? Could it be that you close the connection (name) from another (sub)process. For example after an itteration and commit (and close connection)?

topic Re: Talend error in Talend Studio

Talend error

Re: Talend error

Re: Talend error

Re: Talend error

Re: Talend error