Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Repository TimeOut (MySQL)

  1. #1
    Join Date
    Mar 2006
    Posts
    114

    Post Repository TimeOut (MySQL)

    From yesterday to today was running a JOB using Kettle 3.2 RC1.
    My JOB draws 25 processing during implementation.
    My first implementation processes a TXT file and takes on average 1 day to be processed.
    Following happened when this transformation was completed and my JOB was called the next transformation. This call is not my JOB had more connection to the repository and it was generated the error "timeout".

    I wonder if the Kettle has a parameter that I can configure so that it can "Keep Alive" or other parameters in the database that can increase the time of connection but that is an acceptable value.

    My net_write_timeout this parameter set to 1800, is another parameter called the connect_timeout allowing up to 12hrs (In my case the error happen anyway)

    Thank opniao if any of the case.

    regards,
    Concon

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

    Default

    Start at this : http://wiki.pentaho.com/display/EAI/MySQL

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2006
    Posts
    114

    Question

    Quote Originally Posted by sboden View Post
    Start at this : http://wiki.pentaho.com/display/EAI/MySQL

    Regards,
    Sven
    Configuring a JDBC connection with the "autoReconnect = true", solves the problem?

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

    Default

    Probably not, try reading the wiki page Sven linked to.

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.