Bug 908624

Description of problem: after rhnpushing a patch to a solaris patch, the list of installed patch is not refreshed/correct.
Example:
- Patch 118666-36 is marked as to be installed by spacewalk
- On the client system, the patch is deployed:
bash-3.00# showrev -p | grep 118666-36
Patch: 118666-17 Obsoletes:  Requires:  Incompatibles:  Packages: SUNWj5rt, SUNWj5dev, SUNWj5cfg, SUNWj5dmo, SUNWj5man
Patch: 118666-36 Obsoletes:  Requires:  Incompatibles:  Packages: SUNWj5rt, SUNWj5dev, SUNWj5cfg, SUNWj5dmo, SUNWj5man


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


Steps to Reproduce:
1. Register a solaris client
2. rhnpsuh a patch cluster
3. deploy patch cluster
4. check patch listed as needed by spacewalk
  

Actual results: The deployed patchs are still marked as needed.


Expected results: Correct patch list


Additional info: The query executed by spacewalk is :
ELECT  pn.name AS NAME,
                pn.name || '-' || evr_t_as_vre_simple(full_list.evr) AS NVRE,
                pn.id || '|' || lookup_evr((full_list.evr).epoch, (full_list.evr).version, (full_list.evr).release) AS ID_COMBO,
                full_list.id,
                full_list.PATCH_TYPE
          FROM  (
                SELECT  p.name_id name_id, max(pe.evr) evr, p.id, pt.name AS PATCH_TYPE
                  FROM  rhnPackageEVR PE, rhnPackage P,
                         rhnChannelPackage CP, rhnServerChannel SC, rhnSolarisPatch SSP, rhnSolarisPatchType PT
                 WHERE  sc.server_id = 1000010008
                   AND  sc.channel_id = cp.channel_id
                   AND  cp.package_id = p.id
                   AND  ssp.package_id = p.id
                   AND  p.evr_id = pe.id
                   AND  pt.id = ssp.patch_type
              GROUP BY  p.name_id, p.id, pt.name
              ) full_list,
              rhnPackageName pn
         WHERE full_list.name_id = pn.id
           AND EXISTS (SELECT 1
                    FROM rhnPackageNEVRA PNEVRA,
                         rhnSolarisPatchPackages SPP,
                         rhnServerPackage SP
                  WHERE SP.server_id = 1000010008
                    AND SPP.patch_id = full_list.id
                    AND PNEVRA.id = SPP.package_nevra_id
                    AND PNEVRA.name_id = SP.name_id
                    AND ((PNEVRA.package_arch_id IS NULL AND SP.package_arch_id IS NULL) OR PNEVRA.package_arch_id = SP.package_arch_id)
                    AND NOT EXISTS (SELECT 1
                                    FROM rhnSolarisPatchedPackage SPdP
                                    WHERE SPdP.server_id = 1000010008
                                    AND SPdP.patch_id = full_list.id
                                    AND SPdP.package_nevra_id = PNEVRA.id))
        ORDER BY  UPPER(name || '-' || evr_t_as_vre_simple(full_list.evr))


On spacewalk list, Michael Mraka proposed a patch: http://koji.spacewalkproject.org/koji/taskinfo?taskID=117229

this patch is not working either:
I've downloaded a recent patch (not installed on my system) from oracle support and rhnpushed it.
When I go in the details of the patch, in the tab "target system" my client is listed.
But when I go in my system details, Software --> Patches --> Install, it is not listed.

Patch number: 121430
spaceschema=# select * from rhnServerOutdatedPackages where server_id = 1000010008;
 server_id  | package_name_id | package_evr_id |       package_nvre        | errata_id | errata_advisory
------------+-----------------+----------------+---------------------------+-----------+-----------------
 1000010008 |            7143 |           8682 | patch-solaris-121430-73-1 |           |