Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Problem in Kettle

  1. #1
    Join Date
    Jun 2007
    Posts
    15

    Default Problem in Kettle

    Hello Everyone,

    i'm experiencing a preblom with Kettle and i couldn't where it comes from.

    I'm launching a transformation and it stops with the bug report i've attached;

    Does anyone know about this problem?

    Thank you for your help

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    lol... where's the bug report?

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2007
    Posts
    15

    Default

    Sorry, here is the report :

    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Erreur inattendue 'be.ibridge.kettle.core.exception.KettleDatabaseException:
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Couldn't get row from result set
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException
    MESSAGE: Connection reset

    STACKTRACE:

    java.net.SocketException: Connection reset
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.net.SocketInputStream.read(Unknown Source)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1931)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2433)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:370)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:360)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.ResultSet.next(ResultSet.java:5970)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.getRow(Database.java:3054)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.getRow(Database.java:3036)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.tableinput.TableInput.processRow(TableInput.java:124)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.tableinput.TableInput.run(TableInput.java:290)
    2007/08/22 12:11:59 - Extraction depuis table.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) :

    ** END NESTED EXCEPTION **

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    I think that's a network problem... do you have it always, or only in some cases.

    Regards,
    Sven

  5. #5
    Join Date
    Jun 2007
    Posts
    15

    Default

    I have it everytime i run this transformation. I've tried to run it in several databases even in a local database, but the result is the same...

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    Not the MySQL expert... can you try it with a small set of data, maybe you overrun some mysql limitation.

    Regards,
    Sven

  7. #7
    Join Date
    Jun 2007
    Posts
    15

    Default

    When I limit the number of rows, it works, and it crashes when it reaches a certain number of lines... About 8000. But it takes only about 5 minutes befores it happens.

  8. #8
    Join Date
    May 2006
    Posts
    4,882

    Default

    And here is where I can't help anymore... there are some options on MySQL, but I doubt they will you in this case. You could also possibly try to use another MySQL driver.

    Regards,
    Sven

  9. #9
    Join Date
    Jun 2007
    Posts
    15

    Default

    Actually, it is a problem with the default configuration of a MySQL database, which has parameters that limits the execution time of a query. When I change this parameters, My transformation works.

    Thnak You very much for your Help!

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.