Capsule sync fails with "duplicate key value violates unique constraint "core_repositoryversion_repository_id_number_XXXXX_uniq" error

Issue

• Getting following error when synchronizing Capsule.

  duplicate key value violates unique constraint "core_repositoryversion_repository_id_number_xxxxx_uniq"
  DETAIL:  Key (repository_id, number)=(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, 1) already exists.
  Could not lookup a publication_href for repo 176
  
  insert or update on table "core_repositorycontent" violates foreign key constraint "core_repositoryconte_version_added_id_xxxxx_fk_core_repo"
  DETAIL:  Key (version_added_id)=(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) is not present in table "core_repositoryversion".
  Could not lookup a publication_href for repo 181
  
  insert or update on table "core_repositorycontent" violates foreign key constraint "core_repositoryconte_version_added_id_xxxxx_fk_core_repo"
  DETAIL:  Key (version_added_id)=(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) is not present in table "core_repositoryversion".
  Could not lookup a publication_href for repo 184