Hitachi Vantara Pentaho Community Forums
Results 1 to 11 of 11

Thread: EOF reached while reading row

  1. #1
    Join Date
    Aug 2007
    Posts
    8

    Default EOF reached while reading row

    I'm getting a Java error when I'm using the Dimension Lookup/Update step. It seems to happen if I only have a few rows to process and there are will be no new dimension entry from the step (i.e. All the lookup values in the input data match what is already in the dimension).

    I've attached the log of the Transform, as well as the transform. Can anyone help with this? I'm using Kettle 2.5.2. We haven't migrated to 3.0.x because we started development of our ETL scripts before 3.0 was GA, and don't have time in our current release cycle to do the required regression testing that moving to 3.0 would trigger.
    Attached Files Attached Files

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

    Default

    First upgrade to 3.0.1 released yesterday and let us know if you still see problems after that.

  3. #3
    Join Date
    Aug 2007
    Posts
    8

    Default

    How seamless of an upgrade is that? Can I just drop it in place, or do I have to worry about updating my Transforms and Jobs?

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

    Default

    It's a drop in replacement.

  5. #5

    Default

    Hello,
    I have the same problem..in the middle of the transformation de connection to Mysql is closed raising a java.io.EOFException. I've attached the exception...i'm using Kettle 3.01

    Thank you,

    AndresF
    Attached Files Attached Files

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

    Default

    It actually has little to do with Kettle. Search this forum for the exception to see a couple of things to change in the MySQL setup.

    Matt

  7. #7

    Default

    Well Matt, i searched the forum and didn't find anything. Anyway I solved this issue with the help of the guys in ##pentaho: upgrade the mysql jdbc jar to version 5 and tune the net_read_timeout and net_write_timeout

    Hope this help somebody...

    Andres

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

    Default

    Add your comments to http://jira.pentaho.org/browse/PDI-529

    Regards,
    Sven

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

    Default

    Like I said: it's MySQL specific.

  10. #10
    Join Date
    Apr 2008
    Posts
    11

    Default EOF reached while reading row

    We're still using 2.5.2 and have this exact same issue, the only deal is we are using Oracle 10G, not mysql, and this error happens intermittently. If we start the transform running again, it runs fine, so it is a tough one to troubleshoot. I thougth it might be something specific to caching in the dimension step, but changing things around doesn't seem to help. I'm assuming this goes away in future releases, but I thought I'd let others know we see this on more than just MySQL.

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

    Default

    Had it on Oracle once. Changing the JDBC driver helped to reveal an "Unable to extend segment blabla bla by foo" ORA exception in the database. You can get this while reading since you put a lock on the source table. If people insert data into that table (or FK related tables) you could get in trouble that way.
    Either way, it's either a JDBC problem or a server patch level issue.

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.