Bug 1572306

Summary:	Katello Event Queue db queries need improvement
Product:	Red Hat Satellite	Reporter:	Satellite Program <pm-sat>
Component:	Performance	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	CLOSED ERRATA	QA Contact:	Jitendra Yejare <jyejare>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.3.0	CC:	andrew.schofield, inecas, jyejare, mmccune, paji
Target Milestone:	6.4.0	Keywords:	PrioBumpField, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1560740	Environment:
Last Closed:	2018-10-16 19:15:45 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:

Comment 2 Jitendra Yejare 2018-06-20 10:01:59 UTC

Verified!

Steps:

As per script [1] used in original bug [2] of this bug.

Observation:

The time taken (25 seconds only) to clear 30000 event queues is much smaller than the issue observed in 6.3 (5 minutes).

[1]: https://bugzilla.redhat.com/show_bug.cgi?id=1560740#c6
[2]: https://bugzilla.redhat.com/show_bug.cgi?id=1560740

Comment 3 Bryan Kearney 2018-10-16 19:15:45 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, 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-2018:2927