ORA-7445 [qmxInsertNodeBefore] during an insert into a binary XMLType table with virtual columns (Doc ID 1141863.1)

Last updated on JULY 13, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

Inserting multiple rows of full XML instance documents into a binary schema-based XMLType table with virtual columns and an index on the virtual columns terminates with an ORA-7445 [qmxInsertNodeBefore].

SQL> INSERT INTO BINARY_XMLTYPE_TAB
  2 SELECT XMLELEMENT
  3          ("MY_ELEMENT"
  4          ,XMLATTRIBUTES
  5           ('http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi"
  6
,'/test_binary/application/schemas/MY_SCHEMA.xsd' AS
"xsi:noNamespaceSchemaLocation"
  7           )
  8          ,EXTRACT(POL.COLUMN_VALUE,'/MY_ELEMENT/*')
  9          )
 10   FROM XMLTable('fn:doc(
 11
"/test_binary/repository/source/MY_ELEMENT_PolicyIds.xml")
 12                   /MY_ELEMENT_SET/MY_ELEMENT'
 13                 ) POL
 14  /
SELECT XMLELEMENT
       *
ERROR at line 2:
ORA-3113: end-of-file on communication channel
Process ID: 2114
Session ID: 132 Serial number: 33


Any full table scan also fails with the same error:

SQL> REM Any sql that performs a FTS generates the same error
SQL> SELECT POLICY_ID FROM BINARY_XMLTYPE_TAB;
SELECT POLICY_ID FROM BINARY_XMLTYPE_TAB
*
ERROR at line 1:
ORA-3113: end-of-file on communication channel
Process ID: 4522
Session ID: 43 Serial number: 3098


Alert.log shows:


Errors in file
/grdbms/64bit/patchdb/app/oracle/diag/rdbms/pb21sb/sPb21Sb/trace/sPb21Sb_ora_2114.trc (incident=1411):
ORA-7445: exception encountered: core dump [qmxInsertNodeBefore()+4932] [SIGSEGV] [ADDR:0x40] [PC:0x106C6C8A4] [Address not mapped to object] []


The call stack trace shows:


ssexhd <- restore_rt <- qmxInsertNodeBefore <- qmxcManifestFromStream
<- qmxManifest <- qmxGetFirstChildInt <- qmxdGetFirstChild <- xvmChild
<- xvmrun <- xvmRunCode <- xvmEvaluateXQuery <- qmxqrsExXQryUsingVM


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms