Uploaded image for project: 'Quartz Scheduler (Historical - Do Not File New Issues Here - See GitHub)'
  1. Quartz Scheduler (Historical - Do Not File New Issues Here - See GitHub)
  2. QTZ-182

When using MSSQLDelegate LOCKS table does not get entries for all the scheduler instances if using default select locks statement

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 2 Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.1
    • Component/s: JDBC JobStores
    • Labels:
      None
    • Terracotta Target:
      Quartz 2.1.0
    • Fixed In Revision:
      1590,1591

      Description

      I am using MS SQL SERVER 2008, I have the following setup:

      1. Set of 2 Schedulers with names A1, A1 running in clustered mode pointing to database (say QuartzDB)
      2. Set of 2 Schedulers with names B1,B1 running in clustered mode pointing to database QuartzDB (same db as (1))

      Since post Quartz 2.0 we have SCHED_NAME columns on all the tables, it seems we can point multiple schedulers both A1s and B1s to the same database.

      1. If I start B1 set of schedulers first, locks table get B1 scheduler entries
      2. If I then start A1 set of schedulers, no new entries are inserted into locks table for A1

      The reverse happens :
      1. If I start set of A1 set of schedulers first, locks table get A1 scheduler entries
      2. If I then start B1 set of schedulers, no new entries are inserted into locks table for B1.

      I think it might have to do with https://jira.terracotta.org/jira/browse/QTZ-151 where "SCHED_NAME" is not part of selectWithLockSQL.

        Attachments

          Activity

            People

            • Assignee:
              jhouse James House
              Reporter:
              gurizbac Gurinder Singh
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: