exception in component

[Anonymous]

Hi,
After few hours of running my job, an error message appeared as below :
Exception in component tMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.GeneratedConstructorAccessor3.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:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:465)
at com.mysql.jdbc.PreparedStatement.clearBatch(PreparedStatement.java:1143)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1471)
I did not have any idea regarding the error. Can anyone help me to clarify the matter.
Thanks in advance.
fadh

[Anonymous]

Hi,
I suspect something wrong with your MySQL server. As we known that, the "wait_timeout" is 8 hours in MySQL server by default. That's mean if the DB connection is last for 8 hours without operation, MySQL server will close this connection automatically. You can search this issue on MySQL official website.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Thanks for the reply. Yes, the job did not finish even after 8 hours. The job that I run currently have 30 millions over rows. Do talend has any component which can deploy the job faster?
Thanks,
fadh

[Anonymous]

Hi,
What's the rate of your job? the work flow? which component are you using? Any screenshots will be appreciated.
Best regards
Sabrina

[Anonymous]

Hi,
I am using tMySqlInput and tMysqlOutput.
Below is the screenshot of the job.
thanks,
fadh

[Anonymous]

Hi,
I think the rate of "255.93 rows/s" is not normal. Did you set any sql query in tMySqlInput component? Migrate source table to target one?
Best regards
Sabrina

[Anonymous]

Hi,
Yes I set sql query statement in tMysqlInput component.
Thanks
fadh

[Anonymous]

Hi,
did you mean that I cannot set sql query in tMysqlInput component?
Thanks,
fadh

[Anonymous]

Hi,
You have to set a sql query in tMysqlInput. I meant it may be a complicated one, but it don't affect too much.
For a huge of data, did you check out the option "enable stream on tMysqlInput" and " Extend Insert on tMysqlOutput" which improve job performance.
Best regards
Sabrina

[Anonymous]

Hi,
Yes, I have already check out the option "enable stream on tMysqlInput" and " Extend Insert on tMysqlOutput" before I executed the job.
Thanks,
fadh