table names for quartz should be adjusted for case sensitive mysql

XMLWordPrintable

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Minor
    • 4.11.0, 5.8.0
    • Affects Version/s: None
    • Component/s: None
    • None

      Josh Grier
      13 hours ago
      Attempting to upgrade from 2.6.19 to 4.10.3 and our daemon container is having a lot of issues that appear to be related to case sensitivity with table names. The container successfully connects to the DB at startup (MariaDB 10.6) but our logs are showing a lot of errors "ERROR GrouperLoaderJob.execute(348) - [] - Error running up job. Table 'grouper.grouper_qz_fired_triggers' doesn't exist". Similarly, if we try to open the daemon status page from the UI we get errors because it is unable to find some of the 'grouper_qz_*' tables. The tables are all still there but the names are partially all caps which seems to be causing problems with the SQL statements using all lower case. Has anyone dealt with this before and have any advice?

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: