[Spacewalk-list] RHN Tracebacks concerning rvii and rhnvirtualinstanceinfo

[Ian Forde]

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        ')