Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Broken pipe error while looking up a MySQL table.

  1. #1

    Default Broken pipe error while looking up a MySQL table.

    When running transform which does a lookup to a mySQL (MyISAM) database, I get this error (Note that I have already increase the net_write_timeout to 1600 in my.cnf):

    ERROR 13-10 16:42:53,466 - stp_SrvPartLkp_to - Because of an error, this step can't continue:

    ERROR 13-10 16:42:53,467 - stp_SrvPartLkp_to - org.pentaho.di.core.exception.KettleDatabaseException:

    Error performing rollback on connection

    No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

     

    ** BEGIN NESTED EXCEPTION **

    com.mysql.jdbc.CommunicationsException

    MESSAGE: Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException

    MESSAGE: Broken pipe

    any ideas?

    We are running:

    - Pentaho 4.0.1 (community edition)
    - java version "1.6.0_24"
    Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
    - MySQL 5.1.52-ius
    - Red Hat Enterprise Linux Server release 5.7

    Thanks,
    Benjamin

  2. #2
    Join Date
    Sep 2011
    Posts
    190

    Default

    I think I'm experiencing the same problem. Here are mentioned some steps that may be of interest: http://forums.pentaho.com/showthread......&highlight=

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

    Default

    The broken pipe errors are MySQL related. For example, did you restart MySQL after changing the timeout value?
    I would Google a bit to search for possible answers.

  4. #4

    Default

    Thanks Matt.

    I knew it was a MySQL error.. but could not identify what it was... anyhow, did some more digging... and found a solution. For anyone that is having the same problem, here's what solved it for me:

    Increase MySQL's wait_timeout via my.cnf/my.ini, or by connecting with a command-line SQL client and entering SET GLOBAL wait_timeout=86400, or some other suitable number of seconds.
    http://stackoverflow.com/questions/3...on-broken-pipe

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.