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