Bug 1807946
| Summary: | Multiple duplicate index entries are present in foreman database | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Eric Helms <ehelms> |
| Component: | Dynflow | Assignee: | satellite6-bugs <satellite6-bugs> |
| Status: | CLOSED ERRATA | QA Contact: | Lukáš Hellebrandt <lhellebr> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.5.0 | CC: | andrew.schofield, aruzicka, bkearney, egolov, inecas, mbacovsk, nkathole, rankumar, satellite6-bugs, vijsingh, zhunting |
| Target Milestone: | 6.8.0 | Keywords: | Performance, Triaged |
| Target Release: | Unused | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Fixed In Version: | tfm-rubygem-dynflow-1.4.4 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | 1744202 | Environment: | |
| Last Closed: | 2020-10-27 13:00:31 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | 1744202, 1846593, 1848538, 1850096, 1854538 | ||
| Bug Blocks: | |||
|
Comment 3
Adam Ruzicka
2020-05-05 09:34:53 UTC
Dynflow 1.4.4 containing fix for this BZ was released in upstream, moving to MODIFIED and setting flags. 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)
katello_pools duplicate indexes reported as bug 1858237 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 |