Bug 1443213 – Errata duplicate key error during Capsule sync

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1443213 - Errata duplicate key error during Capsule sync

Summary:	Errata duplicate key error during Capsule sync

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 6
Classification:	Red Hat
Component:	Pulp (Show other bugs)
Sub Component:
Version:	6.2.8
Hardware:	Unspecified Unspecified

Priority	unspecified Severity high (vote)
Target Milestone:	6.2.11
Target Release:	Unused
Assigned To:	satellite6-bugs
QA Contact:	Peter Ondrejka
Docs Contact:

URL:
Whiteboard:
Keywords:	PrioBumpField, Triaged

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-04-18 14:48 EDT by Tanya Tereshchenko
Modified:	2018-09-19 11:08 EDT (History)
CC List:	11 users (show)

See Also:
Fixed In Version:	pulp-rpm-2.8.7.15-2
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Clones:	1463812 (view as bug list)
Environment:
Last Closed:	2017-08-10 13:02:29 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Pulp Redmine	2721	High	CLOSED - CURRENTRELEASE	Race condition on errata model save during sync of multiple similar repos	2017-05-24 14:34 EDT
Red Hat Product Errata	RHBA-2017:2466	normal	SHIPPED_LIVE	Satellite 6.2.11 Async Release	2017-08-10 17:01:20 EDT

Groups: None (edit)

Description Tanya Tereshchenko 2017-04-18 14:48:38 EDT

Description of problem:

When multiple repositories of the similar errata content is synced in parallel, race condition can happen during import of errata. Most likely this issue will be observed on a Capsule. 

In the Pulp task report one can observe the following error:

"errata"=> {"state"=>"FAILED", 
            "error"=> "Tried to save duplicate unique keys (insertDocument :: caused by :: 11000 E11000 duplicate key error index: pulp_database.units_erratum.$errata_id_1 dup key: { : \"RHSA-2017:0907\" })"}

Comment 1 pulp-infra@redhat.com 2017-04-18 15:02:40 EDT

The Pulp upstream bug status is at ASSIGNED. Updating the external tracker on this bug.

Comment 2 pulp-infra@redhat.com 2017-04-18 15:02:42 EDT

The Pulp upstream bug priority is at High. Updating the external tracker on this bug.

Comment 4 pulp-infra@redhat.com 2017-04-18 16:02:29 EDT

The Pulp upstream bug status is at MODIFIED. Updating the external tracker on this bug.

Comment 5 pulp-infra@redhat.com 2017-04-18 16:32:41 EDT

All upstream Pulp bugs are at MODIFIED+. Moving this bug to POST.

Comment 6 pulp-infra@redhat.com 2017-05-17 09:33:59 EDT

The Pulp upstream bug status is at ON_QA. Updating the external tracker on this bug.

Comment 7 pulp-infra@redhat.com 2017-05-24 14:34:17 EDT

The Pulp upstream bug status is at CLOSED - CURRENTRELEASE. Updating the external tracker on this bug.

Comment 10 errata-xmlrpc 2017-08-10 13:02:29 EDT

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-2017:2466

Note You need to log in before you can comment on or make changes to this bug.