Hello, this seems to be corrected in spacewalk nightly by git 36208823bf8ecda8f4bc1376be4e8e69f4e0f2a6 https://fedorahosted.org/spacewalk/changeset/36208823bf8ecda8f4bc1376be4e8e69f4e0f2a6
Pierre 2011/11/15 Ian Forde <[email protected]> > > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
