Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Lost MySQL Connection

  1. #1
    Join Date
    Aug 2010
    Posts
    6

    Default Lost MySQL Connection

    The process keeps getting disconnected every 5-7 minutes with the following messages. Any idea why the connection keeps getting dropped? Also, what is "Use Result Streaming Cursor" option when setting up the connection?

    I get the error in 4.0.1 and 4.2.

    Thanks!

    2011/02/08 13:24:33 - Spoon - Transformation opened.
    2011/02/08 13:24:33 - Spoon - Launching transformation [Test - Sync mySyncTable]...
    2011/02/08 13:24:33 - Spoon - Started the transformation execution.
    2011/02/08 13:24:33 - Test - Sync mySyncTable - Dispatching started for transformation [Test - Sync mySyncTable]
    2011/02/08 13:24:33 - Transformation metadata - Natural sort of steps executed in {0} ms ({1} time previous steps calculated)
    2011/02/08 13:24:33 - Test - Sync mySyncTable - This transformation can be replayed with replay date: 2011/02/08 13:24:33
    2011/02/08 13:24:40 - Merge Rows (diff).0 - linenr 50000
    2011/02/08 13:24:41 - Master DB.0 - linenr 50000
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Unexpected error
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : org.pentaho.di.core.exception.KettleDatabaseException:
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Couldn't get row from result set
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.net.SocketException
    MESSAGE: Connection reset
    STACKTRACE:
    java.net.SocketException: Connection reset
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at java.net.SocketInputStream.read(SocketInputStream.java:168)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1931)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2433)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.ResultSet.next(ResultSet.java:5970)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.core.database.Database.getRow(Database.java:2731)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.core.database.Database.getRow(Database.java:2716)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:140)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at java.lang.Thread.run(Thread.java:619)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) :
    ** END NESTED EXCEPTION **

    Last packet sent to the server was 389889 ms ago.
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : org.pentaho.di.core.database.Database.getRow(Database.java:2801)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : org.pentaho.di.core.database.Database.getRow(Database.java:2716)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:140)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : java.lang.Thread.run(Thread.java:619)
    2011/02/08 13:31:04 - Master DB.0 - Finished reading query, closing connection.
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Couldn't close query: resultset or prepared statements
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.net.SocketException
    MESSAGE: Connection reset
    STACKTRACE:
    java.net.SocketException: Connection reset
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at java.net.SocketInputStream.read(SocketInputStream.java:113)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1931)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:150)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.ResultSet.realClose(ResultSet.java:6314)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.ResultSet.close(ResultSet.java:749)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.core.database.Database.closeQuery(Database.java:2344)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.steps.tableinput.TableInput.closePreviousQuery(TableInput.java:205)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:261)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at java.lang.Thread.run(Thread.java:619)
    2011/02/08 13:31:04 - Master DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) :
    ** END NESTED EXCEPTION **

    Last packet sent to the server was 389889 ms ago.
    2011/02/08 13:31:04 - Master DB.0 - Finished processing (I=59902, O=0, R=0, W=59901, U=0, E=1)
    2011/02/08 13:31:04 - Test - Sync mySyncTable - Test - Sync mySyncTable
    2011/02/08 13:31:04 - Test - Sync mySyncTable - Test - Sync mySyncTable
    2011/02/08 13:31:04 - Remote DB.0 - Finished reading query, closing connection.
    2011/02/08 13:31:04 - Master DB Insert / Update.0 - Finished processing (I=1645, O=98, R=1645, W=1645, U=0, E=0)
    2011/02/08 13:31:04 - Merge Rows (diff).0 - Finished processing (I=0, O=0, R=79415, W=52204, U=0, E=0)
    2011/02/08 13:31:04 - Switch / Case.0 - Finished processing (I=0, O=0, R=42203, W=15338, U=0, E=0)
    2011/02/08 13:31:04 - Remote DB Insert / Update.0 - Finished processing (I=3692, O=1369, R=3692, W=3691, U=7, E=0)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Couldn't close query: resultset or prepared statements
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.io.EOFException
    STACKTRACE:
    java.io.EOFException
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2433)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:150)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.ResultSet.realClose(ResultSet.java:6314)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at com.mysql.jdbc.ResultSet.close(ResultSet.java:749)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.core.database.Database.closeQuery(Database.java:2344)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.steps.tableinput.TableInput.closePreviousQuery(TableInput.java:205)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:261)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) : at java.lang.Thread.run(Thread.java:619)
    2011/02/08 13:31:05 - Remote DB.0 - ERROR (version 4.2.0-M1, build 14791 from 2011-02-08 02.12.48 by tomcat) :

  2. #2
    Join Date
    Aug 2010
    Posts
    6

    Default

    I think I "solved" it by disabling the result_set_cursor... and then I also found this article by Matt:

    http://wiki.pentaho.com/display/EAI/MySQL

    Will see how it goes.

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.