Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-5317

table names for quartz should be adjusted for case sensitive mysql

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • 4.11.0, 5.8.0
    • None
    • None
    • None

    Description

      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?

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: