[Spacewalk-list] ProtocolError XMLRPC: 500 Internal Server Error when syncing to profile

[Craig Ward]

Seems to be complaining of an invalid table name??

Exception reported from server
Time: Thu Mar 24 15:51:09 2011
Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function queue.get Request object information:
URI: /XMLRPC
Remote Host: wagertst02.testcell.tab.co.nz Server Name: server:0
Headers passed in:
       Accept-Encoding: identity
       Content-Length: 2726
       Host: server
       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:
osad.ping(1)=1,packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(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.3.12-1.el5
Extra information about this error:
SQL Error generated: ('ORA-00903: invalid table name\n', 903, 'select
tro.label as operation, pn.name, pe.version, pe.release, pe.epoch,
pa.label as package_arch from rhnPackageDeltaElement pde,
rhnTransactionPackage rp left join rhnPackageArch pa on
rp.package_arch_id = pa.id, rhnTransactionOperation tro,
rhnPackageName pn, rhnPackageEVR pe, where pde.package_delta_id =
:package_delta_id and pde.transaction_package_id = rp.id and
rp.operation = tro.id and rp.name_id = pn.id and rp.evr_id = pe.id
order by tro.label, pn.name')


On 24 March 2011 21:12, Craig Ward <craig.ward at gmail.com> wrote:
> Yes a trackback email was sent, it's pretty massive. I can forward it
> on it to the list?
>
> Craig.
>
> On 24 March 2011 19:36, Jan Pazdziora <jpazdziora at redhat.com> wrote:
>> On Thu, Mar 24, 2011 at 02:19:26PM +1300, Craig Ward wrote:
>>> Hi,
>>>
>>> I've successfully registered some RHEL servers against my satellite
>>> server. The server is looking at the following channels:
>>>
>>> Parent 5.5Server-x86_64       Spacewalk Default Organization  3116    6
>>> Child 5Server-x86_64_updates  Spacewalk Default Organization  3292    6
>>> Child epel5-x86_64    Spacewalk Default Organization  6329    1
>>> Child spacewalk-client-x86_64         Spacewalk Default Organization  22      6
>>>
>>> I can apply updates fine, run a rhn_check on the server and it
>>> downloads around 200 updates successfully. Following the updates, I
>>> can still do a rhn_check and it returns fines (no packages to update).
>>>
>>> However, if I try and roll back to a profile create before the updates
>>> were applied I receive a error 500 when running rhn_check:
>>>
>>> # rhn_check -vvvv
>>> D: opening  db environment /var/lib/rpm/Packages joinenv
>>> D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0
>>> D: locked   db index       /var/lib/rpm/Packages
>>> D: opening  db index       /var/lib/rpm/Providename rdonly mode=0x0
>>> XMLRPC ProtocolError: <ProtocolError for <server name> /XMLRPC: 500
>>> Internal Server Error>
>>> D: closed   db index       /var/lib/rpm/Providename
>>> D: closed   db index       /var/lib/rpm/Packages
>>> D: closed   db environment /var/lib/rpm/Packages
>>>
>>>
>>> If I remove the package synchronisation job from the events for the
>>> server I can rhn_check again.
>>>
>>> AFAIK I'm running the correct version of the rhn tools (from the
>>> spacewalk repo):
>>>
>>> # rpm -qa | grep rhn
>>> yum-rhn-plugin-1.3.8-1.el5
>>> rhn-setup-1.3.12-1.el5
>>> rhnsd-4.9.8-1.el5
>>> rhn-client-tools-1.3.12-1.el5
>>> rhn-setup-gnome-1.3.12-1.el5
>>> rhnlib-2.5.33-1.el5
>>> rhn-check-1.3.12-1.el5
>>>
>>> Any ideas?
>>
>> Is there anything of interest in /var/log/httpd/*error_log? Was any
>> traceback email sent?
>>
>> --
>> Jan Pazdziora
>> Principal Software Engineer, Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>