Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mysql timeout

  1. #1
    Join Date
    Oct 2016
    Posts
    16

    Default Mysql timeout

    Hi,

    We have to restart every day DB and Pentaho Server in order to work without issues. Issues are related to Scheduler (DB Quartz).

    The error is:

    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


    The last packet successfully received from the server was 30,572,478 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.

    Platform:
    - Linux
    - Pentaho8 (Server1)
    - MariaDB 10.1.32 (Server2)

    Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    This is a "feature" of MySQL and MariaDB databases.
    If there's no communication on the link for a period of time, it will simply and silently close the connection.

    In a way, it's a good thing if you're going through any routers or firewalls (which is arguably a good and safe thing to do!)

    The recommended solution is to wrap MySQL / MariaDB with C3P0


    Hope that helps!

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.