Exception reported from leonov
Time: Mon Dec  5 09:28:12 2011
Exception type spacewalk.server.rhnSQL.sql_base.SQLError
Exception while handling function up2date.solveDependencies
Request object information:
URI: /XMLRPC
Remote Host: clone1.myriad.com
Server Name: spacewalk.myriad.com:443
Headers passed in:
        Accept-Encoding: identity
        Content-Length: 3860
        Host: leonov:443
        content-type: text/xml
        user-agent: rhn.rpclib.py/$Revision: 180172 $
        x-client-version: 1
        x-info: RPC Processor (C) Red Hat, Inc (version 182991)
        x-rhn-client-capability: packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(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,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 180172)
        x-up2date-version: 4.8.1-33.el4
Extra information about this error:
SQL Error generated: (6502, 'ORA-06502: PL/SQL: numeric or value error\nORA-06512: at "SPACEWALK.RPM", line 61\nORA-06512: at "SPACEWALK.RPM", line 205\nORA-06512: at "SPACEWALK.EVR_T", line 7\n', 'select distinct pn.name name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 1 as preference from rhnPackageEvr pe, rhnChannelPackage cp, rhnPackage p, rhnServerChannel sc, rhnPackageName pn, rhnPackageArch pa where 1=1 and pn.name = :dep and sc.server_id = :server_id and p.name_id = pn.id and cp.channel_id = sc.channel_id and p.id = cp.package_id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackageEVR pe1, rhnChannelPackage cp1, rhnPackage p1, rhnServerChannel sc1 where sc1.server_id = :server_id and p1.name_id = pn.id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.evr_id = pe1.id ) UNION ALL select  distinct pn.name, (pe.evr).version as version, (pe.evr).!
 release as release, (pe.evr).epoch as epoch, pa.label as arch, 2 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPackageProvides pr, rhnPackage p, rhnPackageCapability cap, rhnPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = pr.package_id and pr.package_id = p.id and pr.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id ) UNION ALL select distinct pn.name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 3 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPacka!
 geFile f, rhnPackage p, rhnPackageCapability cap, rhnPackageName pn, r
hnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = f.package_id and f.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id )')

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/up2date.py", line 357, in solveDependencies
    clientVersion = 2)
  File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 435, in __solveDep
    result, clientVersion)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnDependency.py", line 568, in solve_dependencies
    h.execute(server_id = server_id, dep = dep)
  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_cx_Oracle.py", line 129, in _execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (6502, 'ORA-06502: PL/SQL: numeric or value error\nORA-06512: at "SPACEWALK.RPM", line 61\nORA-06512: at "SPACEWALK.RPM", line 205\nORA-06512: at "SPACEWALK.EVR_T", line 7\n', 'select distinct pn.name name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 1 as preference from rhnPackageEvr pe, rhnChannelPackage cp, rhnPackage p, rhnServerChannel sc, rhnPackageName pn, rhnPackageArch pa where 1=1 and pn.name = :dep and sc.server_id = :server_id and p.name_id = pn.id and cp.channel_id = sc.channel_id and p.id = cp.package_id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackageEVR pe1, rhnChannelPackage cp1, rhnPackage p1, rhnServerChannel sc1 where sc1.server_id = :server_id and p1.name_id = pn.id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.evr_id = pe1.id ) UNION ALL select  distinct pn.name, (pe.evr).version as version, (pe.evr).release as !
 release, (pe.evr).epoch as epoch, pa.label as arch, 2 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPackageProvides pr, rhnPackage p, rhnPackageCapability cap, rhnPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = pr.package_id and pr.package_id = p.id and pr.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id ) UNION ALL select distinct pn.name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 3 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPackageFile f, r!
 hnPackage p, rhnPackageCapability cap, rhnPackageName pn, rhnPackageEV
R pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = f.package_id and f.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id )')

Local variables by frame
Frame _execute_wrapper in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py at line 129
                    function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@MGX02P>>>
                           e = <type 'instance'> ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SPACEWALK.RPM", line 61
ORA-06512: at "SPACEWALK.RPM", line 205
ORA-06512: at "SPACEWALK.EVR_T", line 7

                       errno = <type 'int'> 6502
                        self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@MGX02P>>
             modified_params = <type 'list'> []
                       value = <type 'int'> 1000010741
                           p = <type 'tuple'> ()
                      params = <type 'str'> 'dep': 'libmpi.so.0()(64bit)','server_id': 1000010741
                         ret = <type 'tuple'> (6502, 'ORA-06502: PL/SQL: numeric or value error\nORA-06512: at "SPACEWALK.RPM", line 61\nORA-06512: at "SPACEWALK.RPM", line 205\nORA-06512: at "SPACEWALK.EVR_T", line 7\n', 'select distinct pn.name name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 1 as preference from rhnPackageEvr pe, rhnChannelPackage cp, rhnPackage p, rhnServerChannel sc, rhnPackageName pn, rhnPackageArch pa where 1=1 and pn.name = :dep and sc.server_id = :server_id and p.name_id = pn.id and cp.channel_id = sc.channel_id and p.id = cp.package_id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackageEVR pe1, rhnChannelPackage cp1, rhnPackage p1, rhnServerChannel sc1 where sc1.server_id = :server_id and p1.name_id = pn.id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.evr_id = pe1.id ) UNION ALL select  distinct pn.name, (pe.evr).version as !
 version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 2 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPackageProvides pr, rhnPackage p, rhnPackageCapability cap, rhnPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = pr.package_id and pr.package_id = p.id and pr.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id ) UNION ALL select distinct pn.name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 3 as preference from rhnServerChannel sc, rhnChannelPa!
 ckage cp, rhnPackageFile f, rhnPackage p, rhnPackageCapability cap, rh
nPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = f.package_id and f.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id )')
                         key = <type 'str'> server_id
                          kw = <type 'dict'> {'dep': 'libmpi.so.0()(64bit)', 'server_id': 1000010741}
                      errmsg = <type 'str'> ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SPACEWALK.RPM", line 61
ORA-06512: at "SPACEWALK.RPM", line 205
ORA-06512: at "SPACEWALK.EVR_T", line 7


Frame execute in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 163
                           p = <type 'tuple'> ()
                        self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@MGX02P>>
                          kw = <type 'dict'> {'dep': 'libmpi.so.0()(64bit)', 'server_id': 1000010741}

Frame solve_dependencies in /usr/lib/python2.4/site-packages/spacewalk/server/rhnDependency.py at line 568
                   server_id = <type 'int'> 1000010741
                        deps = <type 'list'> ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl(Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-config-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)']
                          rs = <type 'list'> [{'name': 'lam-libs', 'epoch': '2', 'version': '7.1.2', 'preference': 2, 'release': '15.el4', 'arch': 'x86_64'}]
                         dep = <type 'str'> libmpi.so.0()(64bit)
                           h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@MGX02P>>
                           p = <type 'dict'> {'name': 'lam-libs', 'epoch': '2', 'version': '7.1.2', 'preference': 2, 'release': '15.el4', 'arch': 'x86_64'}
                     version = <type 'int'> 2
                        dict = <type 'dict'> {}
                   statement = <type 'str'>
select distinct
    pn.name name,
    (pe.evr).version as version,
    (pe.evr).release as release,
    (pe.evr).epoch as epoch,
    pa.label as arch,
    1 as preference
from
    rhnPackageEvr pe,
    rhnChannelPackage cp,
    rhnPackage p,
    rhnServerChannel sc,
    rhnPackageName pn,
    rhnPackageArch pa
where 1=1
and pn.name = :dep
and sc.server_id = :server_id
and p.name_id = pn.id
and cp.channel_id = sc.channel_id
and p.id = cp.package_id
and p.evr_id = pe.id
and p.package_arch_id = pa.id
and pe.evr = (
    select MAX(pe1.evr)
    from
        rhnPackageEVR pe1,
        rhnChannelPackage cp1,
        rhnPackage p1,
        rhnServerChannel sc1
    where
        sc1.server_id = :server_id
    and p1.name_id = pn.id
    and sc1.channel_id = cp1.channel_id
    and cp1.package_id = p1.id
    and p1.evr_id = pe1.id
    )
 UNION ALL
select  distinct
    pn.name,
    (pe.evr).version as version,
    (pe.evr).release as release,
    (pe.evr).epoch as epoch,
    pa.label as arch,
    2 as preference
from
    rhnServerChannel sc,
    rhnChannelPackage cp,
    rhnPackageProvides pr,
    rhnPackage p,
    rhnPackageCapability cap,
    rhnPackageName pn,
    rhnPackageEVR pe,
    rhnPackageArch pa
where
    sc.server_id = :server_id
and sc.channel_id = cp.channel_id
and cp.package_id = p.id
and cp.package_id = pr.package_id
and pr.package_id = p.id
and pr.capability_id = cap.id
and cap.name = :dep
and p.name_id = pn.id
and p.evr_id = pe.id
and p.package_arch_id = pa.id
-- and this package is the latest one from all the channels
-- this server is subscribed to.
and pe.evr = (
    select MAX(pe1.evr)
    from
        rhnPackage p1,
        rhnPackageEVR pe1,
        rhnServerChannel sc1,
        rhnChannelPackage cp1
    where
        sc1.server_id = :server_id
    and sc1.channel_id = cp1.channel_id
    and cp1.package_id = p1.id
    and p1.name_id = pn.id
    and p1.evr_id = pe1.id
    )
 UNION ALL
select distinct
    pn.name,
    (pe.evr).version as version,
    (pe.evr).release as release,
    (pe.evr).epoch as epoch,
    pa.label as arch,
    3 as preference
from
    rhnServerChannel sc,
    rhnChannelPackage cp,
    rhnPackageFile f,
    rhnPackage p,
    rhnPackageCapability cap,
    rhnPackageName pn,
    rhnPackageEVR pe,
    rhnPackageArch pa
where
    sc.server_id = :server_id
and sc.channel_id = cp.channel_id
and cp.package_id = p.id
and cp.package_id = f.package_id
and f.capability_id = cap.id
and cap.name = :dep
and p.name_id = pn.id
and p.evr_id = pe.id
and p.package_arch_id = pa.id
-- and this package is the latest one from all the channels
-- this server is subscribed to.
and pe.evr = (
    select MAX(pe1.evr)
    from
        rhnPackage p1,
        rhnPackageEVR pe1,
        rhnServerChannel sc1,
        rhnChannelPackage cp1
    where
        sc1.server_id = :server_id
    and sc1.channel_id = cp1.channel_id
    and cp1.package_id = p1.id
    and p1.name_id = pn.id
    and p1.evr_id = pe1.id
    )

                     deplist = <type 'list'> ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-config-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi']
                       entry = <type 'list'> ['lam-libs', '7.1.2', '15.el4', '2']
                    packages = <type 'dict'> {'lam-libs': [['lam-libs', '7.1.2', '15.el4', '2']], 'evolution28-cairo': [['evolution28-cairo', '1.2.4', '6.el4', '']], 'libgomp': [['libgomp', '4.1.2', '44.EL4', '']], 'initscripts': [['initscripts', '7.93.34', '1.el4', '']], 'librdmacm.so.1(RDMACM_1.0)(64bit)': [['librdmacm', '1.0.8', '1.el4', '']], 'evolution28-gtk2': [['evolution28-gtk2', '2.10.4', '25.el4', '']], 'liblam.so.0()(64bit)': [['lam-libs', '7.1.2', '15.el4', '2']], 'evolution28-pango': [['evolution28-pango', '1.14.9', '7.el4', '']], 'librdmacm.so.1()(64bit)': [['librdmacm', '1.0.8', '1.el4', '']]}

Frame __solveDep in /usr/share/rhn/server/handlers/xmlrpc/up2date.py at line 435
               clientVersion = <type 'int'> 2
                        self = <type 'instance'> <server.handlers.xmlrpc.up2date.Up2date instance at 0x2ba079aa4998>
                   system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>Administrator</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>redhat-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: redhat-release
Release: 4AS
CPU Arch: ia32e-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>5e0cdda297eaedcfdb197cac97467d58</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>clone1</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010741</string></value>
</member>
<member>
<name>architecture</name>
<value><string>ia32e-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>4AS</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>

                      result = <type 'list'> ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl(Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-config-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)']
                        deps = <type 'list'> ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl(Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-config-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)']
                      action = <type 'str'> solvedep

Frame solveDependencies in /usr/share/rhn/server/handlers/xmlrpc/up2date.py at line 357
                        self = <type 'instance'> <server.handlers.xmlrpc.up2date.Up2date instance at 0x2ba079aa4998>
                   system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>Administrator</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>redhat-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: redhat-release
Release: 4AS
CPU Arch: ia32e-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>5e0cdda297eaedcfdb197cac97467d58</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>clone1</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010741</string></value>
</member>
<member>
<name>architecture</name>
<value><string>ia32e-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>4AS</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>

                        deps = <type 'list'> ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl(Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-config-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)']

Frame call_function in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 169
                           e = <type 'instance'> (6502, 'ORA-06502: PL/SQL: numeric or value error\nORA-06512: at "SPACEWALK.RPM", line 61\nORA-06512: at "SPACEWALK.RPM", line 205\nORA-06512: at "SPACEWALK.EVR_T", line 7\n', 'select distinct pn.name name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 1 as preference from rhnPackageEvr pe, rhnChannelPackage cp, rhnPackage p, rhnServerChannel sc, rhnPackageName pn, rhnPackageArch pa where 1=1 and pn.name = :dep and sc.server_id = :server_id and p.name_id = pn.id and cp.channel_id = sc.channel_id and p.id = cp.package_id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackageEVR pe1, rhnChannelPackage cp1, rhnPackage p1, rhnServerChannel sc1 where sc1.server_id = :server_id and p1.name_id = pn.id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.evr_id = pe1.id ) UNION ALL select  distinct pn.name, (pe.evr).version !
 as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 2 as preference from rhnServerChannel sc, rhnChannelPackage cp, rhnPackageProvides pr, rhnPackage p, rhnPackageCapability cap, rhnPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = pr.package_id and pr.package_id = p.id and pr.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id ) UNION ALL select distinct pn.name, (pe.evr).version as version, (pe.evr).release as release, (pe.evr).epoch as epoch, pa.label as arch, 3 as preference from rhnServerChannel sc, rhnChanne!
 lPackage cp, rhnPackageFile f, rhnPackage p, rhnPackageCapability cap,
 rhnPackageName pn, rhnPackageEVR pe, rhnPackageArch pa where sc.server_id = :server_id and sc.channel_id = cp.channel_id and cp.package_id = p.id and cp.package_id = f.package_id and f.capability_id = cap.id and cap.name = :dep and p.name_id = pn.id and p.evr_id = pe.id and p.package_arch_id = pa.id and pe.evr = ( select MAX(pe1.evr) from rhnPackage p1, rhnPackageEVR pe1, rhnServerChannel sc1, rhnChannelPackage cp1 where sc1.server_id = :server_id and sc1.channel_id = cp1.channel_id and cp1.package_id = p1.id and p1.name_id = pn.id and p1.evr_id = pe1.id )')
                        self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2ba079abb050>
              force_rollback = <type 'int'> 1
                      params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>Administrator</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: redhat-release\nRelease: 4AS\nCPU Arch: ia32e-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>5e0cdda297eaedcfdb197cac97467d58</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>clone1</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010741</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>ia32e-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>4AS</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><da!
 ta>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl!
 (Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-confi
g-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)'])
                        func = <type 'instancemethod'> <bound method Up2date.solveDependencies of <server.handlers.xmlrpc.up2date.Up2date instance at 0x2ba079aa4998>>
                      method = <type 'str'> up2date.solveDependencies

Frame process in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 476
                          fd = <type 'instance'> <cStringIO.StringO object at 0x2ba06a8c16c0>
                       _body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>up2date.solveDependencies</methodName>
<params>
<param>
<value><string>&lt;?xml version="1.0"?&gt;
&lt;params&gt;
&lt;param&gt;
&lt;value&gt;&lt;struct&gt;
&lt;member&gt;
&lt;name&gt;username&lt;/name&gt;
&lt;value&gt;&lt;string&gt;Administrator&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;operating_system&lt;/name&gt;
&lt;value&gt;&lt;string&gt;redhat-release&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;description&lt;/name&gt;
&lt;value&gt;&lt;string&gt;Initial Registration Parameters:
OS: redhat-release
Release: 4AS
CPU Arch: ia32e-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;checksum&lt;/name&gt;
&lt;value&gt;&lt;string&gt;5e0cdda297eaedcfdb197cac97467d58&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;profile_name&lt;/name&gt;
&lt;value&gt;&lt;string&gt;clone1&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;system_id&lt;/name&gt;
&lt;value&gt;&lt;string&gt;ID-1000010741&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;architecture&lt;/name&gt;
&lt;value&gt;&lt;string&gt;ia32e-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;os_release&lt;/name&gt;
&lt;value&gt;&lt;string&gt;4AS&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;fields&lt;/name&gt;
&lt;value&gt;&lt;array&gt;&lt;data&gt;
&lt;value&gt;&lt;string&gt;system_id&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;os_release&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;operating_system&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;architecture&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;username&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;type&lt;/string&gt;&lt;/value&gt;
&lt;/data&gt;&lt;/array&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;type&lt;/name&gt;
&lt;value&gt;&lt;string&gt;REAL&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;/struct&gt;&lt;/value&gt;
&lt;/param&gt;
&lt;/params&gt;
</string></value>
</param>
<param>
<value><array><data>
<value><string>librdmacm.so.1()(64bit)</string></value>
<value><string>librdmacm.so.1(RDMACM_1.0)(64bit)</string></value>
<value><string>librdmacm.so.1()(64bit)</string></value>
<value><string>librdmacm.so.1(RDMACM_1.0)(64bit)</string></value>
<value><string>evolution28-cairo</string></value>
<value><string>evolution28-gtk2</string></value>
<value><string>evolution28-pango</string></value>
<value><string>libgomp</string></value>
<value><string>initscripts</string></value>
<value><string>lam-libs</string></value>
<value><string>liblam.so.0()(64bit)</string></value>
<value><string>libmpi.so.0()(64bit)</string></value>
<value><string>libibverbs.so.1</string></value>
<value><string>libibverbs.so.1(IBVERBS_1.0)</string></value>
<value><string>libibverbs.so.1(IBVERBS_1.1)</string></value>
<value><string>libgssapi</string></value>
<value><string>libgssapi.so.1()(64bit)</string></value>
<value><string>libibcommon.so.1()(64bit)</string></value>
<value><string>libibumad.so.1()(64bit)</string></value>
<value><string>openib</string></value>
<value><string>libibumad.so.1()(64bit)</string></value>
<value><string>libibumad.so.1(IBUMAD_1.0)(64bit)</string></value>
<value><string>libsgutils.so.1()(64bit)</string></value>
<value><string>perl(Archive::Tar)</string></value>
<value><string>perl(Archive::Tar)</string></value>
<value><string>perl(IO::Zlib)</string></value>
<value><string>system-config-netboot-cmd</string></value>
<value><string>systemtap-runtime</string></value>
<value><string>libsmi.so.2()(64bit)</string></value>
<value><string>libsmi</string></value>
<value><string>libsmi.so.2()(64bit)</string></value>
</data></array></value>
</param>
</params>
</methodCall>

                      params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>Administrator</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: redhat-release\nRelease: 4AS\nCPU Arch: ia32e-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>5e0cdda297eaedcfdb197cac97467d58</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>clone1</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010741</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>ia32e-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>4AS</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><da!
 ta>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', ['librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'librdmacm.so.1()(64bit)', 'librdmacm.so.1(RDMACM_1.0)(64bit)', 'evolution28-cairo', 'evolution28-gtk2', 'evolution28-pango', 'libgomp', 'initscripts', 'lam-libs', 'liblam.so.0()(64bit)', 'libmpi.so.0()(64bit)', 'libibverbs.so.1', 'libibverbs.so.1(IBVERBS_1.0)', 'libibverbs.so.1(IBVERBS_1.1)', 'libgssapi', 'libgssapi.so.1()(64bit)', 'libibcommon.so.1()(64bit)', 'libibumad.so.1()(64bit)', 'openib', 'libibumad.so.1()(64bit)', 'libibumad.so.1(IBUMAD_1.0)(64bit)', 'libsgutils.so.1()(64bit)', 'perl!
 (Archive::Tar)', 'perl(Archive::Tar)', 'perl(IO::Zlib)', 'system-confi
g-netboot-cmd', 'systemtap-runtime', 'libsmi.so.2()(64bit)', 'libsmi', 'libsmi.so.2()(64bit)'])
                      method = <type 'str'> up2date.solveDependencies
                        self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2ba079abb050>

Frame handler in /usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at line 195
                           h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@MGX02P>>
                        self = <type 'instance'> <spacewalk.server.apacheHandler.apacheHandler instance at 0x2ba06d7c7878>
                         req = <type 'mp_request'> <mp_request object at 0x2ba053af8050>
                         ret = <type 'int'> 0
             templateStrings = <type 'dict'> {'email_account_info': '\nAccount Information:\n  Your Spacewalk login:         <login />\n  Your Spacewalk email address: <email-address />', 'email_footer': '--the Spacewalk Team', 'hostname': 'leonov'}
                         row = <type 'NoneType'> None

Frame HandlerDispatch in /usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299
                         req = <type 'mp_request'> <mp_request object at 0x2ba053af8050>
                        self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2ba053af0b90>
                      object = <type 'instancemethod'> <bound method apacheHandler.handler of <spacewalk.server.apacheHandler.apacheHandler instance at 0x2ba06d7c7878>>
                           l = <type 'list'> ['spacewalk.server.apacheServer', 'Handler']
                      module = <type 'module'> <module 'spacewalk.server.apacheServer' from '/usr/lib/python2.4/site-packages/spacewalk/server/apacheServer.pyc'>
                       hlist = <type 'mp_hlist'> {'handler:'spacewalk.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
                  object_str = <type 'str'> Handler
                       debug = <type 'int'> 0
                 module_name = <type 'str'> spacewalk.server.apacheServer
                      config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server'}
                         dir = <type 'str'> /XMLRPC/
                      result = <type 'int'> 500


Environment for PID=28669 on exception:
LANG = C
NLS_LANG = english.AL32UTF8
ORACLE_HOME = /opt/oracle
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PWD = /
SHLVL = 2
TERM = xterm
_ = /usr/sbin/httpd


