Hi,
I'm running a spacewalk 1.6 server on CentOS 5. For some reason I cannot
register any clients anymore - neither CentOS 5 nor 6. The last one was
successfully registered last Thursday and the problem was discovered today. I
already tried to restart spacewalk-service and the whole server. The only
information about a problem is the attached traceback.
It says:
Exception type psycopg2.InternalError
Exception while handling function registration.new_system
...
InternalError: current transaction is aborted, commands ignored until end of
transaction block
...
Can please anybody give me a hint, because I'm currently pretty stuck.
Thanks in advance,
Sascha
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Exception reported from $SERVER_FQDN
Time: Wed Apr 18 11:57:19 2012
Exception type psycopg2.InternalError
Exception while handling function registration.new_system Request object
information:
URI: /XMLRPC
Remote Host: $CLIENT_FQDN
Server Name: $SERVER_FQDN:443 Headers passed in:
Accept-Encoding: identity
Content-Length: 1560
Host: $SERVER_FQDN:443
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:
osad.ping(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.ba
se64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,co
nfigfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload
(1)=1,packages.runTransaction(1)=1
x-rhn-transport-capability: follow-redirects=3
x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc
(version $Revision$)
x-up2date-version: 1.6.47-1.el5
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py",
line 122, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 496, in
new_system
architecture, data)
File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 387, in
create_system
newserv.save(0, channel)
File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_class.py",
line 570, in save
self.__save(channel)
File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_class.py",
line 538, in
__save
user_id=user_id)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py", line
1741, in
subscribe_server_channels
raise_exceptions=1)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py", line
1700, in
guess_channels_for_server
server.org_id, user_id=user_id)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py", line
900, in
channels_for_release_arch
org_id=org_id, user_id=user_id)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py", line
723, in
base_channel_for_rel_arch
org_id=org_id, user_id=user_id)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 163, in execute
return apply(self._execute_wrapper, (self._execute, ) + p, kw)
File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 282, in
_execute_wrapper
retval = apply(function, p, kw)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 217, in _execute
return self._execute_(args, kwargs)
File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 295, in
_execute_
self._real_cursor.execute(self.sql, params)
InternalError: current transaction is aborted, commands ignored until end of
transaction block
Local variables by frame
Frame _execute_ in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
at
line 295
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab95629b200>
args = <type 'tuple'> ()
params = <type 'instance'> {'release': '5', 'org_id':
'1', 'user_id': 1, 'server_arch': 'x86_64-
redhat-linux'}
kwargs = <type 'dict'> {'release': '5', 'user_id': 1,
'org_id': '1', 'server_arch': 'x86_64-
redhat-linux'}
Frame _execute in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 217
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab95629b200>
args = <type 'tuple'> ()
val = <type 'str'> 5
kwargs = <type 'dict'> {'release': '5', 'user_id': 1,
'org_id': '1', 'server_arch': 'x86_64-
redhat-linux'}
Frame _execute_wrapper in /usr/lib/python2.4/site-
packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 287
function = <type 'instancemethod'> <bound method
Cursor._execute of
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab95629b200>>
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab95629b200>
value = <type 'str'> x86_64-redhat-linux
p = <type 'tuple'> ()
kw = <type 'dict'> {'release': '5', 'org_id': '1',
'user_id': 1, 'server_arch': 'x86_64-redhat-
linux'}
key = <type 'str'> server_arch
params = <type 'str'> release: 5,org_id: 1,user_id:
1,server_arch: x86_64-redhat-linux
Frame execute in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 163
p = <type 'tuple'> ()
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab95629b200>
kw = <type 'dict'> {'release': '5', 'user_id': 1,
'org_id': '1', 'server_arch': 'x86_64-redhat-
linux'}
Frame base_channel_for_rel_arch in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py
at line 735
user_id = <type 'int'> 1
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab95629b200>
org_id = <type 'str'> 1
server_arch = <type 'str'> x86_64-redhat-linux
release = <type 'str'> 5
query = <type 'str'>
select ca.label arch,
c.id,
c.parent_channel,
c.org_id,
c.label,
c.name,
c.summary,
c.description,
to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
rhn_channel.available_chan_subscriptions(c.id, :org_id)
available_subscriptions
from rhnChannel c,
rhnChannelArch ca
where c.channel_arch_id = ca.id
and c.id = rhn_channel.base_channel_for_release_arch(
:release, :server_arch, :org_id, :user_id)
Frame channels_for_release_arch in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py
at line 900
release = <type 'str'> 5
org_id = <type 'str'> 1
user_id = <type 'int'> 1
server_arch = <type 'str'> x86_64-redhat-linux
Frame guess_channels_for_server in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py
at line 1727
user_id = <type 'int'> 1
none_ok = <type 'instance'>
<spacewalk.server.rhnServer.server_token.ActivationTokens
instance at 0x2ab956273950>
raise_exceptions = <type 'int'> 1
server = <type 'instance'> <LiteServer instance at
46975502889112: attributes={'release':
'5', 'arch': 'x86_64-redhat-linux', 'org_id': 1, 'id': 1000011055}>
Frame subscribe_server_channels in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnChannel.py
at line 1741
user_id = <type 'int'> 1
s = <type 'instance'> <LiteServer instance at
46975502889112: attributes={'release':
'5', 'arch': 'x86_64-redhat-linux', 'org_id': 1, 'id': 1000011055}>
none_ok = <type 'instance'>
<spacewalk.server.rhnServer.server_token.ActivationTokens
instance at 0x2ab956273950>
server = <class
'spacewalk.server.rhnServer.server_class.Server'> <Server Class at
46975502841232: {'self.cert': None, 'self.server': {'description': ('Initial
Registration Parameters:\nOS:
centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux', 1), 'auto_update':
('N', 1), 'secret':
('4d6243eecfc892d0436f623e97cf430d', 1), 'org_id': (1, 1), 'creator_id': (1,
1), 'server_arch_id': (1023, 1),
'digital_server_id': ('ID-1000011055', 1), 'release': ('5', 1), 'auto_deliver':
('N', 1), 'os': ('centos-release', 1),
'id': (1000011055, 0), 'name': ('$CLIENT_FQDN', 1)}}>
Frame __save in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_class.py at
line
538
server_id = <type 'int'> 1000011055
user_id = <type 'int'> 1
self = <class
'spacewalk.server.rhnServer.server_class.Server'> <Server Class at
46975502841232: {'self.cert': None, 'self.server': {'description': ('Initial
Registration Parameters:\nOS:
centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux', 1), 'auto_update':
('N', 1), 'secret':
('4d6243eecfc892d0436f623e97cf430d', 1), 'org_id': (1, 1), 'creator_id': (1,
1), 'server_arch_id': (1023, 1),
'digital_server_id': ('ID-1000011055', 1), 'release': ('5', 1), 'auto_deliver':
('N', 1), 'os': ('centos-release', 1),
'id': (1000011055, 0), 'name': ('$CLIENT_FQDN', 1)}}>
org_id = <type 'int'> 1
have_reg_token = <type 'instance'>
<spacewalk.server.rhnServer.server_token.ActivationTokens instance at
0x2ab956273950>
channel = <type 'NoneType'> None
Frame save in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_class.py at
line 574
commit = <type 'int'> 0
self = <class
'spacewalk.server.rhnServer.server_class.Server'> <Server Class at
46975502841232: {'self.cert': None, 'self.server': {'description': ('Initial
Registration Parameters:\nOS:
centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux', 1), 'auto_update':
('N', 1), 'secret':
('4d6243eecfc892d0436f623e97cf430d', 1), 'org_id': (1, 1), 'creator_id': (1,
1), 'server_arch_id': (1023, 1),
'digital_server_id': ('ID-1000011055', 1), 'release': ('5', 1), 'auto_deliver':
('N', 1), 'os': ('centos-release', 1),
'id': (1000011055, 0), 'name': ('$CLIENT_FQDN', 1)}}>
channel = <type 'NoneType'> None
Frame create_system in /usr/share/rhn/server/handlers/xmlrpc/registration.py at
line 394
release_version = <type 'str'> 5
user = <type 'NoneType'> None
architecture = <type 'str'> x86_64-redhat-linux
self = <type 'instance'>
<server.handlers.xmlrpc.registration.Registration instance at
0x2ab9562732d8>
applet_uuid = <type 'NoneType'> None
profile_name = <type 'str'> $CLIENT_FQDN
tokens_obj = <type 'instance'>
<spacewalk.server.rhnServer.server_token.ActivationTokens
instance at 0x2ab956273950>
log_item = <type 'str'> token =
'1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2'
token_string = <type 'str'>
1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2
up2date_uuid = <type 'NoneType'> None
data = <type 'dict'> {'token':
'1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2', 'profile_name': '$CLIENT_FQDN',
'architecture':
'x86_64-redhat-linux', 'os_release': '5', 'smbios': {'smbios.system.serial':
'Not Specified',
'smbios.system.product': 'KVM', 'smbios.system.family': 'Red Hat Enterprise
Linux', 'smbios.bios.vendor':
'QEMU', 'smbios.system.manufacturer': 'Red Hat', 'smbios.system.skunumber':
'Not Specified',
'smbios.system.version': 'Not Specified', 'smbios.system.uuid':
'59a2940b-a571-7a45-04f1-
30b438049f5e'}, 'release_name': 'centos-release'}
newserv = <class
'spacewalk.server.rhnServer.server_class.Server'> <Server Class at
46975502841232: {'self.cert': None, 'self.server': {'description': ('Initial
Registration Parameters:\nOS:
centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux', 1), 'auto_update':
('N', 1), 'secret':
('4d6243eecfc892d0436f623e97cf430d', 1), 'org_id': (1, 1), 'creator_id': (1,
1), 'server_arch_id': (1023, 1),
'digital_server_id': ('ID-1000011055', 1), 'release': ('5', 1), 'auto_deliver':
('N', 1), 'os': ('centos-release', 1),
'id': (1000011055, 0), 'name': ('$CLIENT_FQDN', 1)}}>
channel = <type 'NoneType'> None
release = <type 'str'> 5
Frame new_system in /usr/share/rhn/server/handlers/xmlrpc/registration.py at
line 496
self = <type 'instance'>
<server.handlers.xmlrpc.registration.Registration instance at
0x2ab9562732d8>
release_version = <type 'str'> 5
profile_name = <type 'str'> $CLIENT_FQDN
architecture = <type 'str'> x86_64-redhat-linux
data = <type 'dict'> {'token':
'1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2', 'profile_name': '$CLIENT_FQDN',
'architecture':
'x86_64-redhat-linux', 'os_release': '5', 'smbios': {'smbios.system.serial':
'Not Specified',
'smbios.system.product': 'KVM', 'smbios.system.family': 'Red Hat Enterprise
Linux', 'smbios.bios.vendor':
'QEMU', 'smbios.system.manufacturer': 'Red Hat', 'smbios.system.skunumber':
'Not Specified',
'smbios.system.version': 'Not Specified', 'smbios.system.uuid':
'59a2940b-a571-7a45-04f1-
30b438049f5e'}, 'release_name': 'centos-release'}
user = <type 'NoneType'> None
Frame call_function in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 174
self = <type 'instance'>
<spacewalk.server.apacheRequest.apachePOST instance at
0x2ab956273098>
params = <type 'tuple'> ({'token':
'1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2', 'profile_name': '$CLIENT_FQDN',
'architecture':
'x86_64-redhat-linux', 'os_release': '5', 'smbios': {'smbios.system.serial':
'Not Specified',
'smbios.system.product': 'KVM', 'smbios.system.family': 'Red Hat Enterprise
Linux', 'smbios.bios.vendor':
'QEMU', 'smbios.system.manufacturer': 'Red Hat', 'smbios.system.skunumber':
'Not Specified',
'smbios.system.version': 'Not Specified', 'smbios.system.uuid':
'59a2940b-a571-7a45-04f1-
30b438049f5e'}, 'release_name': 'centos-release'},)
force_rollback = <type 'int'> 1
func = <type 'instancemethod'> <bound method
Registration.new_system of
<server.handlers.xmlrpc.registration.Registration instance at 0x2ab9562732d8>>
method = <type 'unicode'> registration.new_system
Frame process in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 476
fd = <type 'instance'> <cStringIO.StringO object at
0x2ab9503997d8>
_body = <type 'str'> <?xml version='1.0'?> <methodCall>
<methodName>registration.new_system</methodName>
<params>
<param>
<value><struct>
<member>
<name>token</name>
<value><string>1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>$CLIENT_FQDN</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>smbios</name>
<value><struct>
<member>
<name>smbios.system.serial</name>
<value><string>Not Specified</string></value> </member> <member>
<name>smbios.system.product</name>
<value><string>KVM</string></value>
</member>
<member>
<name>smbios.system.family</name>
<value><string>Red Hat Enterprise Linux</string></value> </member> <member>
<name>smbios.bios.vendor</name> <value><string>QEMU</string></value>
</member>
<member>
<name>smbios.system.manufacturer</name>
<value><string>Red Hat</string></value>
</member>
<member>
<name>smbios.system.skunumber</name>
<value><string>Not Specified</string></value> </member> <member>
<name>smbios.system.version</name>
<value><string>Not Specified</string></value> </member> <member>
<name>smbios.system.uuid</name> <value><string>59a2940b-a571-7a45-04f1-
30b438049f5e</string></value>
</member>
</struct></value>
</member>
<member>
<name>release_name</name>
<value><string>centos-release</string></value>
</member>
</struct></value>
</param>
</params>
</methodCall>
params = <type 'tuple'> ({'token':
'1-7b1bddf9e60f9327ce8a0e0fee42d4d7,1-
b425e5b7198bd40de578d5c8a0a646c2', 'profile_name': '$CLIENT_FQDN',
'architecture':
'x86_64-redhat-linux', 'os_release': '5', 'smbios': {'smbios.system.serial':
'Not Specified',
'smbios.system.product': 'KVM', 'smbios.system.family': 'Red Hat Enterprise
Linux', 'smbios.bios.vendor':
'QEMU', 'smbios.system.manufacturer': 'Red Hat', 'smbios.system.skunumber':
'Not Specified',
'smbios.system.version': 'Not Specified', 'smbios.system.uuid':
'59a2940b-a571-7a45-04f1-
30b438049f5e'}, 'release_name': 'centos-release'},)
method = <type 'unicode'> registration.new_system
self = <type 'instance'>
<spacewalk.server.apacheRequest.apachePOST instance at
0x2ab956273098>
Frame handler in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at line 196
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2ab956231ef0>
self = <type 'instance'>
<spacewalk.server.apacheHandler.apacheHandler instance at
0x2ab9543fc488>
req = <type 'mp_request'> <mp_request object at
0x2ab93908f050>
ret = <type 'int'> 0
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': '$SERVER_FQDN'}
row = <type 'NoneType'> None
Frame HandlerDispatch in
/usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299
req = <type 'mp_request'> <mp_request object at
0x2ab93908f050>
self = <type 'instance'> <mod_python.apache.CallBack
instance at 0x2ab93908e128>
object = <type 'instancemethod'> <bound method
apacheHandler.handler of
<spacewalk.server.apacheHandler.apacheHandler instance at 0x2ab9543fc488>>
l = <type 'list'> ['spacewalk.server.apacheServer',
'Handler']
module = <type 'module'> <module
'spacewalk.server.apacheServer' from
'/usr/lib/python2.4/site-packages/spacewalk/server/apacheServer.pyc'>
hlist = <type 'mp_hlist'>
{'handler:'spacewalk.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
object_str = <type 'str'> Handler
debug = <type 'int'> 0
module_name = <type 'str'> spacewalk.server.apacheServer
config = <type 'mp_table'> {'PythonInterpreter':
'rhn.server'}
dir = <type 'str'> /XMLRPC/
result = <type 'int'> 500
Environment for PID=4468 on exception:
CONSOLE = /dev/console
HOME = /
INIT_VERSION = sysvinit-2.86
LANG = C
NLS_LANG = english.AL32UTF8
ORACLE_HOME = /opt/oracle
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PREVLEVEL = N
PWD = /
RUNLEVEL = 3
SELINUX_INIT = YES
SHLVL = 3
TERM = linux
_ = /usr/sbin/httpd
previous = N
runlevel = 3
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
