Nightly repo syncs often result in duplicate key error

Solution Verified - Updated -

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

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.