Red Hat Bugzilla – Bug 915770
System currency page could provide incorrect info
Last modified: 2013-03-06 13:35:47 EST
Description of problem:
Numbers provided on rhn/systems/SystemCurrency.do could be bigger for any security update.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. open rhn/systems/SystemCurrency.do
Number of security erratas that could be applied to system is bigger than actual result
Corrected numbers are shown
in code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml we have following code:
sum(case when substr(errata.synopsis, 1, 1) = 'C' then 1 else 0 end) critical,
sum(case when substr(errata.synopsis, 1, 1) = 'I' then 1 else 0 end) important,
sum(case when substr(errata.synopsis, 1, 1) = 'M' then 1 else 0 end) moderate,
sum(case when substr(errata.synopsis, 1, 1) = 'L' then 1 else 0 end) low,
We are not checking if the errata has advisory type 'Security Advisory' and that leads to situation where any Bug Fix or Enhancement errata can contribute to number of security errata.
fixed in spacewalk master e8ad21403d85a917dee261116a54c141b5680d1a
Marking bug as ON_QA since tonight's build of Spacewalk nightly is a release candidate for Spacewalk 1.9.
Spacewalk 1.9 has been released.