[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