Bug 1807946 - Multiple duplicate index entries are present in foreman database
Summary: Multiple duplicate index entries are present in foreman database
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Dynflow
Version: 6.5.0
Hardware: All
OS: All
unspecified
medium
Target Milestone: 6.8.0
Assignee: satellite6-bugs
QA Contact: Lukáš Hellebrandt
URL:
Whiteboard:
Depends On: 1744202 1846593 1848538 1850096 1854538
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-02-27 14:29 UTC by Eric Helms
Modified: 2020-11-19 15:59 UTC (History)
11 users (show)

Fixed In Version: tfm-rubygem-dynflow-1.4.4
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1744202
Environment:
Last Closed: 2020-10-27 13:00:31 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github Dynflow dynflow pull 354 0 None closed Remove indices that duplicate primary key constraints 2020-11-19 14:54:38 UTC
Red Hat Product Errata RHSA-2020:4366 0 None None None 2020-10-27 13:00:48 UTC

Comment 3 Adam Ruzicka 2020-05-05 09:34:53 UTC 
The fix was merged in upstream, moving to POST
Comment 7 Adam Ruzicka 2020-05-06 20:31:13 UTC 
Dynflow 1.4.4 containing fix for this BZ was released in upstream, moving to MODIFIED and setting flags.
Comment 8 Lukáš Hellebrandt 2020-07-17 10:27:17 UTC 
Verified with Sat 6.7.2 upgraded to Sat 6.8 snap 9.0.

The dynflow indexes are not duplicated anymore. There is another duplicated index but that's a different BZ:

# 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)
Comment 9 Lukáš Hellebrandt 2020-07-17 10:34:44 UTC 
katello_pools duplicate indexes reported as bug 1858237
Comment 12 errata-xmlrpc 2020-10-27 13:00:31 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Important: Satellite 6.8 release), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2020:4366
Note You need to log in before you can comment on or make changes to this bug.