[Spacewalk-list] ISE when rhnpushing Solaris Patches

[Jan Pazdziora]

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