[Spacewalk-list] RHN Tracebacks concerning rvii and rhnvirtualinstanceinfo

[Ian Forde]

Thanks!  I manually made the update to
/usr/lib/python24/site-packages/spacewalk/server/rhnVirtualization.py.
 Do I have to remove the .pyc and .pyo files then restart Spacewalk?
How do I make it take effect?

  -I

On Tue, Nov 15, 2011 at 8:57 PM, Pierre Casenove <pcasenove at gmail.com> wrote:
> 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>