[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