Bug 576314

Summary:	Auto-update feature schedules errata multiples times for each system
Product:	Red Hat Satellite 5	Reporter:	Justin Sherrill <jsherril>
Component:	Other	Assignee:	Justin Sherrill <jsherril>
Status:	CLOSED ERRATA	QA Contact:	Petr Sklenar <psklenar>
Severity:	medium	Docs Contact:
Priority:	low
Version:	530	CC:	akrherz, cperry, inode0, psklenar, tao, vgaikwad, xdmoon
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-06-22 14:05:34 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:
Bug Blocks:	518256

Description Justin Sherrill 2010-03-23 19:35:39 UTC

Description of problem:

If the auto-update feature is enabled and there are multiple channels synced that contain the same errata a situation will present in which the errata is scheduled the same number of systems that contain that errata.

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


How reproducible:


Steps to Reproduce:
1. Sync  rhel-i386-server-5  & rhel-x86_64-server-5 
2. Register a system to one of the channels.
3. Wait a few days for an applicable errata to be released and run 'satellite-sync'
4. look and see how many times the errata was scheduled
  
Actual results:
The errata should be scheduled at least twice (once for each channel the errata is in)

Expected results:
The errata should only be scheduled once for the system

Comment 1 Justin Sherrill 2010-03-23 20:06:12 UTC

Need to modify ErrataQueueWorker to take channel_id into consideration for scheduleAutoUpdates()

Comment 2 Justin Sherrill 2010-03-26 20:22:18 UTC

Fixed in spacewalk git 51dc1dc669bc1ac048c9c6af9060b408db0a054d

Comment 8 Petr Sklenar 2010-06-14 16:01:41 UTC

taking qa contact for this bug

Comment 10 Justin Sherrill 2010-06-14 21:29:39 UTC

I think what was happening was that we were running the errata queue task multiple times for each errata (for different channels), so multiple entries were being inserted into rhnErrataNotificationQueue before the emailer could run.  Should be fixed now in master:

a124fd8e3259e3af2f2e0ccaa25062a52d5f4371

Comment 14 Petr Sklenar 2010-06-16 10:44:08 UTC

testing procedure:

1. Sync rhel-i386-server-5  & rhel-x86_64-server-5 
2. Register a system to one of the channels.
3. Wait a few days for an applicable errata to be released and run
'satellite-sync'
4. look and see how many times the errata was scheduled

Works as expected, The errata was scheduled once for the system. 
Verified on rhel55@i386 and rhel55@x86_64 with sat530 upgraded from errata.stage + packages from errata

Moving to Verified

Comment 16 errata-xmlrpc 2010-06-22 14:05:34 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-2010-0498.html