Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-30709

Quartz SQL upgrade regression QRTZ_FIRED_TRIGGERS.IS_UPDATE_DATA

    XMLWordPrintable

    Details

    • 11 status:
      Resolved
    • Conversion Script Required:
      Yes

      Description

      The quartz migration from 1.8 to 2.x required a lot of db changes that are documented on this page
      http://www.quartz-scheduler.org/documentation/quartz-2.x/migration-guide

      Also for creating quartz schema tables in a new install see:
      https://github.com/quartz-scheduler/quartz/blob/master/distribution/src/main/assembly/root/docs/dbTables/tables_oracle.sql

      I do see in their scripts they do not create the IS_UPDATE_DATA in a new install but is in the migration scripts.

      I am leaning towards that the migration guide is wrong an should not have created
      alter table qrtz_fired_triggers add column is_update_data bool;

      2016-04-05 08:22:00,088 ERROR QuartzScheduler_QuartzSchedulerThread org.quartz.core.ErrorLogger - An error occurred while scanning for the next triggers to fire.

      org.quartz.JobPersistenceException: Couldn't acquire next trigger: ORA-01400: cannot insert NULL into ("SAKAI04012016"."QRTZ_FIRED_TRIGGERS"."IS_UPDATE_DATA")

      [See nested exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SAKAI04012016"."QRTZ_FIRED_TRIGGERS"."IS_UPDATE_DATA")

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  jmiller171 Jeb Miller
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code