Hello, I can't find where the issue is. Could you please explain how I can debug the sql query, to see why it doesn't find that the patch is indeed already installed. As I don't understand the query, I don't know which table I should check to try to find the bug.
Thanks, Pierre 2012/11/27 Pierre Casenove <[email protected]> > 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 <[email protected]> > >> 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 >> > >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
