[Spacewalk-list] ISE when rhnpushing Solaris Patches

[Pierre Casenove]

hello,
Could you please review these patches and commit them if there're OK for you?

Thanks,

Pierre

2012/7/6 Pierre Casenove <pcasenove at gmail.com>:
> 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