XMLTABLE Query Fails with ORA-600 [17147], ORA-7445 [LpxFSMSax()+15529]
(Doc ID 3049343.1)
Last updated on SEPTEMBER 23, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
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
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 |