Sync of community repository on Private Automation Hub fails with error "duplicate key value violates unique constraint \"unique_is_highest\".
Issue
- 
When attempting to sync the Community repository in the Private Automation Hub after upgrading to AAP 2.4, the following error occurs:
duplicate key value violates unique constraint \"unique_is_highest\"\nDETAIL: Key (collection_id, is_highest)= (pulp_id, t) already exists.\n" 
Environment
- Red Hat® Ansible Automation Platform 2.4
 - Red Hat® Ansible Automation Hub > 4.7.1
 
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.