Project

General

Profile

Bug #13085

duplicate key value violates unique constraint errors

Added by John Mitsch over 4 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

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?

Associated revisions

Revision c92c13fa (diff)
Added by John Mitsch over 4 years ago

Fixes #13085 - duplicate key value on content view publish

Revision 33075d0a
Added by John Mitsch over 4 years ago

Merge pull request #5902 from johnpmitsch/duplicate_key_13085

Fixes #13085 - duplicate key value on content view publish

History

#1 Updated by John Mitsch over 4 years ago

#2 Updated by Brad Buckingham over 4 years ago

Note: when i saw this error it was doing steps 1-5 after the katello:reset. The katello:reset itself did not report an error.

#3 Updated by Eric Helms over 4 years ago

  • Legacy Backlogs Release (now unused) set to 86

#4 Updated by Eric Helms over 4 years ago

#5 Updated by John Mitsch over 4 years ago

  • Assignee set to Zach Huntington-Meath

#6 Updated by John Mitsch over 4 years ago

  • Bugzilla link set to 1319309

#7 Updated by The Foreman Bot over 4 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/5902 added

#8 Updated by Brad Buckingham over 4 years ago

  • Assignee changed from Zach Huntington-Meath to John Mitsch

Updating owner based upon PR.

#9 Updated by John Mitsch over 4 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF