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

[Jan Pazdziora]

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?

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