Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Communications link failure due to underlying exception

  1. #1

    Default Communications link failure due to underlying exception

    I have been frequently but irregularly receiving this error from my kitchen script. There isn't enough information here to tell me what the problem is. Does anyone have any ideas?

    Code:
    2014/04/01 03:31:09 - RepositoriesMeta - Reading repositories XML file: /var/www/.kettle/repositories.xml
    2014/04/01 03:44:19 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
    2014/04/01 03:44:19 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
    2014/04/01 03:44:19 - Table input.0 - Couldn't get row from result set
    2014/04/01 03:44:19 - Table input.0 - Communications link failure due to underlying exception: 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** BEGIN NESTED EXCEPTION ** 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - STACKTRACE:
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2433)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.ResultSet.next(ResultSet.java:5970)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2290)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2270)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:153)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/04/01 03:44:19 - Table input.0 -     at java.lang.Thread.run(Thread.java:724)
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** END NESTED EXCEPTION **
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - Last packet sent to the server was 100107 ms ago.
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2302)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2270)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:153)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/04/01 03:44:19 - Table input.0 -     at java.lang.Thread.run(Thread.java:724)
    2014/04/01 03:44:19 - Table input.0 - Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** BEGIN NESTED EXCEPTION ** 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - STACKTRACE:
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2433)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.ResultSet.next(ResultSet.java:5970)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2290)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2270)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:153)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/04/01 03:44:19 - Table input.0 -     at java.lang.Thread.run(Thread.java:724)
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** END NESTED EXCEPTION **
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - Last packet sent to the server was 100107 ms ago.
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2592)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.ResultSet.next(ResultSet.java:5970)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.getRow(Database.java:2290)
    2014/04/01 03:44:19 - Table input.0 -     ... 4 more
    2014/04/01 03:44:19 - Extract-<myScriptName>.com - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!
    2014/04/01 03:44:19 - Extract-<myScriptName>.com - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!
    2014/04/01 03:44:19 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: 
    2014/04/01 03:44:19 - Table input.0 - Couldn't close query: resultset or prepared statements
    2014/04/01 03:44:19 - Table input.0 - Communications link failure due to underlying exception: 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** BEGIN NESTED EXCEPTION ** 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - STACKTRACE:
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - java.io.EOFException
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:150)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.ResultSet.realClose(ResultSet.java:6314)
    2014/04/01 03:44:19 - Table input.0 -     at com.mysql.jdbc.ResultSet.close(ResultSet.java:749)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.core.database.Database.closeQuery(Database.java:2098)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.steps.tableinput.TableInput.closePreviousQuery(TableInput.java:218)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:274)
    2014/04/01 03:44:19 - Table input.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:100)
    2014/04/01 03:44:19 - Table input.0 -     at java.lang.Thread.run(Thread.java:724)
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - ** END NESTED EXCEPTION **
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - 
    2014/04/01 03:44:19 - Table input.0 - Last packet sent to the server was 100111 ms ago.

  2. #2

    Default

    I had somerhing similar. I found Out that ist was a Slow query causing this behavior. So I changed the query to make better use of Indexes and that was the Solution.

    The error is misleading. Spent quite some Time tranig other Things, like a different driver, etc

    Give it a try.

    Uwe

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

    Default

    Standard reply to one of the most often asked questions on both this forum AND on the MySQL forum: http://wiki.pentaho.com/display/EAI/MySQL

  4. #4

    Default

    Quote Originally Posted by uwegeercken View Post
    I had somerhing similar. I found Out that ist was a Slow query causing this behavior. So I changed the query to make better use of Indexes and that was the Solution.

    The error is misleading. Spent quite some Time tranig other Things, like a different driver, etc

    Give it a try.

    Uwe
    Thanks, Uwe. I'm doing a "select * from ...", so I don't know how indices would help. It quite possibly is a slow query, though, since the server and DBMS on which I'm running the query is extremely overloaded. Looking at Matt Casters's response, maybe there is a timeout setting I could change???

  5. #5

    Default

    Quote Originally Posted by MattCasters View Post
    Standard reply to one of the most often asked questions on both this forum AND on the MySQL forum: http://wiki.pentaho.com/display/EAI/MySQL
    Thanks, Matt. I did search for hours before I posted here. I'm surprised Google wasn't more of a help.

    Followup question, if you don't mind:

    This is actually occurring on a READ, not a write. I'm doing an extract, reading from MySQL and writing to MS SQL Server, using Kitchen on CentOS. So, I'm wondering whether:
    1. There is a similar READ timeout parameter and
    2. How I would set this for Kitchen.

    Thanks again for your very useful response.

  6. #6

    Default

    Quote Originally Posted by dsa42 View Post
    Thanks, Matt. I did search for hours before I posted here. I'm surprised Google wasn't more of a help.

    Followup question, if you don't mind:

    This is actually occurring on a READ, not a write. I'm doing an extract, reading from MySQL and writing to MS SQL Server, using Kitchen on CentOS. So, I'm wondering whether:
    1. There is a similar READ timeout parameter and
    2. How I would set this for Kitchen.

    Thanks again for your very useful response.
    I'm answering my questions for others who might find this thread. The setting is made on the MySQL Database Server, so it will work with all clients. The "my.ini" file is for windows only. If the MySQL DBMS Server is running on Linux, the configuration file is my.cnf, and is found in /etc.

    More information about the MySQL Server configuration settings are found here:

    https://dev.mysql.com/doc/refman/5.0...variables.html

Tags for this Thread

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.