Publishing a new version of a Content View in Red Hat Satellite 6 fails with an error duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"

Solution Verified - Updated -

Issue

  • Publishing a new version of a Content View fails with the following traceback:

    Jan 24 15:39:23 nodename pulpcore-worker-6: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Starting task cd1693d0-8a15-4b95-a6f6-c431fb376865
    Jan 24 15:39:23 nodename pulpcore-api: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]:  - - [24/Jan/2022:20:39:23 +0000] "POST /pulp/api/v3/repositories/rpm/rpm/376c26da-1fd7-41ef-b33e-071908c17d1f/modify/ HTTP/1.1" 202 67 "-" "OpenAPI-Generator/3.13.3/ruby"
    Jan 24 15:39:23 nodename pulpcore-worker-8: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Task 3f572446-f9c4-440b-94cb-3bc4f39db952 failed (duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
    Jan 24 15:39:23 nodename pulpcore-worker-8: DETAIL:  Key (repository_id, content_id, version_removed_id)=(efb0eb39-f02f-4493-a1af-bf6fb2b462de, 2b6f6ef7-3382-4b7c-a8a1-f088db1bb581, 61dfdd1f-46d1-49b7-89bc-44adb55769ec) already exists.
    

Optionally, an attempt to delete a CV or its version fails with the same error.

Environment

  • Red Hat Satellite 6.10

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content