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 <[email protected]> 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 <[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 > _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
