My Oracle Support Banner

ORA-00600 [KCFIS_PUSH0] after select query (Doc ID 2687703.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Exadata Storage Server Software - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

database level ORA-00600 [KCFIS_PUSH0] with select query.

 

[xxxxxxx53_p00b_230077_i3011963.trc]

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[TOC00001]
ORA-07445: exception encountered: core dump [kcfis_remove_and_free()+53]
[SIGSEGV] [ADDR:0x8] [PC:0xD3EACA5] [Address not mapped to object] []
ORA-10388: parallel query server interrupt (failure)
ORA-00600: internal error code, arguments: [kcfis_push0], [14], [14],
[0x7F778FBAD670], [], [], [], [], [], [], [], []

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8]
[PC:0xD3EACA5, kcfis_remove_and_free()+53] [flags: 0x0, count: 1]
Registers:
%rax: 0x00007f778fbaea20 %rbx: 0x00007f778fbad670 %rcx: 0x0000000000000004
%rdx: 0x00007f778f010120 %rdi: 0x0000000000000006 %rsi: 0x0000000000000004
%rsp: 0x00007fff1c816160 %rbp: 0x00007fff1c8161a0 %r8: 0x0000000000000000
%r9: 0x0000000000000000 %r10: 0x0000000000000f00 %r11: 0x00007f77953902c0
%r12: 0x00007f778fbad670 %r13: 0x00007f779caadf40 %r14: 0x00007f778f010120
%r15: 0x00007f778fbaea20 %rip: 0x000000000d3eaca5 %efl: 0x0000000000010206
kcfis_remove_and_free()+39 (0xd3eac97) mov %rdx,-0x28(%rbp)
kcfis_remove_and_free()+43 (0xd3eac9b) mov (%rdx),%r8
kcfis_remove_and_free()+46 (0xd3eac9e) mov 0x8(%rdx),%rax
kcfis_remove_and_free()+50 (0xd3eaca2) movzwl (%rbx),%edi
> kcfis_remove_and_free()+53 (0xd3eaca5) mov %rax,0x8(%r8)
kcfis_remove_and_free()+57 (0xd3eaca9) mov -0x28(%rbp),%r9
kcfis_remove_and_free()+61 (0xd3eacad) fs: mov 0x0(),%r12
kcfis_remove_and_free()+70 (0xd3eacb6) mov 0x8(%r9),%r11
kcfis_remove_and_free()+74 (0xd3eacba) mov (%r9),%r10

*** 2020-03-21T13:48:22.499580+00:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3,
mask=0x80)
[TOC00004]
----- Current SQL Statement for this session (sql_id=8h4pjf3q0zy6g) -----
select substrb(dump(val,16,0,64),1,240) ep, freq, cdn, ndv, (sum(pop)
over()) popcnt, (sum(pop*freq) over()) popfreq, substrb(dump(max(val)
over(),16,0,64),1,240) maxval, substrb(dump(min(val) over(),16,0,64),1,240)
minval from (select val, freq, (sum(freq) over()) cdn, (count(*) over())
ndv, (case when freq > ((sum(freq) over())/254) then 1 else 0 end) pop
from (select /*+ parallel(t,8) parallel_index(t,8) dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false')
no_substrb_pad */ "CASHORDERQTY" val, count("CASHORDERQTY") freq from
"DNA_TRADING_EQ"."ORDERS" t where "CASHORDERQTY" is not null and
TBL$OR$IDX$PART$NUM("DNA_TRADING_EQ"."ORDERS",0,4,0,"ROWID") = :objn group by
"CASHORDERQTY")) order by val
[TOC00004-END]

[TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- --------------------
----------------------------
ksedst()+119 call kgdsdst() 7F7795CFDEF8 000000003
7F7795CDF960 ?
7F7795CDFA78 ?
494E554700000000 000000083
?
dbkedDefDump()+1200 call ksedst() 000000001 000000003 ?
7F7795CDF960 ?
7F7795CDFA78 ?
494E554700000000 ?
000000083 ?
ksedmp()+259 call dbkedDefDump() 000000003 000000003
7F7795CDF960 ?
7F7795CDFA78 ?
494E554700000000 ?
000000083 ?
ssexhd()+3188 call ksedmp() 00000044F 000000003 ?
7F7795CDF960 ?
7F7795CDFA78 ?
494E554700000000 ?
000000083 ?
sslssSynchHdlr()+39 call ssexhd() 000000001 000000000
9 7F7795D014B0 7F7795D01380
7F7795D012C0 000000083 ?
sslsshandler()+118 call sslssSynchHdlr() 000002000 000000000
000000000
7F7795D01380 ?
7F7795D012C0 ?
000000083 ?
__sighandler() call sslsshandler() 00000000B 7F7795D014B0
7F7795D01380 7F7795D01380
?
7F7795D012C0 ? 000000083 ?
kcfis_remove_and_fr signal __sighandler() 000000006 000000004
ee()+53 7F778F010120 000000004 ?
000000000 ? 000000000 ?
kcfis_deallocate_se call kcfis_remove_and_fr 7F778FBAD670 7F778FBAEA20
ssion()+2305 ee() 7F778F010120 000000004
000000000 ? 000000000 ?
kcfis_finalize_cach call kcfis_deallocate_se 7FFF1C816280 7F778FBAEA20
?
ed_sessions()+847 ssion() 7F778F010120 ? 000000004 ?
000000000 ? 000000000 ?
kxsffir()+342 call kcfis_finalize_cach 7F778FB971A0 000000005
ed_sessions() 7F778F010120 ? 000000004 ?
000000000 ? 000000000 ?
kxsFreeWorkArea()+9 call kxsffir() 7F779CAADF40 ? 000000005 ?
54 000000005 000000004 ?
000000000 ? 000000000 ?
kxsFreeExecutionHea call kxsFreeWorkArea() 7F779539FB50 ? 000000005 ?
p()+74 000000005 ? 000000004 ?
000000000 ? 000000000 ?
kksumc()+521 call kxsFreeExecutionHea 7F779539FB50 ? 000000001
p() 000000005 ? 000000004 ?
000000000 ? 000000000 ?
opiodr()+4684 call kksumc() 7F779539FB50 ? 000000005 ?
000000005 ? 7F779CA6B9A0
000000000 ? 000000000 ?
kpoodr()+3387 call opiodr() 00000005E 000000000
7FFF1C81B100 000000000
000000000 ? 000000000 ?
upirtrc()+2390 call kpoodr() 7F7795BE7918 00000005E
7FFF1C81B100 000000000
7FFF1C81B2C0 000000000 ?
kpurcsc()+102 call upirtrc() 7F7795BE7918 ? 00000005E ?
7FFF1C81B100 7FFF1C81B2C0

 

 



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.