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.
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
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,
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
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.
