[Spacewalk-list] Random Spacewalk things I've found...

[Jan Pazdziora]

On Wed, Jan 18, 2012 at 10:15:17AM +0100, Jan Pazdziora wrote:
> On Tue, Jan 17, 2012 at 09:29:06PM -0800, Ian Forde wrote:
> > 
> > Here are some things that I've found recently...
> 
> We might prefer to have these issues tracked in separate posts/threads
> 'cause from the long post we might lose some things.
> 
> > (more info on this)
> > I just kickstarted a node, and had it happen again.  I logged in, did
> > a 'rhn-profile-sync' successfully.  Then I did a 'rhn_check -vv' and
> > got the following back:
> > 
> > XMLRPC ProtocolError: <ProtocolError for ordmantell.iforde.net
> > /XMLRPC: 500 Internal Server Error>
> > 
> > I looked in /var/log/messages on the spacewalk server (I have logging
> > to syslog enabled in postgres for things like this), and saw the
> > following:
> > 
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-1] ERROR:  new row for
> > relation "rhnpackageevr" violates check constraint
> > "vn_rhnpackageevr_epoch"
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-2] CONTEXT:  SQL
> > statement "INSERT INTO rhnPackageEvr (id, epoch, version, release,
> > evr) VALUES (nextval('rhn_pkg_evr_seq'),  $1 ,  $2 ,  $3 ,EVR_T( $1 ,
> > $2 ,  $3 ))"
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-3] #011PL/pgSQL
> > function "lookup_evr" line 10 at SQL statement
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-4] #011SQL statement
> > "SELECT LOOKUP_EVR( $1 ,  $2 ,  $3 )"
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-5] #011PL/pgSQL
> > function "lookup_transaction_package" line 20 at SQL statement
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-6] STATEMENT:
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-7] #011    insert into
> > rhnPackageDeltaElement
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-8] #011
> > (package_delta_id, transaction_package_id)
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-9] #011    values
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-10] #011           (9240,
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-11] #011
> > lookup_transaction_package(E'insert', E'389-ds-base', E'',
> > E'1.2.9.14', E'1.el6', NULL))
> > Jan 17 21:25:05 ordmantell postgres[22246]: [3-12] #011
> > 
> > Hope that helps...
> 
> Can you try to patch your server_kickstart.py with
> 
> diff --git a/backend/server/rhnServer/server_kickstart.py b/backend/server/rhnServer/server_kickstart.py
> index 7ba167b..0eca170 100644
> --- a/backend/server/rhnServer/server_kickstart.py
> +++ b/backend/server/rhnServer/server_kickstart.py
> @@ -580,8 +580,7 @@ def _packages_from_cursor(cursor):
>              # We ignore GPG public keys since they are too weird to schedule
>              # as a package delta
>              continue
> -        result.append((p_name, row['version'], row['release'],
> -            row['epoch'] or ''))
> +        result.append((p_name, row['version'], row['release'], row['epoch']))
>      return result
>  
>  _query_lookup_pending_kickstart_sessions = rhnSQL.Statement("""
> 
> restart httpd and see if it fixes the problem for you?

I've pushed this change now anyway.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat