Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Unable to increase the socketTimeout for a mysql connection

  1. #1

    Default Unable to increase the socketTimeout for a mysql connection

    I am using Pentaho Kettle for ETL using a MySql connnection. I am getting a Communications link Failure error - saying 'The last packet successfully received from the server was 304.613 milliseconds ago' I tried to increase the timeout using the socketTimeout variable and setting it to a higher value but it doesnt help. Strangely, when i try and reduce the value of the socketTimeout variable to a lower value I get the error earlier. So lower value works but value higher than 300 seconds does not..!!

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    I was getting this error in querys in the BI server and it has gotten better after adding ?autoReconnect=true to the JDBC connection so the url parameter looks like this: url="jdbc:mysql://MYHOST:MYPORT/MYDB?autoReconnect=true". Maybe it can work in Kettle too, I haven't needed it for my transformations and jobs but it won't do any harm either.
    Regards

  3. #3

    Default

    Thank you for your response. However adding the autoReconnect variable diid not help.. I still get the same error. I am still not able to understand why a value higher than 300 seconds doesn't work for the socketConnect variable.
    Could this have something to do with the my sql server properties ?

  4. #4
    Join Date
    Aug 2015
    Posts
    313

    Default

    Hello,

    Can you please try in your mysql and let us know value for innodb_lock_wait_timeout value if it is db is InnoDB.

    hope this variable will help us regarding lock or timeout sessions.

    Thank you

  5. #5

    Default

    Hi santhi..

    The db is not InnoDB.. However the value for innodb_lock_wait_timeout is 50

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.