Description of problem: 6/5.1 rhel 5 1. confirm that there are errata that contain the pkg kernel 2. errata, advanced search, by package name, search for kernel no results found.. expected results: erratum listed that have the pkg kernel
This is fixed with the below commit. commit 40bbd72aca5584d24bccea315ccf60d270e7bfee Author: John Matthews <jmatthew> Date: Wed Jun 10 16:04:12 2009 -0400 The issue was that in 6/5.1 ISO I changed the query to flesh out Errata to filter based on org_id, I didn't handle org_id being NULL For Red Hat channels, so I dropped all of those results from the query....this wasn't picked up during testing since I had clones of all the rhel channels I ended up testing with cloned errata. --- a/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedErrata.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedErrata.hbm.xml @@ -155,12 +155,16 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" from rhnErrata e, rhnErrataPackage ep, rhnPackage p, - rhnPackageName pn + rhnPackageName pn, + rhnAvailableChannels ac, + rhnChannelErrata ce where e.id = ep.errata_id and p.id = ep.package_id and p.name_id = pn.id and ep.package_id IN (:pids) - and e.org_id IN (:org_ids) + and e.id = ce.errata_id + and ce.channel_id = ac.channel_id + and ac.org_id = :org_id order by e.id]]> <return-scalar column="id" type="long" /> <return-scalar column="advisory" type="string" />
verified 6/12
Release Pending test1182.test.redhat.com
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/RHEA-2009-1434.html