ORA-07445: Exception Encountered: Core Dump [kolnvld()+2] with Spatial Filter Queries
(Doc ID 1627198.1)
Last updated on JULY 15, 2021
Applies to:
Oracle Spatial and Graph - Version 12.1.0.1 and laterInformation in this document applies to any platform.
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
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 |