My Oracle Support Banner

ORA 7445 [qmxtr2CollectPreds_rec] when using XMLindex (Doc ID 2503960.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When using XMLINDEX, following query fails:

with s1 as

( select null from test,

xmltable('data' passing a_xml columns a_inner_xml xmltype path 'inner_xml' ) a,

xmltable('inner_xml' passing a_inner_xml columns a_inner_xml xmltype path 'inner_data' ) b ),

s2 as ( select null from test, xmltable('data' passing a_xml columns a_inner_xml xmltype path 'inner_xml' ) )

select * from s1,s2;

/

with s1 as

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 19007

Session ID: 1575 Serial number: 65454

Alert.log has:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x8559B5D, qmxtr2CollectPreds_rec()+61] [flags: 0x0, count: 1]
Errors in file ...................
ORA-07445: exception encountered: core dump [qmxtr2CollectPreds_rec()+61] [SIGSEGV] [ADDR:0x10] [PC:0x8559B5D] [Address not mapped to object] []

Changes

 

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
Changes
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.