Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1043

Database timeout causes wrong results auf <show_job/> (MySQL)

    XMLWordPrintable

Details

    Description

      If the database connection timed out the history entries from the database are not provided in the xml response of a <show_job/> request:

      <show_job job="jobname" max_task_history="10" what="task_history"/>

      A java.sql.SQLNonTransientConnectionException is thrown instead.

      See attachements for samples:

      • show_job_ok.xml: Result of the command above before database timed out.
      • show_job_error.xml: Result of the command above after database timed out.

      This behaviour was observed with MySQL, probably it applies to other databases, too.

      See http://sourceforge.net/apps/mediawiki/jobscheduler/index.php?title=MySQL_wait_timeout for a workaround.

      Attachments

        1. show_job_error.xml
          1 kB
          Stefan Schädlich
        2. show_job_ok.xml
          2 kB
          Stefan Schädlich

        Activity

          People

            oh Oliver Haufe
            ss Stefan Schädlich (Inactive)
            Stefan Schädlich Stefan Schädlich (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: