Error when migrating Bitbucket DB from one DBMS to another
プラットフォームについて: 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 は除く
要約
When migrating from Oracle 19c to SQL Server 2019 the following error is seen:
Violation of PRIMARY KEY constraint 'pk_AO_5F844E_SVN_MIRROR_MASTER_NODE'. Cannot insert duplicate key in object 'dbo.AO_5F844E_SVN_MIRROR_MASTER'. The duplicate key value is ( ).
環境
Bitbucket Server/DC 7.19.
原因
The error happens in an Active Objects table. This table really doesn't exist in the default Bitbucket schema. It is related to a third-party plugin called SVN Mirror for Bitbucket Server.
ソリューション
Check if the third-party plugin is in use. If it is not, the table may be empty, so simply uninstall the plugin (which will delete the database table) and try the migration again.
If the plugin is in use and the error persists, you may need to contact plugin support.