[Spacewalk-list] Can update sl6 machine connected to PostgreSQL 1.3 nightly
E. Tiesinga
tiesinga at astro.rug.nl
Fri Jan 21 15:08:23 UTC 2011
Helo List,
I can not update a scientific linux 6. (EL6)
The spacewalk server is a PostgreSQL 1.3 nightly install running on
centos 5.5
I have made channels on the server and filled it with packages from the
scientific linux rolling6 repo.
After that i register a SL6 machine. I used 'rhnreg_ks
--activationkey=1-test --serverUrl=http://satellite/XMLRPC'
The client spacewalk rpm's are from the 1.3 nightly RHEL6 repo.
On the server the system is visible and all information is availible.
I can see that the system is not up2date. If i now check the packages
for update te server is waiting on a request from the
client.
I can force this to us the command line tool rhn_check on the client.
rhn_check gives the following messages XMLRPC ProtocolError:
<ProtocolError for satellite /XMLRPC: 500 Internal Server Error>
Who can help me to fix this.
Eite Tiesinga
I get the following mail from the server:
Exception reported from satellite
Time: Fri Jan 21 15:19:19 2011
Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function queue.get
Request object information:
URI: /XMLRPC
Remote Host: pegasus01.intra.astro.rug.nl
Server Name: 127.0.0.1:0
Headers passed in:
Accept-Encoding: identity
Content-Length: 2686
Host: satellite
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: packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(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.3.9-1.el6
Extra information about this error:
SQL Error generated: ('syntax error at or near "name" at character 38\n', 0, '\n select distinct\n pn.name name,\n pe.epoch epoch,\n pe.version version,\n pe.release release,\n pa.label arch\n from rhnActionPackage ap,\n rhnPackage p,\n rhnPackageName pn,\n rhnPackageEVR pe,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is not null\n and ap.evr_id = p.evr_id\n and ap.evr_id = pe.id\n and ap.name_id = p.name_id\n and ap.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s\n union\n select distinct\n pn.name name,\n null version,\n null release,\n null epoch,\n pa.label arch\n from rhnActionPackage ap,\n rhnPackag!
e p,\n rhnPackageName pn,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is null\n and ap.name_id = p.name_id\n and p.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s')
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py", line 118, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 326, in get
ret = self.__getV2(action)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 84, in __getV2
result = method(self.server_id, action['id'], dry_run)
File "/usr/lib/python2.4/site-packages/spacewalk/server/action/packages.py", line 112, in update
h.execute(serverid=serverId, actionid=actionId)
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 263, in _execute_wrapper
raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
SQLStatementPrepareError: ('syntax error at or near "name" at character 38\n', 0, '\n select distinct\n pn.name name,\n pe.epoch epoch,\n pe.version version,\n pe.release release,\n pa.label arch\n from rhnActionPackage ap,\n rhnPackage p,\n rhnPackageName pn,\n rhnPackageEVR pe,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is not null\n and ap.evr_id = p.evr_id\n and ap.evr_id = pe.id\n and ap.name_id = p.name_id\n and ap.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s\n union\n select distinct\n pn.name name,\n null version,\n null release,\n null epoch,\n pa.label arch\n from rhnActionPackage ap,\n rhnP!
ackage p,\n rhnPackageName pn,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is null\n and ap.name_id = p.name_id\n and p.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s')
Local variables by frame
Frame _execute_wrapper in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 263
function =<type 'instancemethod'> <bound method Cursor._execute of<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab0d2d4dfc8>>
e =<type 'instance'> syntax error at or near "name" at character 38
self =<type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab0d2d4dfc8>
value =<type 'int'> 6
p =<type 'tuple'> ()
kw =<type 'dict'> {'serverid': 1000010000, 'actionid': 6}
key =<type 'str'> actionid
params =<type 'str'> serverid: 1000010000,actionid: 6
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 0x2ab0d2d4dfc8>
kw =<type 'dict'> {'serverid': 1000010000, 'actionid': 6}
Frame update in /usr/lib/python2.4/site-packages/spacewalk/server/action/packages.py at line 112
h =<type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab0d2d4dfc8>
serverId =<type 'int'> 1000010000
actionId =<type 'int'> 6
dry_run =<type 'int'> 0
Frame __getV2 in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 84
action =<type 'dict'> {'id': 6, 'method': 'packages.update', 'version': 2, 'remaining_tries': 10, 'unlocked_only': 'Y', 'prerequisite': None}
self =<type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2ab0d2d2dbd8>
method =<type 'function'> <function update at 0x2ab0d2d50578>
dry_run =<type 'int'> 0
Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 347
status =<type 'dict'> {'uname': ['Linux', 'rpmbuilder', '2.6.32-71.7.1.el6.x86_64', '#1 SMP Fri Nov 26 22:10:15 CST 2010', 'x86_64'], 'uptime': [4951, 4731]}
h =<type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab0d2d4dea8>
self =<type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2ab0d2d2dbd8>
ret =<type 'dict'> {}
version =<type 'int'> 2
system_id =<type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>sl-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: sl-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>1d5e32bd6e76233bf00a92828201e3de</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>rpmbuilder</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010000</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</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>
should_execute =<type 'int'> 0
action =<type 'dict'> {'id': 6, 'method': 'packages.update', 'version': 2, 'remaining_tries': 10, 'unlocked_only': 'Y', 'prerequisite': None}
server_locked =<type 'int'> 0
action_id =<type 'int'> 6
Frame call_function in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 164
e =<type 'instance'> ('syntax error at or near "name" at character 38\n', 0, '\n select distinct\n pn.name name,\n pe.epoch epoch,\n pe.version version,\n pe.release release,\n pa.label arch\n from rhnActionPackage ap,\n rhnPackage p,\n rhnPackageName pn,\n rhnPackageEVR pe,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is not null\n and ap.evr_id = p.evr_id\n and ap.evr_id = pe.id\n and ap.name_id = p.name_id\n and ap.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s\n union\n select distinct\n pn.name name,\n null version,\n null release,\n null epoch,\n pa.label arch\n from rhnActionPackage a!
p,\n rhnPackage p,\n rhnPackageName pn,\n rhnPackageArch pa,\n rhnServerChannel sc,\n rhnChannelPackage cp\n where ap.action_id = %(actionid)s\n and ap.evr_id is null\n and ap.name_id = p.name_id\n and p.name_id = pn.id\n and ap.package_arch_id = pa.id(+)\n and p.id = cp.package_id\n and cp.channel_id = sc.channel_id\n and sc.server_id = %(serverid)s')
self =<type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2ab0d2d2da28>
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>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>sl-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: sl-release\nRelease: 6\nCPU Arch: x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>1d5e32bd6e76233bf00a92828201e3de</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>rpmbuilder</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010000</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</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', 2, {'uname': ['Linux', 'rpmbuilder', '2.6.32-71.7.1.el6.x86_64', '#1 SMP Fri Nov 26 22:10:15 CST 2010', 'x86_64'], 'uptime': [4951, 4731]})
func =<type 'instancemethod'> <bound method Queue.get of<server.handlers.xmlrpc.queue.Queue instance at 0x2ab0d2d2dbd8>>
method =<type 'unicode'> queue.get
Frame process in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 471
fd =<type 'instance'> <cStringIO.StringO object at 0x2ab0caea27d8>
_body =<type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>queue.get</methodName>
<params>
<param>
<value><string><?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>sl-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: sl-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>1d5e32bd6e76233bf00a92828201e3de</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>rpmbuilder</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010000</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</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>
<param>
<value><int>2</int></value>
</param>
<param>
<value><struct>
<member>
<name>uname</name>
<value><array><data>
<value><string>Linux</string></value>
<value><string>rpmbuilder</string></value>
<value><string>2.6.32-71.7.1.el6.x86_64</string></value>
<value><string>#1 SMP Fri Nov 26 22:10:15 CST 2010</string></value>
<value><string>x86_64</string></value>
</data></array></value>
</member>
<member>
<name>uptime</name>
<value><array><data>
<value><int>4951</int></value>
<value><int>4731</int></value>
</data></array></value>
</member>
</struct></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>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>sl-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: sl-release\nRelease: 6\nCPU Arch: x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>1d5e32bd6e76233bf00a92828201e3de</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>rpmbuilder</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010000</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</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', 2, {'uname': ['Linux', 'rpmbuilder', '2.6.32-71.7.1.el6.x86_64', '#1 SMP Fri Nov 26 22:10:15 CST 2010', 'x86_64'], 'uptime': [4951, 4731]})
method =<type 'unicode'> queue.get
self =<type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2ab0d2d2da28>
Frame handler in /usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at line 193
h =<type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2ab0d2d2d8c0>
self =<type 'instance'> <spacewalk.server.apacheHandler.apacheHandler instance at 0x2ab0cd56d170>
req =<type 'mp_request'> <mp_request object at 0x2ab0cbc61050>
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': 'satellite'}
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 0x2ab0cbc61050>
self =<type 'instance'> <mod_python.apache.CallBack instance at 0x2ab0cbc59b48>
object =<type 'instancemethod'> <bound method apacheHandler.handler of<spacewalk.server.apacheHandler.apacheHandler instance at 0x2ab0cd56d170>>
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=11721 on exception:
LANG = C
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PWD = /
SHLVL = 2
TERM = xterm
_ = /usr/sbin/httpd
--
Eite Tiesinga
Kapteyn Astronomical Institute
University of Groningen
Computer group
Landleven 12 (Zernike building)
9747 AD Groningen
the Netherlands
Phone: +31 (0)50-3634017
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110121/37c6c7ba/attachment.htm>
More information about the Spacewalk-list
mailing list