[Spacewalk-list] Oracle traceback from clients behind a proxy
Tom Brown
tom at ng23.net
Wed Jul 14 21:23:19 UTC 2010
Hi - The following just started to be produced this evening. Has
anyone ever seen this or know where to look? These are being generated
for all clients behind a certain proxy but nothing has been changed.
thanks
Exception reported from spacewalk-server-hostname
Time: Wed Jul 14 20:59:08 2010
Exception type server.rhnSQL.sql_base.SQLError
Exception while handling function up2date.login
Request object information:
URI: /XMLRPC
Remote Host: spacewalk-proxy-hostname
Server Name: spacewalk-server-hostname:443
Headers passed in:
Accept-Encoding: identity, identity
Content-Length: 2171
Host: spacewalk-server-hostname:443
X-RHN-IP-Path: 10.70.177.13
X-RHN-Proxy-Auth:
1000010117::1279125338.15:21600.0:3sCQD1DShfigQWYQV1DDdw==:spacewalk-proxy-hostname
X-RHN-Proxy-Version: 5.3.1
X-RHN-Transport-Capability: follow-redirects=3
content-type: text/xml
user-agent: rhn.rpclib.py/$Revision$
x-client-version: 1
x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
x-rhn-client-capability:
kickstart_guest.initiate(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,caneatCheese(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,kickstart.initiate(1)=1,packages.rollBack(1)=1,kickstart_guest.initiate(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,caneatCheese(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,kickstart.initiate(1)=1,packages.rollBack(1)=1
x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc
(version $Revision$)
x-up2date-version: 1.0.6-1.el5
Extra information about this error:
SQL Error generated: (2291, 'ORA-02291: integrity constraint
(SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key not found\n',
'insert into rhnServerPath (server_id, proxy_server_id, position,
hostname) values (:server_id, :proxy_server_id, :position,
:hostname)')
Exception Handler Information
Traceback (most recent call last):
File "/usr/share/rhn/server/apacheRequest.py", line 120, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 143, in login
server_route.store_client_route(self.server_id)
File "/usr/share/rhn/server/rhnServer/server_route.py", line 106, in
store_client_route
position=positions, hostname=proxy_hostnames)
File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 177, in executemany
return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 119,
in _execute_wrapper
raise apply(sql_base.SQLError, ret)
SQLError: (2291, 'ORA-02291: integrity constraint
(SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key not found\n',
'insert into rhnServerPath (server_id, proxy_server_id, position,
hostname) values (:server_id, :proxy_server_id, :position,
:hostname)')
Local variables by frame
Frame _execute_wrapper in
/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py at line 119
function = <type 'instancemethod'> <bound method
Cursor._executemany of <__builtin__.OracleCursor on
<cx_Oracle.Connection to SPACEWALK at SPACEWALK>>>
e = <type 'instance'> ORA-02291: integrity
constraint (SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key
not found
errno = <type 'int'> 2291
self = <type 'instance'> <__builtin__.OracleCursor on
<cx_Oracle.Connection to SPACEWALK at SPACEWALK>>
modified_params = <type 'list'> []
value = <type 'list'> [0]
p = <type 'tuple'> ()
params = <type 'str'> proxy_server_id:
['1000010117'],server_id: [1000010174],hostname:
['spacewalk-proxy-hostname'],position: [0]
ret = <type 'tuple'> (2291, 'ORA-02291: integrity
constraint (SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key
not found\n', 'insert into rhnServerPath (server_id, proxy_server_id,
position, hostname) values (:server_id, :proxy_server_id, :position,
:hostname)')
key = <type 'str'> position
kw = <type 'dict'> {'proxy_server_id':
['1000010117'], 'server_id': [1000010174], 'hostname':
['spacewalk-proxy-hostname'], 'position': [0]}
errmsg = <type 'str'> ORA-02291: integrity constraint
(SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key not found
Frame executemany in /usr/share/rhn/server/rhnSQL/sql_base.py at line 177
p = <type 'tuple'> ()
self = <type 'instance'> <__builtin__.OracleCursor on
<cx_Oracle.Connection to SPACEWALK at SPACEWALK>>
kw = <type 'dict'> {'proxy_server_id':
['1000010117'], 'server_id': [1000010174], 'hostname':
['spacewalk-proxy-hostname'], 'position': [0]}
Frame store_client_route in
/usr/share/rhn/server/rhnServer/server_route.py at line 106
proxy_id = <type 'str'> 1000010117
proxy_ids = <type 'list'> ['1000010117']
hostname = <type 'str'> spacewalk-proxy-hostname
newRoute = <type 'list'> [('1000010117',
'spacewalk-proxy-hostname')]
server_ids = <type 'list'> [1000010174]
h = <type 'instance'> <__builtin__.OracleCursor on
<cx_Oracle.Connection to SPACEWALK at SPACEWALK>>
proxy_hostname = <type 'str'> spacewalk-proxy-hostname
counter = <type 'int'> 1
oldRoute = <type 'list'> []
tokens = <type 'list'>
['1000010117::1279125338.15:21600.0:3sCQD1DShfigQWYQV1DDdw==:spacewalk-proxy-hostname']
p = <type 'tuple'> ('1000010117',
'spacewalk-proxy-hostname')
token = <type 'list'> ['1000010117', '',
'1279125338.15', '21600.0', '3sCQD1DShfigQWYQV1DDdw==']
positions = <type 'list'> [0]
proxy_hostnames = <type 'list'> ['spacewalk-proxy-hostname']
server_id = <type 'int'> 1000010174
Frame login in /usr/share/rhn/server/handlers/xmlrpc/up2date.py at line 143
channels = <type 'list'> [['centos-5-x86_64-10062010',
'20100705135043', '1', '1']]
v = <type 'str'> 3600.0
self = <type 'instance'>
<server.handlers.xmlrpc.up2date.Up2date instance at 0x2b307d36eb48>
rhnServerTime = <type 'str'> 1279141148.98
k = <type 'str'> X-RHN-Auth-Expire-Offset
signature = <type 'str'> CGz17ELtpXpsXW/NvSz/5w==
flag = <type 'str'> 1
server = <class 'server.rhnServer.server_class.Server'>
<Server Class at 47487259369808: {'self.cert': None, 'self.server':
{'info': (None, 0), 'creator_id': (1, 0), 'provision_state_id': (None,
0), 'name': ('spacewalk-client-hostname', 0), 'created':
(datetime.datetime(2010, 7, 14, 13, 52, 43), 0), 'auto_update': ('N',
0), 'running_kernel': ('2.6.18-194.3.1.el5xen', 0), 'description':
('Initial Registration Parameters:\nOS: centos-release\nRelease:
5\nCPU Arch: x86_64-redhat-linux', 0), 'org_id': (1, 0), 'modified':
(datetime.datetime(2010, 7, 14, 15, 59, 8), 0), 'server_arch_id':
(1023, 0), 'secret': ('f5580fa50c4175c08c79bda2e03c6619', 0),
'last_boot': (1279115377.4200001, 0), 'digital_server_id':
('ID-1000010174', 0), 'release': ('5', 0), 'channels_changed':
(datetime.datetime(2010, 7, 14, 13, 52, 43), 0), 'auto_deliver': ('N',
0), 'os': ('centos-release', 0), 'id': (1000010174, 0), 'cobbler_id':
(None, 0)}}>
expireOffset = <type 'str'> 3600.0
loginDict = <type 'dict'> {'X-RHN-Server-Id': 1000010174,
'X-RHN-Auth-Server-Time': '1279141148.98', 'X-RHN-Auth-Channels':
[['centos-5-x86_64-10062010', '20100705135043', '1', '1']],
'X-RHN-Auth': 'CGz17ELtpXpsXW/NvSz/5w==', 'X-RHN-Auth-User-Id': '',
'X-RHN-Auth-Expire-Offset': '3600.0'}
system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>username</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>7613771096f27e7101dbe009b7b2e314</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>spacewalk-client-hostname</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010174</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
transport = <type 'instance'> {'x-rhn-server-capability':
['registration.finish_message(1)=1',
'registration.remaining_subscriptions(1)=1',
'registration.update_contact_info(1)=1',
'applet.has_base_channel(1)=1', 'registration.smbios(1)=1',
'registration.extended_update_support(1)=1',
'rhncfg.filetype.directory(1)=1', 'rhncfg.content.base64_decode(1)=1',
'registration.register_osad(1)=1', 'registration.delta_packages(1)=1',
'xmlrpc.packages.extended_profile(1-2)=1',
'xmlrpc.login.extra_data(1)=1'], 'x-rhn-server-id': 1000010174,
'x-rhn-proxy-version': '5.3.1', 'x-rhn-client-version': '1',
'x-rhn-auth-server-time': '1279141148.98', 'x-rhn-auth-channels':
['centos-5-x86_64-10062010:20100705135043:1:1'], 'x-rhn-action':
'login', 'x-rhn-auth': 'CGz17ELtpXpsXW/NvSz/5w==',
'x-rhn-auth-user-id': '', 'x-rhn-auth-expire-offset': '3600.0'}
each = <type 'dict'> {'gpg_key_url': '',
'description': '', 'org_id': '1', 'label': 'centos-5-x86_64-10062010',
'last_modified': '20100705135043', 'local_channel': '1',
'parent_channel': '', 'summary': 'centos-5-x86_64-10062010', 'arch':
'channel-x86_64', 'id': '142', 'name': 'CentOS-5-x86_64-10062010'}
extra_data = <type 'dict'> {}
channelList = <type 'list'> [{'gpg_key_url': '',
'description': '', 'org_id': '1', 'label': 'centos-5-x86_64-10062010',
'last_modified': '20100705135043', 'local_channel': '1',
'parent_channel': '', 'summary': 'centos-5-x86_64-10062010', 'arch':
'channel-x86_64', 'id': '142', 'name': 'CentOS-5-x86_64-10062010'}]
channel = <type 'list'> ['centos-5-x86_64-10062010',
'20100705135043', '1', '1']
Frame call_function in /usr/share/rhn/server/apacheRequest.py at line 166
e = <type 'instance'> (2291, 'ORA-02291: integrity
constraint (SPACEWALK.RHN_SERVERPATH_PSID_FK) violated - parent key
not found\n', 'insert into rhnServerPath (server_id, proxy_server_id,
position, hostname) values (:server_id, :proxy_server_id, :position,
:hostname)')
self = <type 'instance'>
<server.apacheRequest.apachePOST instance at 0x2b307d3d5fc8>
force_rollback = <type 'int'> 1
params = <type 'tuple'> ('<?xml
version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>brownt</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch:
x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>7613771096f27e7101dbe009b7b2e314</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>spacewalk-client-hostname</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010174</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value>
<array><data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n',)
func = <type 'instancemethod'> <bound method
Up2date.login of <server.handlers.xmlrpc.up2date.Up2date instance at
0x2b307d36eb48>>
method = <type 'unicode'> up2date.login
Frame process in /usr/share/rhn/server/apacheRequest.py at line 473
fd = <type 'instance'> <cStringIO.StringO object at
0x2b307106b670>
_body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>up2date.login</methodName>
<params>
<param>
<value><string><?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>brownt</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>7613771096f27e7101dbe009b7b2e314</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>spacewalk-client-hostname</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010174</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
</string></value>
</param>
</params>
</methodCall>
params = <type 'tuple'> ('<?xml
version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>brownt</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch:
x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>7613771096f27e7101dbe009b7b2e314</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>spacewalk-client-hostname</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010174</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value>
<array><data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n',)
method = <type 'unicode'> up2date.login
self = <type 'instance'>
<server.apacheRequest.apachePOST instance at 0x2b307d3d5fc8>
Frame handler in /usr/share/rhn/server/apacheHandler.py at line 198
h = <type 'instance'> <__builtin__.OracleCursor on
<cx_Oracle.Connection to SPACEWALK at SPACEWALK>>
self = <type 'instance'>
<server.apacheHandler.apacheHandler instance at 0x2b30781f0908>
req = <type 'mp_request'> <mp_request object at
0x2b30714fa050>
ret = <type 'int'> 1
templateStrings = <type 'dict'> {'email_account_info':
'\nAccount Information:\n Your Spacewalk login: <login />\n
Your Spacewalk email address: <email-address />', 'email_footer':
'--the Spacewalk Team', 'hostname': 'spacewalk-server-hostname'}
row = <type 'NoneType'> None
Frame __call__ in /usr/share/rhn/server/apacheServer.py at line 58
self = <type 'instance'>
<server.apacheServer.HandlerWrap instance at 0x2b30781e3f38>
req = <type 'mp_request'> <mp_request object at
0x2b30714fa050>
f = <type 'instancemethod'> <bound method
apacheHandler.handler of <server.apacheHandler.apacheHandler instance
at 0x2b30781f0908>>
Frame HandlerDispatch in
/usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299
req = <type 'mp_request'> <mp_request object at
0x2b30714fa050>
config = <type 'mp_table'> {'PythonInterpreter':
'rhn.server', 'PythonPath': 'sys.path+['/usr/share/rhn']'}
self = <type 'instance'> <mod_python.apache.CallBack
instance at 0x2b30714f3b90>
object = <type 'instance'>
<server.apacheServer.HandlerWrap instance at 0x2b30781e3f38>
l = <type 'list'> ['server.apacheServer', 'Handler']
module = <type 'module'> <module 'server.apacheServer'
from '/usr/share/rhn/server/apacheServer.pyc'>
hlist = <type 'mp_hlist'>
{'handler:'server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
object_str = <type 'str'> Handler
debug = <type 'int'> 0
module_name = <type 'str'> server.apacheServer
pathstring = <type 'str'> sys.path+['/usr/share/rhn']
result = <type 'int'> 500
Environment for PID=20366 on exception:
COBBLER_SERVER = xx.xx.xx.xx
G_BROKEN_FILENAMES = 1
HISTSIZE = 500
HOME = /root
HOSTNAME = spacewalk-server-hostname
INPUTRC = /etc/inputrc
LANG = C
LC_COLLATE = C
LD_LIBRARY_PATH = :/usr/lib/oracle/10.2.0.4/client64/lib/
LESSOPEN = |/usr/bin/lesspipe.sh %s
LOGNAME = root
LS_COLORS = no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL = /var/spool/mail/root
NLS_LANG = english.AL32UTF8
ORACLE_HOME = /opt/oracle
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PERL_BADFREE = 0
PWD = /var/log/httpd
SHELL = /bin/bash
SHLVL = 3
TERM = xterm-color
TMOUT = 600
USER = root
_ = /usr/sbin/httpd
More information about the Spacewalk-list
mailing list