Error with mysql conecction, on execution time is off.

One Star

Error with mysql conecction, on execution time is off.

hi!.
i have designed threes subjobs for parallelize execution and two of three subjobs working fine but the first no i don´t know why?.
i have a problem with next error:
Communications link failure
The last packet successfully received from the server was 1.329.480 milliseconds ago. The last packet sent successfully to the server was 19.303 milliseconds ago.Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
i tried with additional parameters but don´t working!.
So what can i do? anbody can help me please?. Thanks Best Regards. i have attached a few images.
Highlighted
One Star

Re: Error with mysql conecction, on execution time is off.

Hi
The reason of this issue may be complex.
First, don't share a DB connection here.
Second, try to add Additional JDBC Parameters "autoReconnect=true".
If error still, try to modify mysql max connection time.
Best regards!
Pedro
One Star

Re: Error with mysql conecction, on execution time is off.

hi pedro!
am so thanksfull, but that you say don´t working, i tried with the additional parameters and not works! and the connection to the DB it´s must be shared, and about the time execution i've modiffied the waiting time so the execution time and not works!, i have saw a possibles solutions and all says i have to create a new statistics table from talend "talendStats_DB" that is correct??
if yes how can modify that table or component??
it may be, is an server error?? MySql
or a logical error??
i have talend version TDQ 4.1.3 , mysql version 5, and honestly i have made another job like this and same error, the time execution each job between 20 and 40 minutes, but i have made another job that don´t generate that error! three diferent jobs execute datamigration from Informix to Oracle and mysql catch the exectution statistics.
i have attached another images.
this all the information of error:
Starting job JM_ADDR_STG at 11:48 03/01/2012.
connecting to socket on port 3879
connected
OK
Communications link failure
The last packet successfully received from the server was 1.157.383 milliseconds ago.
The last packet sent successfully to the server was 22.614 milliseconds ago.Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
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.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:404)
at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:4735)
at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4712)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.talendStats_STATSProcess(JM_ADDR_STG.java:34397)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tInformixInput_2Process(JM_ADDR_STG.java:15811)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG$3.run(JM_ADDR_STG.java:4846)
Exception in component tParallelize_1
java.lang.Exception: At least one of the subjobs in tParallelize fails
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tParallelize_1Process(JM_ADDR_STG.java:4899)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tOracleRow_2Process(JM_ADDR_STG.java:4761)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tOracleConnection_2Process(JM_ADDR_STG.java:4636)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tMysqlConnection_1Process(JM_ADDR_STG.java:4348)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG$15.run(JM_ADDR_STG.java:35853)
Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
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.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:404)
at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:4735)
at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4712)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.talendStats_STATSProcess(JM_ADDR_STG.java:34397)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.runJobInTOS(JM_ADDR_STG.java:35913)
at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.main(JM_ADDR_STG.java:35403)
disconnected
Job JM_ADDR_STG ended at 12:09 03/01/2012.
Best Regards.
One Star

Re: Error with mysql conecction, on execution time is off.

sorry here are the images
One Star

Re: Error with mysql conecction, on execution time is off.

Sorry to hear that it still doesn't work.
In fact, when program java, this exception occurs occasionally. Sometimes DB statement closes too early.
But in Talend, the java code generate automatically, which can't be changed.
I am sure it's a java code logic error. Maybe you have to try other workarounds.
Best regards!
Pedro

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download