Description of problem: When I synced lots of RHN Tools repos, I got lots of errors in PostgreSQL log: 'duplicate key value violates unique constraint "index_katello_rpms_on_uuid"' Version-Release number of selected component (if applicable): satellite-6.3.0-20.0.beta.el7sat.noarch How reproducible: always Steps to Reproduce: 1. Content -> Red Hat Repositories -> RPMs -> Red Hat Enterprise Linux Server -> RHN Tools for Red Hat Enterprise Linux 6 Server (RPMs) Check these (or more): [x] RHN Tools for Red Hat Enterprise Linux 6 Server RPMs i386 6Server [x] RHN Tools for Red Hat Enterprise Linux 6 Server RPMs x86_64 6Server 2. Content -> Sync Status -> Expand all and select these two repos and click "Synchronize Now" 3. Tail PostgreSQL logs Actual results: ==> /var/lib/pgsql/data/pg_log/postgresql-Tue.log <== 2017-10-17 04:22:34 EDT ERROR: duplicate key value violates unique constraint "index_katello_rpms_on_uuid" 2017-10-17 04:22:34 EDT DETAIL: Key (uuid)=(7fe43d69-c8fc-44ec-99ba-709da6b77bbe) already exists. 2017-10-17 04:22:34 EDT STATEMENT: INSERT INTO "katello_rpms" ("uuid", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" 2017-10-17 04:22:34 EDT ERROR: duplicate key value violates unique constraint "index_katello_rpms_on_uuid" 2017-10-17 04:22:34 EDT DETAIL: Key (uuid)=(8111010d-8963-4aeb-9b99-6fed19ad8e77) already exists. 2017-10-17 04:22:34 EDT STATEMENT: INSERT INTO "katello_rpms" ("uuid", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" 2017-10-17 04:22:34 EDT ERROR: duplicate key value violates unique constraint "index_katello_rpms_on_uuid" 2017-10-17 04:22:34 EDT DETAIL: Key (uuid)=(8274e22b-43cd-4555-915d-3dbea795fd3c) already exists. Expected results: There should be errors in PostgreSQL logs
The Satellite Team is attempting to provide an accurate backlog of bugzilla requests which we feel will be resolved in the next few releases. We do not believe this bugzilla will meet that criteria, and have plans to close it out in 1 month. This is not a reflection on the validity of the request, but a reflection of the many priorities for the product. If you have any concerns about this, feel free to contact Red Hat Technical Support or your account team. If we do not hear from you, we will close this bug out. Thank you.
Thank you for your interest in Satellite 6. We have evaluated this request, and while we recognize that it is a valid request, we do not expect this to be implemented in the product in the foreseeable future. This is due to other priorities for the product, and not a reflection on the request itself. We are therefore closing this out as WONTFIX. If you have any concerns about this, please do not reopen. Instead, feel free to contact Red Hat Technical Support. Thank you.