hello, Could you please review these patches and commit them if there're OK for you?
Thanks, Pierre 2012/7/6 Pierre Casenove <[email protected]>: > Hello, > Did you have time to review these three patches? > > Thanks > > Pierre > > 2012/7/4 Pierre Casenove <[email protected]>: >> Hello, >> Another patch, correcting another request, used when going into a >> patch detail page and then clicking "Target Systems" >> Which give the error: >> ERROR: cross-database references are not implemented: pe.evr.as_vre_simple >> STATEMENT: >> SELECT DISTINCT S.id, >> PN.name AS PACKAGE_NAME, >> PN.name || '-' || PE.evr.as_vre_simple() AS PACKAGE_NVRE, >> PN.id || '|' || PE.id AS PACKAGE_ID_COMBO >> FROM rhnPackageName PN, >> rhnPackageEVR PE, >> rhnPackageArch PA, >> rhnServerPackage SP, >> rhnPackageNEVRA PNEVRA, >> rhnServer S, >> rhnSolarisPatchPackages SPP >> WHERE SPP.patch_id = $1 >> AND S.id in ($2) >> AND PNEVRA.id = SPP.package_nevra_id >> AND NOT EXISTS (SELECT 1 >> FROM rhnSolarisPatchedPackage SPdP >> WHERE SPdP.server_id = S.id >> AND SPdP.patch_id = $1 >> AND SPdP.package_nevra_id = PNEVRA.id) >> AND SP.server_id = S.id >> AND SP.name_id = PNEVRA.name_id >> AND SP.evr_id = PNEVRA.evr_id >> AND PN.id = PNEVRA.name_id >> AND PE.id = PNEVRA.evr_id >> ORDER BY S.id, PN.name >> >> Please let me know if all three patches are correct. >> >> Pierre >> >> >> 2012/7/4 Pierre Casenove <[email protected]>: >>> Hello, >>> Please find attached a second patch, adressing an ISE encountered >>> when navigating to <Software Channel> --> <Child Channel> --> Target >>> Systems >>> >>> Pierre >>> >>> >>> 2012/7/4 Pierre Casenove <[email protected]>: >>>> Please find attached a patch to correct the following error on page >>>> /rhn/systems/details/packages/patchsets/PatchSetList.do: >>>> .redhat.rhn.common.db.WrappedSQLException: ERROR: function >>>> nvl(timestamp with time zone, timestamp with time zone) does not exist >>>> >>>> Which occurs when navigating to System --> Software --> Patch Clusters >>>> and that at least one patch cluster exists. >>>> >>>> I've also noticed a potential problem with the name of the patch cluster: >>>> The mpm file that has been generated for the patch cluster is: >>>> patch-cluster-solaris--20120412-1.sparc-solaris-patch-cluster.mpm >>>> (notice the two minus sign in the middle) >>>> In spacewalk GUI, the patch cluster is named:patch-cluster-solaris- >>>> >>>> Will all patch clusters be named patch-cluster-solaris- without any >>>> problem? >>>> >>>> Pierre >>>> >>>> >>>> 2012/7/4 Pierre Casenove <[email protected]>: >>>>> I've rhnpushed the complete patch cluster. >>>>> >>>>> thanks a lot for this fix! >>>>> >>>>> >>>>> 2012/7/4 Jan Pazdziora <[email protected]>: >>>>>> On Wed, Jul 04, 2012 at 10:05:42AM +0200, Pierre Casenove wrote: >>>>>>> Hello list, >>>>>>> I have generated the 348 mpm files corresponding to the latest Solaris >>>>>>> 10 patch cluster, and I'm trying to rhnpush them. >>>>>>> rhnpush --username=administrator --password=<XXXXXXX> >>>>>>> --channel=solaris-10-sparc-patches --server=http://server/APP --dir >>>>>>> ./mpm >>>>>>> And I get the following error: >>>>>>> Error pushing >>>>>>> /home/solaris/mpm/patch-solaris-143513-02-1.sparc-solaris-patch.mpm: >>>>>>> Error 500 (500) >>>>>>> Waiting 1 seconds and trying again... >>>>>>> Internal server error 500 Internal Server Error >>>>>>> >>>>>>> SQLStatementPrepareError: ('column "\'1.4 REV=2006.03.29\'" does not >>>>>>> exist\nCONTEXT: Error occurred on dblink connection named "at_conn": >>>>>>> could not execute command.\nSQL statement "SELECT >>>>>>> dblink_exec(\'at_conn\', $1 , true)"\nPL/pgSQL function >>>>>>> "pg_dblink_exec" line 4 at PERFORM\nSQL statement "SELECT >>>>>>> pg_dblink_exec( \'insert into rhnPackageEVR(id, epoch, version, >>>>>>> release, evr) values (\' || $1 || \', \' || coalesce(quote_literal( >>>>>>> $2 ), \'NULL\') || \', \' || coalesce(quote_literal( $3 ), \'NULL\') >>>>>>> || \', \' || coalesce(quote_literal( $4 ), \'NULL\') || \', \' || >>>>>>> evr_t(coalesce(quote_literal( $2 ), \'NULL\'), coalesce(quote_literal( >>>>>>> $3 ), \'NULL\'), coalesce(quote_literal( $4 ), \'NULL\')) || \')\' >>>>>>> )"\nPL/pgSQL function "lookup_evr" line 14 at PERFORM\n', 0, 'select >>>>>>> LOOKUP_EVR(%(epoch)s, %(version)s, %(release)s) id from dual') >>>>>>> >>>>>>> I attached the complete stack trace. >>>>>>> >>>>>>> Any help would be greatly appreciated! >>>>>> >>>>>> Please update your lookup_evr in psql with the version from commit >>>>>> d13b56bc04cb17f7f7cf2ca40b98602547f85adb -- that should fix it. >>>>>> >>>>>> Thank you, >>>>>> >>>>>> -- >>>>>> 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
