ORA-600 [KDSGRP1] ON DOMAIN INDEX WITH CONCURRENT INSERT & SELECT (WITH CLAUSE) (Doc ID 2339026.1)

Last updated on APRIL 01, 2020

Applies to:

Symptoms

Under heavy load, a large query with domain indexes fails with ORA-00600 [kdsgrp1] .

Verified by the following:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 10125 (ORA 600 [kdsgrp1]) ========

*** 2015-12-28 15:00:08.138
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d4ap0dy8qd9qc) -----
with list_entite as(
select distinct(id_entite), date_entite, source, destination, etat, type_entite
from int_portailsoa.soa_entite entite WHERE entite.id_entite in(
select id_entite
from int_portailsoa.soa_entite
where to_char(date_entite, 'DD/MM/YYYY') like '%' || upper(replace('06F578', '*', '%')) || '%'
or upper(source) like '%' || upper(replace('06F578', '*', '%')) || '%'
or upper(destination) like '%' || upper(replace('06F578', '*', '%')) || '%'
or upper(type_entite) like '%' || upper(replace('06F578', '*', '%')) || '%'
or upper(nom_fichier) like '%' || upper(replace('06F578', '*', '%')) || '%'
or upper(etat) like '%' || upper(replace('06F578', '*', '%')) || '%'
UNION select id_entite from int_portailsoa.soa_entite where contains(flux, '{'||'06F578'||'}')>0
UNION select id_entite from int_portailsoa.soa_log where upper(valeur) like '%' || upper(replace('06F578', '*', '%')) || '%'
UNION select id_entite from int_portailsoa.soa_log where contains(contenu, '{'||'06F578'||'}')>0)
)
select * from (
select * from (
select 'date' as name, 'J' as data, count(id_entite) as count
from int_portailsoa.list_entite where trunc(date_entite) = trunc(sysdate)
union all
select 'date' as name, 'J-1' as data, count(id_entite) as count
from int_portailsoa.list_entite where trunc(date_entite) = trunc(sysdate-1)
union all
select 'date' as name, 'J-2' as data, count(id_entite) as count
from int_portailsoa.list_entite where trunc(date_entite) = trunc(sysdate-2)
union all
select 'date' as name, 'J-3' as data, count(id_entite) as count
from int_portailsoa.list_entite where trunc(date_entite) = trunc(sysdate-3)
union all
select 'date' as name, 'J-n' as data, count(id_entite) as count
from int_portailsoa.list_entite where trunc(date_entite) <= trunc(sysdate-4) )
)
union all
select * from (
select 'source' as name, source as data, count(id_entite) as count
from int_portailsoa.list_entite group by source order by data
)
union all
select * from (
select 'destination' as name, destination as data, count(id_entite) as count
from int_portailsoa.list_entite entite group by destination order by data
)
union all
select * from (
select 'type' as name, type_entite as data, count(id_entite) as count
from int_portailsoa.list_entite group by type_entite order by data
)
union all
select * from (
select 'etat' as name, etat as data, count(id_entite) as count
from int_portailsoa.list_entite group by etat order by data
)

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE
<- 2136 <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv
<- kgeasnmierr <- kdsgrp1_dump <- kdsgrp1 <- kdsgrp_cb <- ktrgtc2
<- kdsgrp <- kdsfbrcb <- kdsoltr <- kdsololr1 <- kciRAGetRow
<- drebyGetTokenInfo <- dredilpg <- dredmseek <- dredseek <- drebytc
<- drexqiftc <- drexqpftc <- drexqftc <- drexrfetch <- qeroifcf
<- qeroifcsu <- qeroiFetch <- qertbFetchByRowID <- rwsfcd <- qeruaFetch
<- qersoProcessULS <- qersoFetch <- qervwFetch <- qersoProcessULS <- qersoFetch
<- qerjotFetch <- rwsfcd <- qerltFetch <- insdlexe <- insExecStmtExecIniE
<- ngine <- insexe <- ngine <- qes3tExecSQL <- qerleStart
<- selexe0 <- opiexe <- kpoal8 <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main <- libc_start_main <- start

----- DDE Diagnostic Information Dump -----
Depth: 1
DDE flags: 0x0
Heap: 0x7f7dd47efba8
Incident Context pointer in diag: 0x7fff17560d70
Incident ID Cache: 0x9a4bd470
Invocation Context #: 0
----- Invocation Context Dump -----
Address: 0x7f7dd4a34520
Phase: 3
flags: 0x18E0000
Incident ID: 10125
Error Descriptor: ORA-600 [kdsgrp1] [] [] [] [] [] [] [] [] [] [] []
Error class: 0
Problem Key # of args: 1
Number of actions: 12
----- Incident Context Dump -----
Address: 0x7fff17560d70
Incident ID: 10125
Problem Key: ORA 600 [kdsgrp1]
Error: ORA-600 [kdsgrp1] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgeasnmierr []
[08]: kdsgrp1_dump []<-- Signaling
[09]: kdsgrp1 []
[10]: kdsgrp_cb []
[11]: ktrgtc2 []
[12]: kdsgrp []
[13]: kdsfbrcb []
[14]: kdsoltr []
[15]: kdsololr1 []
[16]: kciRAGetRow []
[17]: drebyGetTokenInfo [Text]
[18]: dredilpg [Text]
[19]: dredmseek [Text]
[20]: dredseek [Text]
[21]: drebytc [Text]
[22]: drexqiftc [Text]
[23]: drexqpftc [Text]
[24]: drexqftc [Text]
[25]: drexrfetch [Text]
[26]: qeroifcf [SQL_Execution]
[27]: qeroifcsu [SQL_Execution]
[28]: qeroiFetch [SQL_Execution]
[29]: qertbFetchByRowID [SQL_Execution]
[30]: rwsfcd []
[31]: qeruaFetch [SQL_Execution]
[32]: qersoProcessULS [SQL_Execution]
[33]: qersoFetch [SQL_Execution]
[34]: qervwFetch [SQL_Execution]
[35]: qersoProcessULS [SQL_Execution]
[36]: qersoFetch [SQL_Execution]
[37]: qerjotFetch [SQL_Execution]
[38]: rwsfcd []
[39]: qerltFetch [SQL_Execution]
[40]: insdlexe [DML]
[41]: insExecStmtExecIniEngine [DML]
[42]: insexe [DML]
[43]: qes3tExecSQL [SQL_Execution]
[44]: qerleStart [SQL_Execution]
[45]: selexe0 []
[46]: opiexe []
[47]: kpoal8 []
[48]: opiodr []
[49]: ttcpip []
MD [00]: 'SID'='170.46183' (0x2)
MD [01]: 'ProcId'='65.190' (0x2)
MD [02]: 'PQ'='(16777223, 1451311186)' (0x6)
MD [03]: 'Client ProcId'='oracle@orasoa01.stef.com (TNS V1-V3).11703_140178418546432' (0x0)
Impact 0:
Impact 1:
Impact 2:
Impact 3:
Derived Impact:
----- END Incident Context Dump -----
----- END Invocation Context Dump -----

Changes

Cause

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