[Spacewalk-list] RHN Tracebacks concerning rvii and rhnvirtualinstanceinfo

[Pierre Casenove]

Hello,
this seems to be corrected in spacewalk nightly by git
36208823bf8ecda8f4bc1376be4e8e69f4e0f2a6
https://fedorahosted.org/spacewalk/changeset/36208823bf8ecda8f4bc1376be4e8e69f4e0f2a6

Pierre

2011/11/15 Ian Forde <ianforde at gmail.com>
>
> Spacewalk 1.5, CentOS 5.7.  I'm getting tons of these in email (domain
> names changed to protect the innocent...)  Note that I'm using pgsql
> for my db.  Things like they work, mostly, except for things like SSM
> and pushing config files to multiple machines, but that may be
> entirely unrelated... Anyhoo - anyone seen this before"  I can provide
> more info if needed...
>
>
> Exception reported from aldrin.foo.com
> Time: Sat Nov 12 12:36:37 2011
> Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
> Exception while handling function registration.virt_notify
> Request object information:
> URI: /XMLRPC
> Remote Host: vmserver1.foo.com
> Server Name: aldrin.foo.com:0
> Headers passed in:
>        Accept-Encoding: identity
>        Content-Length: 7162
>        Host: aldrin.foo.com
>        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.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,kickstart.initiate(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.5.16-1.el5
> Extra information about this error:
> SQL Error generated: ('column "rvii" of relation
> "rhnvirtualinstanceinfo" does not exist at character 65\n', 0, '\n
>       UPDATE rhnVirtualInstanceInfo rvii\n            SET
> rvii.state=(\n                SELECT rvis.id \n                FROM
> rhnVirtualInstanceState rvis\n                WHERE
> rvis.label=%(state)s\n            )\n            WHERE\n
>  rvii.instance_id IN (\n                    SELECT rvi.id\n
>        FROM rhnVirtualInstance rvi\n                    WHERE
> rvi.confirmed=0)\n        ')
>
> Exception Handler Information
> Traceback (most recent call last):
>  File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py",
> line 123, in call_function
>    response = apply(func, params)
>  File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line
> 888, in virt_notify
>    rhnVirtualization._virt_notify(server_id, actions)
>  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnVirtualization.py",
> line 804, in _virt_notify
>    handler.handle(server_id, action)
>  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnVirtualization.py",
> line 210, in handle
>    handler(system_id, timestamp, properties)
>  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnVirtualization.py",
> line 280, in _handle_system_crawl_ended
>    self.__remove_unconfirmed_domains(system_id)
>  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnVirtualization.py",
> line 706, in __remove_unconfirmed_domains
>    query.execute(state = ServerStateType.STOPPED)
>  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 269, in _execute_wrapper
>    raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
> SQLStatementPrepareError: ('column "rvii" of relation
> "rhnvirtualinstanceinfo" does not exist at character 65\n', 0, '\n
>       UPDATE rhnVirtualInstanceInfo rvii\n            SET
> rvii.state=(\n                SELECT rvis.id \n                FROM
> rhnVirtualInstanceState rvis\n                WHERE
> rvis.label=%(state)s\n            )\n            WHERE\n
>  rvii.instance_id IN (\n                    SELECT rvi.id\n
>        FROM rhnVirtualInstance rvi\n                    WHERE
> rvi.confirmed=0)\n        ')
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list