Hello, Did you find why the new query doesn't worki either? Do you want me to fill a BZ?
Thanks, Pierre 2012/12/4 Pierre Casenove <[email protected]> > In fact, the query seems to be a bit too much restrictive. > 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 > | | > > The patch is listed as needed! > > But the patch is not listed in the list of patches that can be installed > on my system. > > Pierre > > > > 2012/12/4 Pierre Casenove <[email protected]> > >> I've modified as Jan suggested. >> The query is now correctly executed. >> And the query is much better: I get a list of 39 patches only, but when I >> take a closer look, these patches are not applicable to my ystem, as the >> package it patches is not installed. >> Exemple with patch 120412: >> warning: The following requested patches have packages not installed on >> the system >> warning: Package SUNWcleu2 from directory SUNWcleu2 in patch 120412-11 is >> not installed on the system. Changes for package SUNWcleu2 will not be >> applied to the system. >> >> I'm not sure if spacewalk is able to detect that, even more because I >> actually didn't rhnpushed all the Solaris packages to spacewalk server, but >> only the patches. >> >> If the behaviour is as expected, you can commit. >> >> >> 2012/12/4 Jan Pazdziora <[email protected]> >> >>> On Tue, Dec 04, 2012 at 04:21:18PM +0100, Pierre Casenove wrote: >>> > hello, >>> > I've patched rhn.jar... and now, I get an ISE: >>> > >>> > Caused by: org.postgresql.util.PSQLException: ERROR: column reference >>> > "name" is ambiguous >>> > I'm on RHEL 5 with pgsql 8.4. >>> >>> Could you change that >>> >>> order by upper(name || '-' || >>> evr_t_as_vre_simple(full_list.evr)) >>> >>> in the patch to >>> >>> order by upper(pn.name || '-' || >>> evr_t_as_vre_simple(full_list.evr)) >>> >>> ? (Not tested, just looking at the code.) >>> >>> -- >>> Jan Pazdziora >>> Principal Software Engineer, Satellite Engineering, Red Hat >>> >>> _______________________________________________ >>> Spacewalk-list mailing list >>> [email protected] >>> https://www.redhat.com/mailman/listinfo/spacewalk-list >>> >> >> >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
