Talend error

Highlighted
Seven Stars

Talend error

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

 

Highlighted
Ten Stars

Re: Talend error

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

Re: Talend error

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.

 

Highlighted
Ten Stars

Re: Talend error

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?
Highlighted
Seven Stars

Re: Talend error

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)?

-----------------------------------------------------------------------------------------------------------
When you like my answer, please accept it as solution and send some kudos

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