[Spacewalk-list] Oracle Crash on /rhn/systems/details/packages/UpgradableList.do

Rob See rob at rsee.net
Mon Jun 23 20:29:06 UTC 2008


Hi,

    I've run into a problem with Oracle crashing on a specific query,
and I think it probably has something to do with my setup (Oracle-xe
i386 running on x86_64) but I just wanted to check to make sure.

Here is the query:

SELECT  pn.id AS id,
        pn.name AS name,
        pn.id || '|' || lookup_evr(full_list.evr.epoch,
full_list.evr.version, full_list.evr.release) AS id_combo
  FROM  rhnPackageName PN,
        (
         SELECT  SOP.package_name_id AS name_id, MAX(PE.evr) evr
           FROM  rhnPackageEVR PE, rhnServerOutdatedPackages SOP
          WHERE  SOP.server_id = :1
            AND  SOP.package_evr_id = PE.id
       GROUP BY  SOP.package_name_id
         ) full_list
WHERE  full_list.name_id = PN.id
ORDER BY  UPPER(PN.name)


It happens when I hit this page:

GET /rhn/systems/details/packages/UpgradableList.do



This is the error that appears in the catalina.out:

javax.servlet.ServletException: No more data to read from socket



This is showing up in the oracle trace:

*** 2008-06-23 11:49:43.357
*** SERVICE NAME:(SYS$USERS) 2008-06-23 11:49:43.357
*** SESSION ID:(423.22713) 2008-06-23 11:49:43.357
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x4, PC: [0x9537687, evapls()+133]
Registers:
%eax: 0x00000004 %ebx: 0x3e2a84dc %ecx: 0x00000004
%edx: 0xf7a297f0 %edi: 0x00000006 %esi: 0x0c6df580
%esp: 0xffcd8750 %ebp: 0xffcd88c0 %eip: 0x09537687
%efl: 0x00210246
  evapls()+113 (0x9537673) jnz 0x9537ea0
  evapls()+119 (0x9537679) test $0x400,%eax
  evapls()+124 (0x953767e) jnz 0x9537e95
  evapls()+130 (0x9537684) mov 0xffffffe0(%ebp),%eax
> evapls()+133 (0x9537687) movzb (%eax),%edx
  evapls()+136 (0x953768a) testb $0x1,%dl
  evapls()+139 (0x953768d) jne 0x953769e
  evapls()+141 (0x953768f) push 0x8(%ebp)
  evapls()+144 (0x9537692) call 0xa142c2c
*** 2008-06-23 11:49:43.358
ksedmp: internal or fatal error

Any ideas? If not, my next step is to go to a full + patched install of
oracle and see what happens.

-Rob




More information about the Spacewalk-list mailing list