Migrator Import creates duplicate certificates

[KennethBates]

Prerequisites

• [x] I have verified the problem exists in the latest version
• [x] I have searched open and closed issues to make sure it isn't already reported
• [x] I have written a descriptive issue title
• [x] I have linked the original source of this report
• [x] I have labelled the value stream (area/core, area/steps, ...)
• [x] I have tagged the issue appropriately (kind/bug, kind/enhancement, feature/ ...)

The bug

Partial-export will export a single project and all its dependencies, including certificates. When importing this project, there's no check that the certificate in the export files already exist on the destination before importing. Instead it'll import into the destination leading to a duplicate certificate. This can lead to performance issues after enough time, as described in the source report.

What I expected to happen

Import would detect the existing cert on the destination server and ignore it, in the same way export/import feature will detect this and not import a duplicate.

Steps to reproduce

1. partial-export a project that has a certificate variable tied to a cert
2. import this project multiple times on the destination server
3. Notice the duplicate certificates in Library > Certificates on the destination server.

Affected versions

Reproduced in 2021.1.7595 and reported in 2021.1.7500

Workarounds

Export/import projects feature won't create duplicate certificates.

Links

Report: https://octopus.zendesk.com/agent/tickets/72289 (private)

[calverp]

We've got another report of this issue that is blocking their Octopus instance sync process due to attempting to re-add 500 duplicate certificates (and adding 24 hours+ to the time required).