Re: How to crash Your instance <-- should be session ---with simple CTAS

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Fri, 2 Dec 2011 17:01:33 +0800
Message-ID: <CAM_ddu8A_OYd-WT+S0UWoJuAjL_PD+o8OpecMS8pXHvjGY_qrw_at_mail.gmail.com>

I test in 11.2.0.3.0, Linux X86
the session did crash with 3113 error. if you change the minus operator to union or union all, the session crash also. the trace file show the 7445 error as below.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1] [PC:0x8FBE8D1, kokmrwo()+95] [flags: 0x0, count: 1] Errors in file
/home/oracle/app/oracle/diag/rdbms/cs11gr2/cs11gR2/trace/cs11gR2_ora_31935.trc  (incident=36953):
ORA-07445: exception encountered: core dump [kokmrwo()+95] [SIGSEGV] [ADDR:0x1] [PC:0x8FBE8D1] [Address not mapped to object] [] Incident details in:
/home/oracle/app/oracle/diag/rdbms/cs11gr2/cs11gR2/incident/incdir_36953/cs11gR2_ora_31935_i36953.trc

if the order by is removed, the table t will be created and no abnormal. see the bug is not fixed yet :-)
*
*
*Bug 2896403 - CTAS with UNION and ORDER BY dumps (in kokmrwo or
qersoAllocate) [ID 2896403.8]*

sys_at_CS11GR2> drop table t purge;

Table dropped.

sys_at_CS11GR2> create table t as (select * from dba_users minus select * from dba_users where mod(user_id,2) = 0 ) order by dbms_random.value   2 ;

create table t as (select * from dba_users minus select * from dba_users where mod(user_id,2) = 0 ) order by dbms_random.value

           *
ERROR at line 1:
ORA-03113: end-of-file on communication channel Process ID: 31935
Session ID: 141 Serial number: 531

sys_at_CS11GR2> sys_at_CS11GR2> select * from dual; ERROR:
ORA-03114: not connected to ORACLE

-Sidney Chen

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 02 2011 - 03:01:33 CST