Spatial Query Fails With ORA-00600 [kdsgrp1]

(Doc ID 2057125.1)

Last updated on OCTOBER 05, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Database reporting the following error(s) in the alert.log:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dmsnpdb/dmsnpdb1/incident/incdir_2112559/dmsnpdb1_s000_5767_i2112559.trc


The internal error is raised for a Spatial query:

select cdmalcibop0_.BTS_ID as col_0_0_, cdmalcibop0_.SECTOR as col_1_0_, 
cdmalcibop0_.CARRIER as col_2_0_,
cdmalcibop0_.RECORD_STATE as col_3_0_, cdmalcibop0_.LATITUDE as col_4_0_, 
cdmalcibop0_.LONGITUDE as col_5_0_,
cdmalcibop0_.CELLID as col_6_0_, cdmalcibop0_.PN_OFFSET as col_7_0_, 
cdmalcibop0_.AZIMUTH as col_8_0_,
cdmalcibop0_.FCC_CHANNEL as col_9_0_, cdmalcibop0_.CARRIER_TYPE as col_10_0_, 
cdmalcibop0_.SID as col_11_0_,
cdmalcibop0_.NID as col_12_0_, cdmalcibop0_.MSC_ID as col_13_0_, 
cdmalcibop0_.HORIZONTAL_BEAM_WIDTH as col_14_0_,
cdmalcibop0_.PN_INCREMENT as col_15_0_, cdmalcibop0_.BAND_CLASS as col_16_0_, 
cdmalcibop0_.CHANNEL_LIST as col_17_0_,
cdmalcibop0_.REGISTRATION_ZONE as col_18_0_, cdmalcibop0_.TOTAL_ZONE as 
col_19_0_, cdmalcibop0_.VENDOR_ID as col_20_0_,cdmalcibop0_.CSFB_CAPABILITY as col_21_0_
from CDMA_LCIB_DATA_RECORD_ cdmalcibop0_
where SDO_WITHIN_DISTANCE(GEOM, SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(77.670327 , 12.924859 , null), null, null),
'distance=25 unit=km')='TRUE' and RECORD_STATE=1; 

and the call stack trace is rather generic for this ORA-600:

...kdsgrp1_dump qetlbr qertbFetchByRowID opifch2 opifch...

 

Checking for TABLE/INDEX inconsistency :-
 
analyze table CDMA_LCIB_DATA_RECORD_ validate structure cascade;
 
table is analyzed successfully.

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