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 142 milliseconds ago. The last packet sent successfully to the server was 14,468,141 milliseconds ago.

tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Communications link error with MySQL

    Database Administrators | 2 years ago | Codek
    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 142 milliseconds ago. The last packet sent successfully to the server was 14,468,141 milliseconds ago.
  2. 0

    MySql Communications link failure [SOLVED]

    pentaho.com | 1 week ago
    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.

    Root Cause Analysis

    1. java.io.EOFException

      Can not read response from server. Expected to read 45 bytes, read 4 bytes before connection was unexpectedly lost.

      at com.mysql.jdbc.MysqlIO.readFully()
    2. MySQL jdbc
      ResultSetImpl.next
      1. com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3143)
      2. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3653)
      3. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3586)
      4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4131)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      6. com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:2033)
      7. com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:408)
      8. com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:387)
      9. com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7008)
      9 frames
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.getRow(Database.java:2408)
      2. org.pentaho.di.core.database.Database.getRow(Database.java:2389)
      3. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
      4. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      4 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame