My Oracle Support Banner

SDO_RELATE Query Fails with ORA-07445 [mdmrtLinkLine()+355] (Doc ID 2539030.1)

Last updated on MAY 06, 2019

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

In 12.x, following SDO_RELATE query:

select column1
from GIS_USER.TABLENAME a
where
sdo_relate(a.geoloc,
          (select sdo_aggr_union(sdoaggrtype(geoloc,1))
           from SPATIAL_USER.V_TABLENAME where ID_COL = '123-456-789-001' ), 'mask=anyinteract querytype=window')= 'TRUE'
           order by sdo_geom.sdo_area
                    (SDO_GEOM.SDO_INTERSECTION(
                      sdo_cs.transform(a.geoloc,3067),
                                       (select sdo_aggr_union(sdoaggrtype(geoloc,1))
                                        from SPATIAL_USER.V_TABLENAME
                                        where ID_COL = '123-456-789-001' ),1),1) desc;


Fails with

ORA-07445: exception encountered: core dump [mdmrtLinkLine()+355] [SIGSEGV] [ADDR:0x0] [PC:0x588B133] [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.