[Spacewalk-list] Sync profile failure

Tue Sep 23 13:58:45 UTC 2008

Hi there,

I'm getting an error when trying to sync my server profile with
Spacewalk.  This started when 0.2 was installed.  As a result, the
systems overview page doesn't reflect the current status of the system
correctly, showing packages that need to be installed.  If you choose
details on a specific system, however, the details page shows
everything up to date.

This information is from the up2date log on the client system:

[Tue Sep 23 09:31:48 2008] up2date updateLoginInfo() login info
[Tue Sep 23 09:31:49 2008] up2date logging into up2date server
[Tue Sep 23 09:31:51 2008] up2date successfully retrieved
authentication token from up2date server
[Tue Sep 23 09:31:51 2008] up2date Updating package profile
[Tue Sep 23 09:31:57 2008] up2date A protocol error occurred: Internal
Server Error , attempt #1,
[Tue Sep 23 09:32:18 2008] up2date A protocol error occurred: Internal
Server Error , attempt #2,
[Tue Sep 23 09:33:15 2008] up2date A protocol error occurred: Internal
Server Error , attempt #3,
[Tue Sep 23 09:34:12 2008] up2date A protocol error occurred: Internal
Server Error , attempt #4,
[Tue Sep 23 09:36:03 2008] up2date A protocol error occurred: Internal
Server Error , attempt #5,
[Tue Sep 23 09:36:03 2008] up2date Error communicating with server.
The message was:
Internal Server Error
[Tue Sep 23 09:36:03 2008] up2date
Traceback (most recent call last):
  File "/usr/sbin/rhn-profile-sync", line 54, in ?
    cli.run()
  File "/usr/share/rhn/up2date_client/rhncli.py", line 65, in run
    sys.exit(self.main() or 0)
  File "/usr/sbin/rhn-profile-sync", line 42, in main
    rhnPackageInfo.updatePackageProfile()
  File "/usr/share/rhn/up2date_client/rhnPackageInfo.py", line 27, in
updatePackageProfile
    rpmUtils.getInstalledPackageList(getArch=1))
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 50, in __call__
    return rpcServer.doCall(method, *args, **kwargs)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 263, in doCall
    raise up2dateErrors.CommunicationError(e.errmsg)
up2date_client.up2dateErrors.CommunicationError: Error communicating
with server. The message was:
Internal Server Error

On the Spacewalk server, I have the following in the rhn_server_xmlrpc.log file:

2008/09/23 09:48:19 -04:00 21923 192.168.1.1:
rhnSQL/int_oracle.check_connection('ERROR', "DATABASE CONNECTION TO
'xe' LOST", "Exception information: (3114, 'ORA-03114: not connected
to ORACLE\\n', 'select sysdate as ID from dual')")
2008/09/23 09:48:19 -04:00 21923 192.168.1.1:
rhnSQL/int_oracle.connect('Connecting to database', 'xe')
2008/09/23 09:48:19 -04:00 21923 192.168.1.1: xmlrpc/up2date.login(1000010000,)
2008/09/23 09:48:20 -04:00 30476 192.168.1.1:
rhnSQL/int_oracle.check_connection('ERROR', "DATABASE CONNECTION TO
'xe' LOST", "Exception information: ('Can not prepare statement',
(3114, 'ORA-03114: not connected to ORACLE', ''))")
2008/09/23 09:48:20 -04:00 30476 192.168.1.1:
rhnSQL/int_oracle.connect('Connecting to database', 'xe')
2008/09/23 09:48:21 -04:00 30476 192.168.1.1:
xmlrpc/registration.update_packages(1000010000, 'packages: 653')

So it appears that Oracle is to blame (again) ...  I looked at the
oracle status during this transaction and I have the following :

[root at dev rhn]# /sbin/service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-SEP-2008 09:49:07

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                19-SEP-2008 16:12:01
Uptime                    3 days 17 hr. 37 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=9000))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

I'm not familiar with Oracle, so I could use some assistance.  Is the
above problem caused by the single handler instance?  Can that be
increased?  Or is it something else causing the problem?

Thanks!

-- 
Jason 'XenoPhage' Frisvold
XenoPhage0 at gmail.com
http://blog.godshell.com