[Spacewalk-list] [Solaris support] installed patches not refreshed

[Pierre Casenove]

Hello,
I've searched a bit more to try to debug this issue.
The query executed to list patches that need to be installed is:
SELECT  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.nameAS 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))


This query, when executed in psql command line, list 345 patches for my
test system. I can't understand how it works but I think there is a issue
in the query (or in solaris2mpm?)

What's event more weird is that when I go in the details of a specific
patch (for example 118666), my solaris client is listed in the tab "Patched
System".
In the tab "Target System", the client is also listed, but with no package
to patch:
System Unpatched Packages
tu-spa-d01 (none)

Thanks in advance for your help,

Pierre


2012/11/26 Pierre Casenove <pcasenove at gmail.com>

> Hello,
> I'm testing solaris support on spacewalk 1.8 with pgsql.
> I've successfully:
> - deployed a single patch
> - rhnpushed a patch cluster and deployed it
> - After rhnpushing the patch cluster, 345 patches were listed as needed
> for my test client
> - After patch cluster deployment, there are still 345 patches marked as
> needed for my test client (Solaris 10 SPARC V240).
>
> 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
>
> - When I run a rhn_check-vvvv there are no errors either on the client nor
> on the server (I've checked error_log, ssl_errror_log, catalina.out and
> rhn_tackomatic logs)
>
> Could you please help me with this issue, I don't know where to look at.
>
> Pierre
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121127/c6ddf77c/attachment.htm>