[Spacewalk-list] error generated when running rhn_check on client
Assaf Flatto
assaf.flatto at goldmoney.com
Wed Apr 13 10:22:13 UTC 2011
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 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")
>
> 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 rhnConfigFileType
> 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<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]})
> 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
>
More information about the Spacewalk-list
mailing list