[Spacewalk-list] ISE when rhnpushing Solaris Patches

Pierre Casenove pcasenove at gmail.com
Wed Jul 4 15:35:35 UTC 2012


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
-------------- next part --------------
From 20005776dba453bec79cb915c2e0d78ece54fdcd Mon Sep 17 00:00:00 2001
From: Pierre Casenove <pcasenove at gmail.com>
Date: Wed, 4 Jul 2012 15:32:33 +0000
Subject: [PATCH] Addressing ISE on page network/software/packages/target_system_list_for_patch.pxt
 ERROR:  cross-database references are not implemented: pe.evr.as_vre_simple

---
 .../rhn/RHN/DB/DataSource/xml/System_queries.xml   |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index 805589a..747a683 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -1191,7 +1191,7 @@ ORDER BY S.name, S.id
   <elaborator params="pid" multiple="t">
 SELECT SPP.server_id AS ID,
        PN.name AS PACKAGE_NAME,
-       PN.name || '-' || PE.evr.as_vre_simple() AS PACKAGE_NVRE,
+       PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS PACKAGE_NVRE,
        PN.id || '|' || PE.id AS PACKAGE_ID_COMBO
   FROM rhnPackageName PN,
        rhnPackageEVR PE,
--
1.7.4.1


More information about the Spacewalk-list mailing list