Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Problem

Users may observe the following MySQL error:

...

If the connection to the MySQL database was idle for some time without any activity, then MySQL might close the connection without signaling this fact to the JOC Cockpit.

Analysis

  • If a MySQL DBMS is being used then the MySQL wait_timeout setting that rules the max. lifetime of idle connections should be checked and adjusted if required.
  • The default wait_timeout for MySQL might be too short. The JOC Cockpit assumes a connection to be idle for up to 30 minutes before refreshing the connection.

Solution

If a MySQL DBMS is being used by the JobScheduler, then the MySQL wait_timeout setting that rules the max. lifetime of idle connections should be checked and if necessary extended. 

...