Project

General

Profile

Bug #30461

Upgraded Satellite has duplicated katello_pools indexes

Added by Jonathon Turel 3 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Low
Category:
Subscriptions
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

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)

Associated revisions

Revision cb98f469 (diff)
Added by Jonathon Turel 3 months ago

Fixes #30461 - Remove duplicate cp_id index on Pools table

History

#1 Updated by Jonathon Turel 3 months ago

  • Target version set to Katello 3.16.0
  • Priority changed from High to Low

#2 Updated by The Foreman Bot 3 months ago

  • Assignee set to Jonathon Turel
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/8847 added

#3 Updated by Chris Roberts 3 months ago

  • Triaged changed from No to Yes

#4 Updated by The Foreman Bot 3 months ago

  • Fixed in Releases Katello 3.18.0 added

#5 Updated by Jonathon Turel 3 months ago

  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF