Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 529053

Summary: Calculation of errata cache is inconsistent across the application.
Product: Red Hat Satellite 5 Reporter: Justin Sherrill <jsherril>
Component: WebUIAssignee: Justin Sherrill <jsherril>
Status: CLOSED CURRENTRELEASE QA Contact: Garik Khachikyan <gkhachik>
Severity: urgent Docs Contact:
Priority: high    
Version: 520CC: cperry, gkhachik, jhutar, jpazdziora, mkoci
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 521 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 528168
: 529064 (view as bug list) Environment:
Last Closed: 2009-11-10 08:15:04 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: 473868    

Comment 1 Justin Sherrill 2009-10-14 19:06:22 UTC
Cloned for 5.2.1

Comment 6 Justin Sherrill 2009-10-16 14:12:35 UTC
Ok, I still haven't committed the changes, but here's the steps to reproduce:

1.  Fully sync rhel-i386-server-5 channel
2.  Take a RHEL 5 client and install nspr-4.7.3-2.el5
3.  Register the RHEL 5 client and subscribe it to the rhel-i386-server-5 channle.
4.  Run 'rhn-profile-sync'
5.  Go to the systems overview page and notice how many errata show as needed for that system.  (Click on the number and verify that this list shows the same number).
6.  Run the following query:

sql> insert into rhnTaskQueue
  (org_id, task_name, task_data, priority, earliest)
  select 1, 'update_errata_cache_by_channel', c.id, 0, SYSDATE
  from rhnChannel c where c.label = 'rhel-i386-server-5';  
sql> commit;

7.  Wait 20 minutes
8.  Go to the systems overview page and verify that the same number of errata are shown as before. (Click on the number and verify that this list shows the same number).


At each stage (Step 5 & 8)  the Errata RHSA-2009:1186 & RHBA-2009:1161 should show up in the errata list for that system


NOTE:  changing channel subscriptions (and registering a system) will result in a number that differs (most likely by 1), this is expected and is fixed in 5.3.  Since it is a schema issue we cannot fix it in 5.2.1.

Comment 7 Justin Sherrill 2009-10-16 15:35:22 UTC
Actually registration goes through the backend so it should be fixed too.

fixed in rev 187955.  Java fix still coming.

Comment 8 Justin Sherrill 2009-10-19 17:43:26 UTC
fixed the java side of things in 187995.

Comment 9 Jan Pazdziora (Red Hat) 2009-10-20 13:51:13 UTC
Packages rhn-java-sat-5.2.1-1.el[45] and rhns-5.2.1-1.el[45] were now built.

Comment 13 errata-xmlrpc 2009-11-10 08:15:04 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-2009-1564.html

Comment 14 Jan Pazdziora (Red Hat) 2009-11-10 11:15:06 UTC
The errata which we've released is actually errata marking the Satellite 5.2.1 release, changing resolution to CURRENTRELEASE.