One Star

Communications link failure

Hi everyone,
I am newbie of TOS.
I use TOS to extract data from text file to mysql database.
but, I have this error(below).
Does anyone know the solution of this error.
Thx, for all the responses.
_____________________________________________________________________________________
Starting job ETL_Transaksi at 11:10 01/11/2007.
Exception in component tMysqlInput_3
Exception in component tMysqlInput_3
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2357)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1295)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2262)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:439)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1727)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
at salessupport.etl_transaksi.ETL_Transaksi.tMysqlInput_3Process(ETL_Transaksi.java:6931)
at salessupport.etl_transaksi.ETL_Transaksi.tFileInputPositional_1Process(ETL_Transaksi.java:5640)
at salessupport.etl_transaksi.ETL_Transaksi.main(ETL_Transaksi.java:10335)

** END NESTED EXCEPTION **

Last packet sent to the server was 375218 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1295)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2262)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:439)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1727)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
at salessupport.etl_transaksi.ETL_Transaksi.tMysqlInput_3Process(ETL_Transaksi.java:6931)
at salessupport.etl_transaksi.ETL_Transaksi.tFileInputPositional_1Process(ETL_Transaksi.java:5640)
at salessupport.etl_transaksi.ETL_Transaksi.main(ETL_Transaksi.java:10335)
Job ETL_Transaksi ended at 11:16 01/11/2007.
8 REPLIES
Community Manager

Re: Communications link failure

Hi Mr.e
Can you upload a screenshot about your job and a screenshot of properties panel of tMysqlInput ?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Communications link failure

Below is the desain and the properties.
thx
Best regard
Mr.E
One Star

Re: Communications link failure

Hi all,
I use TOS on the other server that has 1 GB memory(before that I use server that has 512 MB memory), and it works for 1 million row.(java.exe ate average 600 MB to 700 MB memory, TOS ate more than 200 MB memory)
But the error {Communication link Error} come again when it process 1.1 million row.
Is TOS can be configured to use the just for available memory?
I mean if the memory is not enough it will use that memory although that would make longer to process.
Thx.For the responses
Employee

Re: Communications link failure

Hello,
There are absolutely no relations betweenCommunications Link failure and memory.
In most of the cases, it's related 1) to wait time_out exceeded (see your MySQL configuration)
2) to network problems
Best regards,
One Star

Re: Communications link failure

Hi mhirt,
Where should i find wait time_out configuration?
I did find it on the my.ini of mysql and parameter which i saw on mysql administrator, but i did not find it.
thx 4 ur answer
One Star

Re: Communications link failure

I found it.
But I could not change it.
How to set auto reconnect on TOS?
Community Manager

Re: Communications link failure

Hi
I think it's impossible to auto reconnect database on TOS now. Can you connect to your MySQL in Metadata on TOS?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Communications link failure

Hello,
There are absolutely no relations betweenCommunications Link failure and memory.
In most of the cases, it's related 1) to wait time_out exceeded (see your MySQL configuration)
2) to network problems
Best regards,

Mhirt,
I already change the wait timeout with 68800.
But the error came out again.