Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-373

"lock wait timeout exceeded" while executing fact plugin executeDailyPlan

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.11
    • 1.11.4
    • None

    Description

      Current Situation

      Sometimes when running the fact plugin an error occured

      ERROR java.lang.Exception: executeDailyPlan: com.sos.hibernate.exceptions.SOSHibernateSessionException: could not execute statement: 1205 Lock wait timeout exceeded; try restarting transaction [n/a]
      at com.sos.jitl.reporting.plugin.FactEventHandler.executeDailyPlan(FactEventHandler.java:243)
      at com.sos.jitl.reporting.plugin.FactEventHandler.execute(FactEventHandler.java:117)
      ....
      

      Possible Cause

      An earlier JobScheduler version has been updated to 1.11.x and the config/live/sos folder contains the job CheckDaysSchedule in the $scheduler_data/config/live/sos/dailyschedule. This job must be removed manually by the customer.

      Desired Behavior

      Fact plugin should rerun executeDailyPlan if the Lock wait timeout exceeded exception occurs.

      Attachments

        Activity

          People

            re Robert Ehrlich
            re Robert Ehrlich
            Uwe Risse Uwe Risse
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: