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

[Rob See]

Hi,

    Just to close this out, this crash seems to be a bug with 10.2.0.1. 
I installed the standard edition 10.2.0.1 and got the same crash. 
Upgraded it to 10.2.0.3 and the problem was resolved.

-Rob
Rob See wrote:
> 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> !DSPAM:1,486007a621581865619958!
>
>
>