Satellite tasks for Content Host profile uploads end in Warnings due to Unique Constraint violations

Solution In Progress - Updated -

Issue

  • Actions::Katello::Host::UploadProfiles tasks end with a Warning result.
  • During the Run phase of the task, it errors with a Unique Constraint violation on katello_content_facet_repository_rid_caid
ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "katello_content_facet_repository_rid_caid"
DETAIL:  Key (repository_id, content_facet_id)=(123456, 654321) already exists.
: INSERT INTO "katello_content_facet_repositories" ("content_facet_id", "repository_id") VALUES ($1, $2) RETURNING "id"

Environment

Red Hat Satellite 6.7 (likely earlierversions as well, but the specific tasks may differ)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In