This seems to be related to rails 4, errors that look like
PG::Error: ERROR: duplicate key value violates unique constraint "index_katello_repository_package_groups_on_pgid_repoid"
DETAIL: Key (package_group_id, repository_id)=(3, 2) already exists.
: INSERT INTO katello_repository_package_groups (package_group_id, repository_id, created_at, updated_at) VALUES (3, 2, '2016-01-08 14:28:11 UTC', '2016-01-08 14:28:11 UTC'), (4, 2, '2016-01-08 14:28:11 UTC', '2016-01-08 14:28:11 UTC')
are popping up somewhat randomly.
One way to possibly recreate:
1. create repo, 2. sync repo, 3. create content view, 4. add repo to view, 5. publish view
also is seen during katello:reset
possibly race conditions?
Created from redmine issue http://projects.theforeman.org/issues/13085
Note that this is a transient error and will not happen every time you publish a content view
PR open upstream https://github.com/Katello/katello/pull/5902
Moving to POST since upstream bug http://projects.theforeman.org/issues/13085 has been closed
Applied in changeset commit:katello|c92c13fa113533fc8cf255e9d12038a4069067ec.
Verified in Satellite 6.2 Beta Snap 6 Compose 2.
No longer able to reproduce the issue with over 50 publishes and promotions.
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.