Nightly repo syncs often result in duplicate key error
Environment
- Red Hat Satellite v.6.1(beta)
- Content Management
Issue
- Nightly repo syncs often result in duplicate key error, number of repos set to sync at midnight for each night fail with,
ActiveRecord::RecordNotUnique: PGError: ERROR: duplicate key value violates unique constraint "katello_system_errata_eid_sid"
: INSERT INTO katello_system_errata (erratum_id, system_id) VALUES (xxxx, xxxx)
Resolution
-
To workaround resume the failed task from Satellite web-ui
Monitor -> Tasks -> (click on failed task, select) Resume, operation should proceed successfully. -
Additionally follow the article Red Hat Satellite6 repository sync pending on Actions::Pulp::Repository::RegenerateApplicability to clear suspended tasks for failed repository sync .
Root Cause
-
This is a known bug with
Satellite 6.1 beta, for details refer public bugzilla link Bug 1244704. -
As per update from our engineering team the issue will be fixed in Satellite 6.1 GA.
This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
