Upgrade 2.4.0 => 4.17.3 : missing grouper_sync_dep_group_group relationship

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Minor
    • 4.17.5, 5.16.0
    • Affects Version/s: 2.4.0
    • Component/s: grouperInstaller
    • None
    • Environment:
      Migrating to Docker Swarm

      We are currently running Grouper 2.4.0 installed in a VM to Grouper 4.4.17.3 in Swarm environment.

       

      We have this environment variable set to manage automatic upgrade of the database :

      {{}}

      GROUPER_AUTO_DDL_UPTOVERSION=v4.*.*

      {{}}

      {{}}

      During the upgrade we got this error :

      {{}}

      Error on upgrade tasks: java.lang.RuntimeException: Error finding metadata for 'select * from grouper_sync_dep_group_group where 1!=1' in database: 'grouper',
      Upgrade task 8
      ...
              at edu.internet2.middleware.grouper.app.upgradeTasks.UpgradeTaskV8.updateVersionFromPrevious(UpgradeTaskV8.java:48)
      ...
      Caused by: org.postgresql.util.PSQLException: ERREUR: la relation « grouper_sync_dep_group_group » n'existe pas 

      This issue mentions the missing tables :  https://todos.internet2.edu/browse/GRP-5302

      I ended up creating the missing tables and indexes manually and restarted the container. The rest of the database upgrade process succeeded.

      {{}}

      {{}}

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

              Created:
              Updated:
              Resolved: