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
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
Looks like the network link between the Talend process and the Mysql database failed.
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)?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables