Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-92

Setup should create the AGENT_URL column when creating the SCHEDULER_HISTORY table

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.11.1
    • 1.11.2, 1.12
    • None
    • Tested on Windows with MariaDB

    Description

      Current Situation

      The setup does not create the AGENT_URL column in the SCHEDULER_HISTORY table.

      • This leads to the following error message in the scheduler.log file (here with a maria db as an example) when JobScheduler starts the first time:
        .18 11:00:47.103 scheduler    0  7192.2600 3631.328MB ..[xc.insert 1, "java.sql.SQLSyntaxErrorException: Unknown column 'AGENT_URL' in 'field list' - caused by - org.mariadb.jdbc.internal.util.dao.QueryException: Unknown column 'AGENT_URL' in 'field list'"]
        
      • This applies for the scheduler.sql and the scheduler_alter.sql scripts for all supported DBMSs.
      • The JobScheduler automatically creates this column itself. So this issue does not affect the operation of the JobScheduler. To avoid the error message at the first start the table should be created completly and correctly during the setup process.

      Desired Behaviour

      The AGENT_URL column should be created as part of the SCHEDULER_HISTORY table.

      Attachments

        Activity

          People

            oh Oliver Haufe
            aa Alan Amos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: