Exception in component connectionStatsLogs (communication link fail)
The same talend job was working fine in development and QA environment. we deployed it to production today and it failed with the following error message. We try running few Jobs and they all failed with the same error message.
Why it is throwing all the unknownhostexceptions.
Caused by: java.net.UnknownHostException: dwsql (dwsql is our development server, we are running it in production server and using prod contexts, then why it is using and throwing the unknownhostexception for dwsql).
Exception in component connectionStatsLogs
com.mysql.jdbc.exceptions.jdbc4.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 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.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
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.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at dw.job_i_account_0_1.job_i_accountDim.connectionStatsLogsProcess(job_i_accountDim.java:4135)
at dw.job_i_accountdim_0_1.job_i_accountDim.preStaLogConProcess(job_i_accountDim.java:614)
at dw.job_i_accountdim_0_1.job_i_accountDim.runJobInTOS(job_i_accountDim.java:6675)
at dw.job_i_accountdim_0_1.job_i_accountDim.main(job_i_accountDim.java:6478)
Caused by: java.net.UnknownHostException: dwsql
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
at java.net.InetAddress.getAddressFromNameService(Unknown Source)
at java.net.InetAddress.getAllByName0(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 19 more
Exception in component talendStats_DB
java.lang.NullPointerException
at dw.job_i_accountdim_0_1.job_i_accountDim.talendStats_STATSProcess(job_i_accountDim.java:5334)
at dw.job_i_accountdim_0_1.job_i_accountDim.runJobInTOS(job_i_accountDim.java:6687)
at dw.job_i_accountdim_0_1.job_i_accountDim.main(job_i_accountDim.java:6478)
Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.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 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.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
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.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dw.job_i_accountdim_0_1.job_i_accountDim.tMysqlInput_1Process(job_i_accountDim.java:1169)
at dw.job_i_accountdim_0_1.job_i_accountDim.runJobInTOS(job_i_accountDim.java:6695)
at dw.job_i_accountdim_0_1.job_i_accountDim.main(job_i_accountDim.java:6478)
Caused by: java.net.UnknownHostException: dw01
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
at java.net.InetAddress.getAddressFromNameService(Unknown Source)
at java.net.InetAddress.getAllByName0(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 16 more
Exception in component talendStats_DB
java.lang.NullPointerException
at dw.job_i_accountdim_0_1.job_i_accountDim.talendStats_STATSProcess(job_i_accountDim.java:5334)
at dw.job_i_accountdim_0_1.job_i_accountDim.runJobInTOS(job_i_accountDim.java:6723)
at dw.job_i_accountdim_0_1.job_i_accountDim.main(job_i_accountDim.java:6478)
Hi
Which version are you using? From the error message, we see that it is failed to connect to Mysql server from the production server. In the job setting-->extra panel, you are using the 'log&stat' options. So, please check whether you are able to ping to the Mysql server from the production server.
Best regards
Shong
I'm using Data Integration 5.0 and mysql 5.5. yes I can ping to the mysql server from the production server.
I don't use TAC. I export the jobs using commandline and SCP the job to the production server.
In the job setting-->extra panel, you are using the 'log&stat' options. --- I didn't quiet well understand this part.
Thanks
I'm using Data Integration 5.0 and mysql 5.5. yes I can ping to the mysql server from the production server. I don't use TAC. I export the jobs using commandline and SCP the job to the production server.
In the job setting-->extra panel, you are using the 'log&stat' options. --- I didn't quiet well understand this part. Thanks
Sorry, I made a mistake. It is the 'stats & logs' panel, see my screenshot. Can you upload a screenshot of this setting?
Best regards
Shong
I don't even see the stats&logs panel. I'm not using the logcatcher and other options. Here Is what I see Basic Run Debug Run Advanced Settings Target Exec. BTW, can you please tell me how to upload a image. Thanks
Hi
The stats&logs panel is in the Job viewer, if the Job viewer does not appear, go to windows-->show view and open the 'Job' viewer.
To upload a image to your topic:
1. Capture the images onto your local machine.
2. Submit your new post.
3. Edit your post.
4. Upload your images from the 'Image upload' option, see my screenshot.
Best regards
Shong
Hi,
i am getting an error while inserting data into mysql after 1,78,99,434 rows.
i need to read 80 million rows.
following are the error that i got:
Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 968 milliseconds ago. The last packet sent successfully to the server was 64,726,986 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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)
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 biowise_etl_job.populating_bw_1000_genomes_job_0_1.populating_BW_1000_Genomes_Job.tMysqlInput_1Process(populating_BW_1000_Genomes_Job.java:4391)
at biowise_etl_job.populating_bw_1000_genomes_job_0_1.populating_BW_1000_Genomes_Job.runJobInTOS(populating_BW_1000_Genomes_Job.java:9150)
at biowise_etl_job.populating_bw_1000_genomes_job_0_1.populating_BW_1000_Genomes_Job.main(populating_BW_1000_Genomes_Job.java:8990)
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
.
.
.
plz help me to solve this issue.
Thanks and Regards,
Anand Yadav
