[Spacewalk-list] up2date cannot resolve dependencies

Hagberg, Keith Keith.Hagberg at FMR.com
Fri Jul 1 17:30:46 UTC 2011


Anyone have any idea what might be causing this. It is happening on multiple files now.

Keith

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Hagberg, Keith
Sent: Friday, June 24, 2011 3:34 PM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] up2date cannot resolve dependencies

Strange problem just started. Seems up2date is having problems resolving dependencies for some rpms. Below is a traceback when trying to install emacs.

Running sw 1.3. This happens on a rhel 4x32 and x64 client

At the bottom is the console output and just below that is the output from /var/log/up2date.

I have tried this going through a proxy server and direct to the sw server

The issue does not happen on all packages, I can install httpd fine using up2date and it brings in the deps no problem.

Any help would be great

Keith

Exception reported from spacewalk
Time: Fri Jun 24 15:19:07 2011
Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLError
Exception while handling function up2date.solveDependencies
Request object information:
URI: /XMLRPC
Remote Host: client
Server Name: spacewalk:443
Headers passed in:
        Accept-Encoding: identity
        Content-Length: 2413
        Host: spacewalk:443
        content-type: text/xml
        user-agent: rhn.rpclib.py/$Revision: 191145 $
        x-client-version: 1
        x-info: RPC Processor (C) Red Hat, Inc (version 195358)
        x-rhn-client-capability: osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(1)=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,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 191145)
        x-up2date-version: 4.6.2-7.el4.1
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, rhnPackageNa!
 me 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/<CENSORED!>/server/apacheRequest.py", line 118, in call_function
    response = apply(func, params)
  File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 355, in solveDependencies
    clientVersion = 2)
  File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 433, in __solveDep
    result, clientVersion)
  File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnDependency.py", line 620, in solve_dependencies
    h.execute(server_id = server_id, dep = dep)
  File "/usr/lib/python2.4/site-packages/<CENSORED!>/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/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py", line 118, 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, rhnP!
 ackageEV
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/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py at line 118
                    function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@spwkuwlk1>>>
                           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 <CENSORED!>@spwkuwlk1>>
             modified_params = <type 'list'> []
                       value = <type 'int'> 1000010965
                           p = <type 'tuple'> ()
                      params = <type 'str'> 'dep': 'libungif.so.4','server_id': 1000010965
                         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).vers!
 ion 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, rhnCh!
 annelPackage 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': 'libungif.so.4', 'server_id': 1000010965}
                      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/<CENSORED!>/server/rhnSQL/sql_base.py at line 163
                           p = <type 'tuple'> ()
                        self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@spwkuwlk1>>
                          kw = <type 'dict'> {'dep': 'libungif.so.4', 'server_id': 1000010965}

Frame solve_dependencies in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnDependency.py at line 620
                   server_id = <type 'int'> 1000010965
                        deps = <type 'list'> ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']
                          rs = <type 'list'> [{'name': 'Xaw3d', 'epoch': '', 'version': '1.5', 'preference': 2, 'release': '24', 'arch': 'i386'}]
                         dep = <type 'str'> libungif.so.4
                           h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@spwkuwlk1>>
                           p = <type 'dict'> {'name': 'Xaw3d', 'epoch': '', 'version': '1.5', 'preference': 2, 'release': '24', 'arch': 'i386'}
                     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'> ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']
                       entry = <type 'list'> ['Xaw3d', '1.5', '24', '']
                    packages = <type 'dict'> {'fonts-xorg-75dpi': [['fonts-xorg-75dpi', '6.8.2', '1.EL', '']], 'emacs-common': [['emacs-common', '21.3', '19.EL.4', '']], 'libXaw3d.so.7': [['Xaw3d', '1.5', '24', '']]}

Frame __solveDep in /usr/share/rhn/server/handlers/xmlrpc/up2date.py at line 433
               clientVersion = <type 'int'> 2
                        self = <type 'instance'> <server.handlers.xmlrpc.up2date.Up2date instance at 0x2b75acd9c680>
                   system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>satadmin</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: i686-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>c75a6a0d857a6590961d02834b8c16a7</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>eng011</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010965</string></value>
</member>
<member>
<name>architecture</name>
<value><string>i686-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'> ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']
                        deps = <type 'list'> ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']
                      action = <type 'str'> solvedep

Frame solveDependencies in /usr/share/rhn/server/handlers/xmlrpc/up2date.py at line 355
                        self = <type 'instance'> <server.handlers.xmlrpc.up2date.Up2date instance at 0x2b75acd9c680>
                   system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>satadmin</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: i686-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>c75a6a0d857a6590961d02834b8c16a7</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>eng011</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010965</string></value>
</member>
<member>
<name>architecture</name>
<value><string>i686-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'> ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']

Frame call_function in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 164
                           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).v!
 ersion 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, rh!
 nChannelPackage cp, rhnPackageFile f, rhnPackage p, rhnPackageCapabil!

 ity 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'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2b75acd43638>
              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>satadmin</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: i686-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>c75a6a0d857a6590961d02834b8c16a7</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>eng011</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010965</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>i686-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', ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4'])
                        func = <type 'instancemethod'> <bound method Up2date.solveDependencies of <server.handlers.xmlrpc.up2date.Up2date instance at 0x2b75acd9c680>>
                      method = <type 'unicode'> up2date.solveDependencies

Frame process in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 471
                          fd = <type 'instance'> <cStringIO.StringO object at 0x2b7598259878>
                       _body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>up2date.solveDependencies</methodName>
<params>
<param>
<value><string><?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>satadmin</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: i686-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>c75a6a0d857a6590961d02834b8c16a7</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>eng011</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010965</string></value>
</member>
<member>
<name>architecture</name>
<value><string>i686-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>
</string></value>
</param>
<param>
<value><array><data>
<value><string>emacs-common</string></value>
<value><string>fonts-xorg-75dpi</string></value>
<value><string>libXaw3d.so.7</string></value>
<value><string>libungif.so.4</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>satadmin</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: i686-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>c75a6a0d857a6590961d02834b8c16a7</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>eng011</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010965</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>i686-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', ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4'])
                      method = <type 'unicode'> up2date.solveDependencies
                        self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2b75acd43638>

Frame handler in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheHandler.py at line 193
                           h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@spwkuwlk1>>
                        self = <type 'instance'> <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b759a922128>
                         req = <type 'mp_request'> <mp_request object at 0x2b7599018050>
                         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': spacewalk'}
                         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 0x2b7599018050>
                        self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2b7599010b48>
                      object = <type 'instancemethod'> <bound method apacheHandler.handler of <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b759a922128>>
                           l = <type 'list'> ['<CENSORED!>.server.apacheServer', 'Handler']
                      module = <type 'module'> <module '<CENSORED!>.server.apacheServer' from '/usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheServer.pyc'>
                       hlist = <type 'mp_hlist'> {'handler:'<CENSORED!>.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
                  object_str = <type 'str'> Handler
                       debug = <type 'int'> 0
                 module_name = <type 'str'> <CENSORED!>.server.apacheServer
                      config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server'}
                         dir = <type 'str'> /XMLRPC/
                      result = <type 'int'> 500


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


CONSOLE OUTPUT

Fetching rpm headers...
########################################

Name                                    Version        Rel
----------------------------------------------------------
emacs                                   21.3           19.EL.4           i386


Testing package set / solving RPM inter-dependencies...
There was a fatal error communicating with the server. The message was:
Internal Server Error

/VAR/LOG/UP2DATE

[Fri Jun 24 15:28:56 2011] up2date updating login info
[Fri Jun 24 15:28:56 2011] up2date logging into up2date server
[Fri Jun 24 15:28:56 2011] up2date successfully retrieved authentication token from up2date server
[Fri Jun 24 15:28:56 2011] up2date availablePackageList from network
[Fri Jun 24 15:28:58 2011] up2date solving dep for: ['emacs-common', 'fonts-xorg-75dpi', 'libXaw3d.so.7', 'libungif.so.4']
[Fri Jun 24 15:28:58 2011] up2date A protocol error occurred: Internal Server Error , attempt #1,
[Fri Jun 24 15:29:04 2011] up2date A protocol error occurred: Internal Server Error , attempt #2,
[Fri Jun 24 15:29:09 2011] up2date A protocol error occurred: Internal Server Error , attempt #3,
[Fri Jun 24 15:29:15 2011] up2date A protocol error occurred: Internal Server Error , attempt #4,
[Fri Jun 24 15:29:21 2011] up2date A protocol error occurred: Internal Server Error , attempt #5,

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list




More information about the Spacewalk-list mailing list