Suspected Corrupt Spatial Index (Doc ID 1362406.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


SDO_NN generates internal error

SELECT *
FROM
(
SELECT ID, SDO_NN_DISTANCE(1) distance
FROM LOCATION loc
WHERE SDO_NN(loc.LOCATION,
MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(-110,32,null),null,null), 'SDO_NUM_RES=30 unit=M distance=1.5239999976835199E7 SDO_MAX_MEMORY=50000000',1) = 'TRUE'
ORDER BY 2
)
WHERE ROWNUM < 30;


====== Call Stack ======
ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ssexhd <- 47b8 <- kohfrem <- kohfrr <- kpmfree
<- OCIMemoryFree <- mdrtfree <- mdrtcl <- mdidxc <- qeroifcc
<- rpiswu2 <- qeroifcsu <- qeroiirc <- kxsffir <- kxsFreeWorkArea
<- kksumc <- opiexe <- kpoal8 <- opiodr <- kpoodr
...
...
====== Error Message ======
ORA-07445: exception encountered: core dump [kghufree()+1076] [SIGSEGV] [ADDR:0xBFEC0FBA8826AA96] [PC:0x1010E9054] [Address not mapped to object] []
ORA-29400: data cartridge error
ORA-21779: duration not active
ORA-29902: error in executing ODCIIndexStart


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