[resolved] Connection failure on mysqlinput

Highlighted
One Star

[resolved] Connection failure on mysqlinput

Hi,
I have a problem running jobs in command line.
I try to run a job which call other jobs (total of 12 jobs). When i run it using Talend Open Studio, it works, but when i run it in command line, i'm getting this error on a random mysqlinput :
----
Exception in component tMysqlInput_11
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.
Caused by: java.net.ConnectException: Connection timed out
----
Problem is that I get this error on random MysqlInput (sometimes I get this on the first jobs, sometimes on the last, etc... ).
I saw that this could be resolved by increasing "wait_timeout" and "interactive_timeout" => they're already at "28800" so it should be okay. (?)
If you have any idea what could be resolve this, I would be glad to know it Smiley Happy
Thanks.
(Sry for my english, I'm doing my best).

Accepted Solutions
Seventeen Stars

Re: [resolved] Connection failure on mysqlinput

I know this problem:
http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure
is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.

View solution in original post


All Replies
Seventeen Stars

Re: [resolved] Connection failure on mysqlinput

I know this problem:
http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure
is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.

View solution in original post

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 2

Part 2 of a series on Context Variables

Blog

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