Content View publish fails with: 'PG::CardinalityViolation: ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time'

Solution Verified - Updated -

Issue

  • Content View publish task on Satellite fails with the following error message:
Error message:
PG::CardinalityViolation: ERROR:  ON CONFLICT DO UPDATE command cannot affect row a second time
HINT:  Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

Environment

  • Satellite 6.x

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