Red Hat Bugzilla – Bug 475560
number of critical patches listed in sdc is not correct
Last modified: 2009-01-22 11:31:12 EST
Description of problem:
register a system to spacewalk
go to the system overview.. note the number of errata and packages that need updating
Created attachment 326359 [details]
ss of the # of errata
now click into the system and view the sdc..
notice the number of packages listed as critical.. it has changed from "1" to "3"
Created attachment 326361 [details]
ss of the # of errata in sdc
now click on the link "critical" in the sdc and only one package is listed..
Created attachment 326363 [details]
ss of the # of errata in list of errata
system list page uses value from rhnserveroverview:
for example on my test system which shows 275 errata, the following query
is used to determine that:
select security_errata, bug_errata, enhancement_errata from rhnserveroverview where server_id = 1000098324;
SECURITY_ERRATA BUG_ERRATA ENHANCEMENT_ERRATA
--------------- ---------- ------------------
70 174 31
Next to find where it gets the numbers for the Server Details page.
added a distinct to the count_critical_errata_for_system and count_noncritical_errata_for_system datasource queries in Errata_queries.xml.
Both Critical and Non-Critical link to the same page. So the total seen on the result ErrataList page is the sum of the two on the previous page.
The packages link page shows the same number as seen on the sdc.