Upgrading Crowd fails with The object DF_cwd_appliremot_14270015 is dependent on column remote_address_mask
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
要約
The column from the error was removed in Crowd 2.6 and shouldn't exist in any newer version. This KB will treat a problem where this column wasn't dropped during the upgrade process and errors out.
環境
Any instance that upgraded Crowd to a version later than 2.6 but the column still exists.
診断
Upgrading Crowd will show the error in the UI and can be further confirmed by checking the atlassian-crowd.log file for the following error:
2021-06-26 15:23:23 fatal Error while trying to initialise Crowd Container. liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/bootstrap/04_cwd_application.xml::CWD-3017-2::crowd: Reason: liquibase.exception.DatabaseException: The object 'DF_cwd_appliremot_14270015' is dependent on column 'remote_address_mask'. [Failed SQL: ALTER TABLE [dbo].[cwd_application_address] DROP COLUMN [remote_address_mask]]As seen in CWD-3017 - Getting issue details... STATUS , this column was removed in version 2.6.
原因
The column wasn't dropped during the upgrade task.
ソリューション
Drop the column from the error remote_address_mask and run the upgrade again.