Importing a new subscription manifest in Satellite 6 fails with 'ERROR: duplicate key value violates unique constraint "cp_product_content_pkey"'

Solution Verified - Updated -

Issue

  • When importing a new subscription manifiest in Satellite 6, the following error appears:
    • Error importing manifest. Failed to import archive
    • In /var/log/candlepin/error.log, the following error is reported:
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cp_product_content_pkey" Detail: Key (product_id, content_id)=(205, 5464) already exists.

Or the error may look like:

ERROR:  duplicate key value violates unique constraint "cp_product_content_pkey"
STATEMENT:  insert into cp_product_content (product_id, content_id, enabled, created, updated) values ($1, $2, $3, $4, $5)

Environment

  • Red Hat Satellite 6.2

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