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.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web365

  • via pentaho.com by Unknown author, 5 months ago
    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.
  • via Database Administrators by Codek
    , 9 months ago
    Couldn't get row from result set Communications link failure The last packet successfully received from the server was 142 milliseconds ago. The last packet sent successfully to the server was 14,468,141 milliseconds ago.
  • via pentaho.com by Unknown author, 5 months ago
    Error connecting to database: (using class org.gjt.mm.mysql.Driver) 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.
  • Stack trace

    • 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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    10 times, 2 weeks ago
    Once, 1 month ago
    4 times, 1 month ago
    2 times, 1 month ago
    Once, 5 months ago
    19 more bugmates