ORA-07445: Exception Encountered: Core Dump [kolnvld()+2] with Spatial Filter Queries (Doc ID 1627198.1)

Last updated on JULY 15, 2021

Applies to:

Symptoms

Spatial filter queries return "ORA-07445: exception encountered: core dump [kolnvld()+2] [ACCESS_VIOLATION]" if
a 2D filter area is used with 3D data. The trace shows -

ORA-7445: Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0]
[PC:0x7FF28DC06D2, kolnvld()+2]

-- This query on 2D point data works fine.

select count(*) from cities2d a, filterarea b where
mdsys.sdo_relate(a.geometry, b.geometry,'mask=INSIDE')='TRUE';

COUNT(*)
----------
    2303

-- On the same 3D data, the connection is terminated and the alert log shows ORA-07445.  Trace shows access violation.

select count(*) from cities a, filterarea b where
mdsys.sdo_relate(a.geometry, b.geometry,'mask=INSIDE')='TRUE';
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3276
Session ID: 365 Serial number: 19331

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
000007FFAA26D490       333  MDSYS.SDO_INDEX_METHOD_10I

This behavior is seen seen on Oracle Database 12c but not on earlier releases.  

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.