Hello
When trying to do an rhn_check on a client machine i am getting this error :
rhn_check -v
XMLRPC ProtocolError: <ProtocolError for FOO /XMLRPC: 500 Internal Server Error>
and i am getting the email (below) from the server .
Can you tell me what is the issue ?
Thank you
>
>
> Exception reported from FOO
> Time: Wed Apr 13 10:04:56 2011
> Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
> Exception while handling function queue.get
> Request object information:
> URI: /XMLRPC
> Remote Host: X.X.X.X
> Server Name: FOO0
> Headers passed in:
> Accept-Encoding: identity
> Content-Length: 2715
> Host: FOO
> 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.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.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.3.12-1.el6
> Extra information about this error:
> SQL Error generated: ('syntax error at or near ")" at character 1296\n', 0,
> "\n select cfn.path,\n cc.label config_channel,\n
> ccont.contents file_contents,\n ccont.is_binary is_binary,\n
> c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
> ccont.delim_end,\n cr.revision,\n ci.username,\n
> ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
> ci.selinux_ctx,\n case \n when cft.label='symlink'
> then (select path from rhnConfigFileName where id =
> ci.SYMLINK_TARGET_FILENAME_ID)\n else ''\n end as
> symlink\t \n from \n rhnConfigFileState cfs,\n
> rhnConfigContent ccont,\n rhnChecksumView c,\n
> rhnConfigChannel cc,\n rhnConfigFileName cfn,\n
> rhnConfigInfo ci,\n rhnConfigFile cf,\n rhnConfigRevision
> cr,\n\t rhnConfigFileType c!
ft,
> \n rhnActionConfigRevision acr\n where acr.server_id =
> %(server_id)s\n and acr.action_id = %(action_id)s\n and
> acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
> and cr.config_info_id = ci.id\n and cf.config_file_name_id = cfn.id\n
> and cf.config_channel_id = cc.id\n and cf.state_id = cfs.id\n
> and cfs.label = 'alive'\n and cr.config_content_id = ccont.id (+)\n
> and cr.config_file_type_id = cft.id\n and ccont.checksum_id =
> c.id(+)\n")
>
> 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/configfiles.py",
> line 103, in deploy
> return _get_files(server_id, action_id)
> File
> "/usr/lib/python2.4/site-packages/spacewalk/server/action/configfiles.py",
> line 159, in _get_files
> h.execute(action_id=action_id, server_id=server_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 268, in _execute_wrapper
> raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
> SQLStatementPrepareError: ('syntax error at or near ")" at character 1296\n',
> 0, "\n select cfn.path,\n cc.label config_channel,\n
> ccont.contents file_contents,\n ccont.is_binary is_binary,\n
> c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
> ccont.delim_end,\n cr.revision,\n ci.username,\n
> ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
> ci.selinux_ctx,\n case \n when cft.label='symlink'
> then (select path from rhnConfigFileName where id =
> ci.SYMLINK_TARGET_FILENAME_ID)\n else ''\n end as
> symlink\t \n from \n rhnConfigFileState cfs,\n
> rhnConfigContent ccont,\n rhnChecksumView c,\n
> rhnConfigChannel cc,\n rhnConfigFileName cfn,\n
> rhnConfigInfo ci,\n rhnConfigFile cf,\n rhnConfigRevision
> cr,\n\t rhnConfigFileT!
ype
> cft,\n rhnActionConfigRevision acr\n where acr.server_id =
> %(server_id)s\n and acr.action_id = %(action_id)s\n and
> acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
> and cr.config_info_id = ci.id\n and cf.config_file_name_id = cfn.id\n
> and cf.config_channel_id = cc.id\n and cf.state_id = cfs.id\n
> and cfs.label = 'alive'\n and cr.config_content_id = ccont.id (+)\n
> and cr.config_file_type_id = cft.id\n and ccont.checksum_id =
> c.id(+)\n")
>
> Local variables by frame
> Frame _execute_wrapper in
> /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
> at line 268
> function = <type 'instancemethod'> <bound method
> Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance
> at 0x2b8291c412d8>>
> e = <type 'instance'> syntax error at or near ")" at
> character 1296
>
> self = <type 'instance'>
> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b8291c412d8>
> value = <type 'int'> 6
> p = <type 'tuple'> ()
> kw = <type 'dict'> {'server_id': 1000010000,
> 'action_id': 6}
> key = <type 'str'> action_id
> params = <type 'str'> server_id: 1000010000,action_id: 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 0x2b8291c412d8>
> kw = <type 'dict'> {'server_id': 1000010000,
> 'action_id': 6}
>
> Frame _get_files in
> /usr/lib/python2.4/site-packages/spacewalk/server/action/configfiles.py at
> line 159
> h = <type 'instance'>
> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b8291c412d8>
> server_id = <type 'int'> 1000010000
> action_id = <type 'int'> 6
>
> Frame deploy in
> /usr/lib/python2.4/site-packages/spacewalk/server/action/configfiles.py at
> line 103
> server_id = <type 'int'> 1000010000
> dry_run = <type 'int'> 0
> action_id = <type 'int'> 6
>
> Frame __getV2 in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 84
> action = <type 'dict'> {'id': 6, 'method':
> 'configfiles.deploy', 'version': 2, 'remaining_tries': 5, 'unlocked_only':
> 'Y', 'prerequisite': None}
> self = <type 'instance'>
> <server.handlers.xmlrpc.queue.Queue instance at 0x2b8291346290>
> method = <type 'function'> <function deploy at
> 0x2b8291c6a230>
> dry_run = <type 'int'> 0
>
> Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 347
> status = <type 'dict'> {'uname': ['Linux', 'FAA',
> '2.6.32-71.24.1.el6.x86_64', '#1 SMP Sat Mar 26 16:05:19 EDT 2011',
> 'x86_64'], 'uptime': [125141, 3000693]}
> h = <type 'instance'>
> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b8291c55c68>
> self = <type 'instance'>
> <server.handlers.xmlrpc.queue.Queue instance at 0x2b8291346290>
> 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>assaff</string></value>
> </member>
> <member>
> <name>operating_system</name>
> <value><string>redhat-release-server</string></value>
> </member>
> <member>
> <name>description</name>
> <value><string>Initial Registration Parameters:
> OS: redhat-release-server
> Release: 6Server
> CPU Arch: x86_64</string></value>
> </member>
> <member>
> <name>checksum</name>
> <value><string>d4ecb5cac5581172dd3e32f6dcdb962c</string></value>
> </member>
> <member>
> <name>profile_name</name>
> <value><string>FAA</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>6Server</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':
> 'configfiles.deploy', 'version': 2, 'remaining_tries': 5, '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 ")"
> at character 1296\n', 0, "\n select cfn.path,\n cc.label
> config_channel,\n ccont.contents file_contents,\n
> ccont.is_binary is_binary,\n c.checksum_type,\n
> c.checksum,\n ccont.delim_start,\n ccont.delim_end,\n
> cr.revision,\n ci.username,\n ci.groupname,\n
> ci.filemode,\n\t cft.label,\n\t ci.selinux_ctx,\n
> case \n when cft.label='symlink' then (select path from
> rhnConfigFileName where id = ci.SYMLINK_TARGET_FILENAME_ID)\n
> else ''\n end as symlink\t \n from \n
> rhnConfigFileState cfs,\n rhnConfigContent ccont,\n
> rhnChecksumView c,\n rhnConfigChannel cc,\n
> rhnConfigFileName cfn,\n rhnConfigInfo ci,\n
> rhnConfigFile cf,\n rhnConfigRevision cr,\n\t !
r
> hnConfigFileType cft,\n rhnActionConfigRevision acr\n where
> acr.server_id = %(server_id)s\n and acr.action_id = %(action_id)s\n
> and acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
> and cr.config_info_id = ci.id\n and cf.config_file_name_id =
> cfn.id\n and cf.config_channel_id = cc.id\n and cf.state_id =
> cfs.id\n and cfs.label = 'alive'\n and cr.config_content_id =
> ccont.id (+)\n and cr.config_file_type_id = cft.id\n and
> ccont.checksum_id = c.id(+)\n")
> self = <type 'instance'>
> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b8290ce81b8>
> 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>assaff</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release-server</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
> Registration Parameters:\nOS: redhat-release-server\nRelease: 6Server\nCPU
> Arch:
> x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>d4ecb5cac5581172dd3e32f6dcdb962c</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>FAA</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>6Server</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<valu!
e>
> <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', 'FAA', '2.6.32-71.24.1.el6.x86_64', '#1 SMP Sat Mar
> 26 16:05:19 EDT 2011', 'x86_64'], 'uptime': [125141, 3000693]})
> func = <type 'instancemethod'> <bound method Queue.get
> of <server.handlers.xmlrpc.queue.Queue instance at 0x2b8291346290>>
> 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
> 0x2b82892b94b8>
> _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>assaff</string></value>
> </member>
> <member>
> <name>operating_system</name>
> <value><string>redhat-release-server</string></value>
> </member>
> <member>
> <name>description</name>
> <value><string>Initial Registration Parameters:
> OS: redhat-release-server
> Release: 6Server
> CPU Arch: x86_64</string></value>
> </member>
> <member>
> <name>checksum</name>
> <value><string>d4ecb5cac5581172dd3e32f6dcdb962c</string></value>
> </member>
> <member>
> <name>profile_name</name>
> <value><string>FAA</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>6Server</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>FAA</string></value>
> <value><string>2.6.32-71.24.1.el6.x86_64</string></value>
> <value><string>#1 SMP Sat Mar 26 16:05:19 EDT 2011</string></value>
> <value><string>x86_64</string></value>
> </data></array></value>
> </member>
> <member>
> <name>uptime</name>
> <value><array><data>
> <value><int>125141</int></value>
> <value><int>3000693</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>assaff</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release-server</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
> Registration Parameters:\nOS: redhat-release-server\nRelease: 6Server\nCPU
> Arch:
> x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>d4ecb5cac5581172dd3e32f6dcdb962c</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string></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>6Server</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', 'FAA', '2.6.32-71.24.1.el6.x86_64', '#1 SMP Sat Mar
> 26 16:05:19 EDT 2011', 'x86_64'], 'uptime': [125141, 3000693]})
> method = <type 'unicode'> queue.get
> self = <type 'instance'>
> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b8290ce81b8>
>
> 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 0x2b828a07a8c0>
> self = <type 'instance'>
> <spacewalk.server.apacheHandler.apacheHandler instance at 0x2b828b9850e0>
> req = <type 'mp_request'> <mp_request object at
> 0x2b828a078050>
> 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': 'gm89'}
> 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
> 0x2b828a078050>
> self = <type 'instance'> <mod_python.apache.CallBack
> instance at 0x2b828a071ab8>
> object = <type 'instancemethod'> <bound method
> apacheHandler.handler of <spacewalk.server.apacheHandler.apacheHandler
> instance at 0x2b828b9850e0>>
> 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=11043 on exception:
> BASH_ENV = /root/.bashrc
> G_BROKEN_FILENAMES = 1
> HISTSIZE = 1000
> HOME = /root
> HOSTNAME = gm89
> INPUTRC = /etc/inputrc
> LANG = en_US.UTF-8
> 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
> PATH = /usr/kerberos/sbin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin
> PWD = /root
> SHELL = /bin/bash
> SHLVL = 3
> TERM = xterm-color
> USER = root
> USERNAME = root
> _ = /usr/sbin/httpd
>
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
