Bug 1846313

Summary:	Add index on locks for resource type and task id
Product:	Red Hat Satellite	Reporter:	Adam Ruzicka <aruzicka>
Component:	Tasks Plugin	Assignee:	Tomer Brisker <tbrisker>
Status:	CLOSED ERRATA	QA Contact:	Peter Ondrejka <pondrejk>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.8.0	CC:	aruzicka, egolov, pcreech
Target Milestone:	6.8.0	Keywords:	Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	tfm-rubygem-foreman-tasks-2.0.1	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-10-27 13:03:19 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Adam Ruzicka 2020-06-11 11:07:32 UTC

Description of problem:
https://community.theforeman.org/t/slow-products-page-on-2-0/19142/23 has indicated adding this index can lead to significant speed up of products page queries/

Version-Release number of selected component (if applicable):


How reproducible:
always


Steps to Reproduce:
1. Have several products which have been synced
2. Open the products page
3.

Actual results:
It takes long time to load

Expected results:
It should load faster

Additional info:

Comment 1 Adam Ruzicka 2020-06-11 11:10:46 UTC

The attached fix can reduce the load times quite drastically, see the thread on discourse. That's why I'd like to propose this for 6.8

Comment 2 Tomer Brisker 2020-06-11 13:22:10 UTC

*** Bug 1846310 has been marked as a duplicate of this bug. ***

Comment 3 Tomer Brisker 2020-06-11 13:22:13 UTC

*** Bug 1846312 has been marked as a duplicate of this bug. ***

Comment 4 Bryan Kearney 2020-06-15 12:04:38 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/30103 has been resolved.

Comment 5 Peter Ondrejka 2020-07-17 12:22:26 UTC

Verified on Satellite 6.8 snap 9 using the export analyze query from the associated foreman.community discussion, the index_tasks_locks_on_task_id_resource_type_and_resource_id has been added and is applied

Comment 8 errata-xmlrpc 2020-10-27 13:03:19 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