[Spacewalk-list] ISE when rhnpushing Solaris Patches

[Pierre Casenove]

Hello,
Did you have time to review these three patches?

Thanks

Pierre

2012/7/4 Pierre Casenove <pcasenove at gmail.com>:
> 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 <pcasenove at gmail.com>:
>> 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 <pcasenove at gmail.com>:
>>> 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 <pcasenove at gmail.com>:
>>>> I've rhnpushed the complete patch cluster.
>>>>
>>>> thanks a lot for this fix!
>>>>
>>>>
>>>> 2012/7/4 Jan Pazdziora <jpazdziora at redhat.com>:
>>>>> 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
>>>>> Spacewalk-list at redhat.com
>>>>> https://www.redhat.com/mailman/listinfo/spacewalk-list