XMLTABLE Query Fails with ORA-600 [17147], ORA-7445 [LpxFSMSax()+15529] (Doc ID 3049343.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

Symptoms

On 19c, an XMLTABLE query fails with the following errors:

ORA-00600: internal error code, arguments : [17147], [0x7FE7F8AA1F70], [], [], [], [], [], [], []
ORA-07445: exception encounterd: core dump [LpxFSMSax()+15529] [SIGSEGV] [ADDR:0x7F5EC1776000] [PC:0x4435A19] [Invalid permissions for mapped object] []


The call stack in the incident trace files have the functions below:

ORA-00600: internal error code, arguments: [17147], [0x7FC6DE312FC8], [], [], [], [], [], [], [], [], [], []

kgherror_flag <- kghfrmrg <- kghfre <- kghfrh_internal <- qmxuParseXobDoc_int
<- qmxuParseXobDocument <- qmxtgCreateFromLobWF <- qmxtkCreateFromLob
<- qmxtkCreateFromBlob <- spefcpfa <- spefmccallstd <- peftrusted <- psdexsp
<- kxe_push_env_internal_pp_ <- kkx_push_env_for_ICD_for_new_session <- psdextp
<- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peicnt <- kkxuexe <- kkxmpsexe <- kgmexwi <- kgmexec <- evapls <- evaopn2
<- qervwRowProcedure <- qercoRop <- qerflRop <- qertbFetchByRowID <- qerflFetchOutside
<- qercoFetch <- qervwFetch <- qerjotFetch <- opifch2 <- opifch <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

ORA-07445: exception encounterd: core dump [LpxFSMSax()+15529] [SIGSEGV] [ADDR:0x7F5EC1776000] [PC:0x4435A19] [Invalid permissions for mapped object] []

LpxFSMSax <- LpxFSMParseDocument <- LpxParse <- LpxStreamParse
<- qmxuParseXobDoc_int <- qmxuParseXobDocument <- qmxtgCreateFromLobWF
<- qmxtkCreateFromLob <- qmxtkCreateFromBlob <- spefcpfa <- spefmccallstd
<- peftrusted <- psdexsp <- kxe_push_env_internal_pp_
<- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
<- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxuexe <- kkxmpsexe
<- kgmexwi <- kgmexec <- evapls <- evaopn2 <- qervwRowProcedure <- qercoRop <- qerflRop
<- qertbFetchByRowID <- qerflFetchOutside <- qercoFetch <- qervwFetch <- qerjotFetch
<- opifch2 <- opifch <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main

Cause

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