Bug 1644007

Summary: PG::UniqueViolation while syncing appstream kickstart
Product: Red Hat Satellite Reporter: jcallaha
Component: RepositoriesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: jcallaha
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.5.0CC: paji
Target Milestone: ReleasedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-12-03 15:23:15 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description jcallaha 2018-10-29 17:54:17 UTC
Description of problem:
I encountered this error while syncing the appstream kickstart repository:

PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "katello_module_stream_artifacts_name_mod_stream_id_uniq"
DETAIL:  Key (module_stream_id, name)=(3, php-gd-0:7.1.20-2.el8+1700+11d526eb.x86_64) already exists.
: INSERT INTO "katello_module_stream_artifacts" ("module_stream_id", "name", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"

This may be due to a simultaneous sync of the baseos kickstart.

Version-Release number of selected component (if applicable):
Satellite 6.5.0 Snap 1

How reproducible:
Consistent during initial sync

Steps to Reproduce:
1. Enable/Create appstream kickstart and baseos kickstart repositories
2. Sync both at the same time


Actual results:
A good chance of encountering the above error

Expected results:
No errors are encountered, during initial sync

Additional info:
To proceed, just re-sync the offending repository.

Comment 3 Partha Aji 2018-12-03 15:23:15 UTC

*** This bug has been marked as a duplicate of bug 1652885 ***