Resolve duplicate key value violates on BitbucketImport
requested to merge 229614-pg-uniqueviolation-error-duplicate-key-value-violates-unique-constraint-3 into master
What does this MR do and why?
While importing a project from BitBucket, and simultaneously creating a new issue via the UI, there is a chance of conflicting IIDs which results in:
- import failure
- error while create new issues
Error described in #229614 (closed)
We introduced a new way of importing issues using a bulk insert. With the new approach, we are handling N+1 queries and reducing a chance of conflicting IIDs.
How to set up and validate locally
- Checkout the current branch
- Click on
New project/repository
button - Integrate your GitLab server with Bitbucket Cloud
- Select
Import project from
and selectBitBucket Cloud
- Select a project with some issues
- Visit the
Issues
page and create a new issue - Validate that all issues are successfully imported
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #229614 (closed)
Edited by Bojan Marjanovic