Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: MySql Communications link failure [SOLVED]

  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Default MySql Communications link failure [SOLVED]

    Hi,

    Frequently , I have this Mysql error,
    the transformation cancel,
    but when I launch again the transformation, its runs fine

    Do you have any idea ?
    I already change the timeout
    but the issue still happen

    INFO 08-04 03:24:48,084 - ADM_0014 - Extract Rows - Loading transformation from repository [ADM_0014 - Extract Rows] in directory [/LOAD/STG/Transformations]




    INFO 08-04 03:25:21,951 - ADM_0014 - Insert rows - linenr 150000
    ERROR 08-04 03:25:43,291 - ADM_0014 - Select rows - Unexpected error
    ERROR 08-04 03:25:43,291 - ADM_0014 - Select rows - org.pentaho.di.core.exception.KettleDatabaseException:
    Couldn't get row from result set
    Communications link failure


    The last packet successfully received from the server was 15,483 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.


    at org.pentaho.di.core.database.Database.getRow(Database.java:2796)
    at org.pentaho.di.core.database.Database.getRow(Database.java:2768)
    at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


    The last packet successfully received from the server was 15,483 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
    at sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
    at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1433)
    at com.mysql.jdbc.MysqlIO.fetchRowsViaCursor(MysqlIO.java:4714)
    at com.mysql.jdbc.RowDataCursor.fetchMoreRows(RowDataCursor.java:412)
    at com.mysql.jdbc.RowDataCursor.hasNext(RowDataCursor.java:318)
    at com.mysql.jdbc.RowDataCursor.next(RowDataCursor.java:358)
    at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7165)
    at org.pentaho.di.core.database.Database.getRow(Database.java:2784)
    ... 4 more
    Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
    ... 14 more


    ERROR 08-04 03:25:43,293 - ADM_0014 - Extract Rows - Errors detected!
    ERROR 08-04 03:25:43,293 - ADM_0014 - Extract Rows - Errors detected!




    ERROR 08-04 03:25:43,298 - ADM_0014 - Extract Rows - org.pentaho.di.core.exception.KettleDatabaseException:
    Error cancelling statement
    Unknown thread id: 88280


    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639)
    at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
    at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293)
    at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
    at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2244)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:64)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: java.sql.SQLException: Unknown thread id: 88280
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    at com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:601)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
    at com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:421)
    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
    ... 6 more


    INFO 08-04 03:25:43,298 - ADM_0014 - Select rows - Finished reading query, closing connection.
    ERROR 08-04 03:25:43,298 - ADM_0014 - Select rows - Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
    Couldn't close query: resultset or prepared statements
    Communications link failure


    The last packet successfully received from the server was 15,490 milliseconds ago. The last packet sent successfully to the server was 8 milliseconds ago.


    ERROR 08-04 03:25:43,303 - ADM_0014 - Extract Rows - Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
    Error cancelling statement
    Unknown thread id: 88280




    ERROR 08-04 03:25:43,303 - ADM_0014 - Extract Rows - org.pentaho.di.core.exception.KettleDatabaseException:
    Error cancelling statement
    Unknown thread id: 88280


    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639)
    at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
    at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293)
    at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
    at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1036)
    at org.pentaho.di.job.Job.execute(Job.java:503)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:420)
    at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:63)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: java.sql.SQLException: Unknown thread id: 88280
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    at com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:601)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
    at com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:421)
    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
    ... 11 more




    ERROR 08-04 03:25:43,308 - ADM_0014 - Extract Rows - Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
    Error cancelling statement
    Unknown thread id: 88280


    ERROR 08-04 03:25:43,308 - ADM_0014 - Extract Rows - org.pentaho.di.core.exception.KettleDatabaseException:
    Error cancelling statement
    Unknown thread id: 88280


    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639)
    at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
    at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293)
    at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
    at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2244)
    at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:270)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: java.sql.SQLException: Unknown thread id: 88280
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    at com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:601)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
    at com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:421)
    at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
    ... 7 more


    ERROR 08-04 03:25:43,308 - MTX - Error disconnecting from database:


    Error comitting connection
    Communications link failure during commit(). Transaction resolution unknown.




    ERROR 08-04 03:25:43,308 - MTX - org.pentaho.di.core.exception.KettleDatabaseException:
    Error comitting connection
    Communications link failure during commit(). Transaction resolution unknown.


    at org.pentaho.di.core.database.Database.commit(Database.java:711)
    at org.pentaho.di.core.database.Database.commit(Database.java:680)
    at org.pentaho.di.core.database.Database.disconnect(Database.java:571)
    at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    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:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1664)
    at org.pentaho.di.core.database.Database.commit(Database.java:700)
    ... 5 more

  2. #2
    Join Date
    Mar 2013
    Posts
    2

    Default

    I also get that error ( a lot ).
    Any hints are welcome.
    I'm using a tokutek version of mysql: 5.1.61-log MySQL Community Server (GPL) (6.5.0-48167)
    and the mysql-connector-java-5.1.23-bin.jar

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Last edited by MattCasters; 04-16-2013 at 08:46 AM.

  4. #4
    Join Date
    Mar 2013
    Posts
    2

    Default

    thanks
    I've changed the value for net_write_timeout and it is ok now

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.