Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.11.1
-
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.