Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
COmanage Registry 4.1.0 (Quiet Quay)
-
None
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
- is related to
-
CO-2383 Cannot create LDAP Provisioner table with MySQL 8.0.1 or later
- Resolved