Bug 644361

Summary:	Performance of email notifications after satellite-sync
Product:	Red Hat Satellite 5	Reporter:	Miroslav Suchý <msuchy>
Component:	Satellite Synchronization	Assignee:	Tomas Lestach <tlestach>
Status:	CLOSED ERRATA	QA Contact:	Martin Minar <mminar>
Severity:	medium	Docs Contact:
Priority:	high
Version:	540	CC:	cperry, jhutar, mkoci, mminar, msuchy, paji, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	Consequence: After syncing of new errata, e-mail notifications get processed very slow and it takes a long time until the notifications get sent. Result: The performance of e-mail notifications processing was significantly improved.	Story Points:	---
Clone Of:	630884	Environment:
Last Closed:	2011-08-16 13:58:12 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:	630884
Bug Blocks:	715348

Description Miroslav Suchý 2010-10-19 14:29:27 UTC

+++ This bug was initially created as a clone of Bug #630884 +++

2) performance

satellite sync ended at:
    Import complete:
        Begin time: Fri Oct 15 05:42:59 2010
        End time:   Fri Oct 15 07:13:48 2010
        Elapsed:    1 hours, 30 minutes, 48 seconds 

First email was sent at: 7:32 (which is ok) and last was sent at 8:34. This open question how this will behave, if you have to sent errata notification for 1000 systems/users.

--- Additional comment from tlestach on 2010-10-19 10:20:14 EDT ---

Step to reproduce:
1) sync 5.0 channel with --no-errata
2) register rhel 5.0 to this channel
3) sync all errata
4) wait for emails "Errata Alert" to arive

Actual results:
aprox. 10 emails per 30 minutes

Expected results:
all emails should arrive within one or two minute.

Comment 1 Tomas Lestach 2010-10-19 15:42:27 UTC

spacewalk.git: fda4e5b21b0107ba11d4cb25cf0cabc3e6db1120

For QA: Please test very carefully, if all expected errata notifications will be sent.

Comment 2 Clifford Perry 2011-07-20 21:17:04 UTC

bug 720533 &  bug 701457 both replace rhnServerNeededView with a custom SQL for results. That may be a better solution here vs using the rhnServerNeededCache. 

Since all loosely associated (taskomatic performance) - moving over for Errata.

Comment 5 Tomas Lestach 2011-07-27 14:09:36 UTC

    Technical note added. If any revisions are required, please edit the "Technical Notes" field
    accordingly. All revisions will be proofread by the Engineering Content Services team.
    
    New Contents:
Consequence:
After syncing of new errata, e-mail notifications get processed very slow and it takes a long time until the notifications get sent.
Result:
The performance of e-mail notifications processing was significantly improved.

Comment 7 errata-xmlrpc 2011-08-16 13:58:12 UTC

An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHBA-2011-1162.html