Description 

Publish fails on galaxy.ansible.com

16 May 2022 user report

• user report
  • publishing always fails with:
  • ERROR - Import Task "19445" failed: duplicate key value violates unique constraint "pulp_app_repositoryversion_repository_id_number_07cb5788_uniq"
  • DETAIL:  Key (repository_id, number)=(1, 15696) already exists.
  • Another collectionversion also failed
  • ERROR! Galaxy import process failed: duplicate key value violates unique constraint "pulp_app_repositoryversion_repository_id_number_07cb5788_uniq"
  • DETAIL:  Key (repository_id, number)=(1, 15690) already exists.
• user tried again a couple hours later and it worked
  • User was asked if they kicked off the 2 imports at the same time: "I retried 4.8.1 after it failed and 1.3.14 did run twice in parallel (due to a zuul bug), and the 2.5.9 publish ran parallel to the 1.3.14 publish. but the 4.8.1 publish ran after all other c.g publishes were done (or failed)"

15 Nov 2021

• user report
  • Waiting until Galaxy import task https://galaxy.ansible.com/api/v2/collection-imports/15160/ has completed
  • ERROR! Galaxy import process failed: duplicate key value violates unique constraint "pulp_app_repositoryversion_repository_id_number_07cb5788_uniq"
  • DETAIL:  Key (repository_id, number)=(1, 12263) already exists.
• user retried later and it worked

Steps to Reproduce

Intermittently seen by users. It might be worth testing that if you upload 2 collectionversions at the same time to see if this would reproduce this bug.