[Spacewalk-list] Sync profile failure
Jason Frisvold
xenophage0 at gmail.com
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
More information about the Spacewalk-list
mailing list