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
