Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2587

Upgrade to 4.1.0 from 4.0.2 fails for deployments using MySQL

    XMLWordPrintable

Details

    Description

      When upgrading a 4.0.2 deployment of Registry using MySQL 5.7.12 to version 4.1.0 the upgradeVersion command fails with

      Adding default duplicate_mode for EnvSource
      Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'EnvSource.duplicate_mode' in 'field list'
      #0 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute()
      #1 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute()
      #2 /srv/comanage-registry/lib/Cake/Model/Datasource/Database/Mysql.php(425): DboSource->execute()
      #3 /srv/comanage-registry/lib/Cake/Model/Model.php(2672): Mysql->update()
      #4 /srv/comanage-registry/app/Console/Command/UpgradeVersionShell.php(615): Model->updateAll()
      #5 /srv/comanage-registry/app/Console/Command/UpgradeVersionShell.php(296): UpgradeVersionShell->post410()
      #6 /srv/comanage-registry/lib/Cake/Console/Shell.php(464): UpgradeVersionShell->main()
      #7 /srv/comanage-registry/lib/Cake/Console/ShellDispatcher.php(222): Shell->runCommand()
      #8 /srv/comanage-registry/lib/Cake/Console/ShellDispatcher.php(66): ShellDispatcher->dispatch()
      #9 /srv/comanage-registry/app/Console/cake.php(41): ShellDispatcher::run()
      #10 {main} 

      Inspecting the table cm_env_sources shows that despite the equivalent of ./Console/cake database being run and it logging that the EnvSource plugin has been processed, the column duplicate_mode has not been added to the table.

      Subsequent runs of ./Console/cake database that also log that the EnvSource plugin has been processed do NOT add the column to the database.

      Attachments

        Issue Links

          Activity

            People

              arlen.johnson@at.internet2.edu Arlen Johnson (google.com)
              scott.koranda@at.internet2.edu Scott Koranda (uwm.edu/illinois.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: