Plugins » Katello

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1858237

Description of problem:
I upgraded a Satellite from 6.7.2 to 6.8 snap 9.0 and it has duplicate indexes on katello_pools:

1. su - postgres c "psql -d foreman -c 'SELECT indrelid::regclass AS TableName,array_agg(indexrelid::regclass) AS Indexes FROM pg_index GROUP BY indrelid,indkey HAVING COUNT > 1;;'"
   tablename | indexes
   --------------+-----------------------------------------------------
   katello_pools | {index_katello_pools_on_cp_id,index_pools_on_cp_id}
   (1 row)

How reproducible:
Deterministic

Steps to Reproduce:
1. Upgrade Satellite
2. # su - postgres -c "psql -d foreman -c 'SELECT indrelid::regclass AS TableName,array_agg(indexrelid::regclass) AS Indexes FROM pg_index GROUP BY indrelid,indkey HAVING COUNT > 1;;'"

Actual results:
Duplicate indexes on katello_pools

Expected results:
No duplicate indexes (empty output)