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

Scheduler: missing SQL conversion script in 10

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.1
    • Component/s: Quartz Scheduler
    • Labels:
      None
    • 10 status:
      Resolved

      Description

      DB model of TriggerEvent has been modified since Sakai 10, a column 'serverId' is added to table 'scheduler_trigger_events'. But the according SQL script is not added to sakai_10_0_mysql_conversion.sql and sakai_10_0_oracle_conversion.sql

      So, if an institute update Sakai from 2.9.3 to 10.0 and set auto.ddl=false . After running the conversion script, the table 'scheduler_trigger_events' won't be changed.

      If a user enter the scheduler tool, an error occurs says missing field 'serverId'

      Here is the missing SQL script should be added:
      MySQL:
      ALTER TABLE scheduler_trigger_events ADD COLUMN serverId VARCHAR(255);
      CREATE INDEX schdulr_trggr_vnts_eventTime ON scheduler_trigger_events(eventTime);

      Oracle:
      ALTER TABLE scheduler_trigger_events ADD serverId varchar2(255);
      CREATE INDEX schdulr_trggr_vnts_eventTime ON scheduler_trigger_events(eventTime);

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  gaojun Gao Jun
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code