Red Hat Bugzilla – Bug 1319309
duplicate key value violates unique constraint errors
Last modified: 2016-07-27 05:28:00 EDT
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') 409 Conflict 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 ------------- John Mitsch 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. https://access.redhat.com/errata/RHBA-2016:1501