Satellite 6.12.2 running a reindexdb on foreman retrieves; ~~~ DEBUG: building index "katello_erratum_packages_eid_nvrea_n_f" on table "katello_erratum_packages" with request for 1 parallel worker reindexdb: error: reindexing of database "foreman" failed: ERROR: could not create unique index "katello_erratum_packages_eid_nvrea_n_f" DETAIL: Key (erratum_id, nvrea, name, filename)=(61289, libpmemobj++-devel-1.4-3.el7.x86_64, libpmemobj++-devel, libpmemobj++-devel-1.4-3.el7.x86_64.rpm) is duplicated. ~~~ The duplicates are numerous, as well; ~~~ [root@satellite ~]# echo "select erratum_id, filename, count(*) from katello_erratum_packages group by erratum_id, filename having count(*) > 1;" | sudo -u postgres psql foreman | tail could not change directory to "/root": Permission denied 62723 | gcc-objc++-4.8.5-16.el7.x86_64.rpm | 2 62723 | gcc-objc-4.8.5-16.el7.x86_64.rpm | 2 62772 | gcc-objc++-4.8.5-16.el7_4.2.x86_64.rpm | 2 63154 | libpmemobj++-devel-1.2.1-4.el7.x86_64.rpm | 2 63248 | gcc-objc-4.8.5-28.el7.x86_64.rpm | 2 63299 | gcc-objc++-4.8.5-4.el7.x86_64.rpm | 2 63546 | gcc-objc++-4.8.2-16.2.el7_0.x86_64.rpm | 2 63546 | gcc-objc-4.8.2-16.2.el7_0.x86_64.rpm | 2 (83 rows) ~~~ It seems like this is perhaps limited to 6.12.2 but no confirmation there yet.
Hi Paul, Thanks for raising. Can you provide the reproducer steps?
Brad, Thanks. I've tried yesterday to reproduce on a 6.12 system that had been upgraded from at least 6.10 and failed to reproduce it. I'm still trying to look into root cause for this. So far we have at least one customer case and I have an internal Satellite with this issue which I can provide for troubleshooting if that helps, or DB dumps as well if that can help. If I stumble on more info here I will update the bz. Thanks Paul
Closing this as a duplicate -- please reopen this issue if it's found to not be caused by the LEAPP upgrade. *** This bug has been marked as a duplicate of bug 2161929 ***