My Oracle Support Banner

ORA-600 [KDSGRP1-KDSGRP] or [KDSGRP1-QETLBR] due to domain index or text index (Doc ID 2817675.1)

Last updated on JANUARY 28, 2022

Applies to:

Oracle Text - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 19c, the select query fails intermittently 

ORA-00600: internal error code, arguments: [kdsgrp1-kdsgrp], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kdsgrp1-qetlbr], [], [], [], [], [], [], [], [], [], [], []

 

Plan Table
============
------------------------------------------------------------------------------------+-----------------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | Pstart| Pstop |
------------------------------------------------------------------------------------+-----------------------------------+---------------+
| 0 | SELECT STATEMENT | | | | 20 | | | |
| 1 | VIEW | | 1 | 184 | 20 | 00:00:01 | | |
| 2 | WINDOW BUFFER | | 1 | 158 | 20 | 00:00:01 | | |
| 3 | COUNT | | | | | | | |
| 4 | VIEW | | 1 | 158 | 20 | 00:00:01 | | |
| 5 | SORT UNIQUE | | 1 | 53 | 19 | 00:00:01 | | |
| 6 | FILTER | | | | | | | |
| 7 | NESTED LOOPS | | 1 | 53 | 4 | 00:00:01 | | |
| 8 | NESTED LOOPS | | 1 | 53 | 4 | 00:00:01 | | |
| 9 | TABLE ACCESS BY INDEX ROWID | <TABLE NAME> | 1 | 55 | 1 | 00:00:01 | | |
| 10 | DOMAIN INDEX | <domain index> | 78 | | 1 | 00:00:01 | | |                  >>>>>>>>> There is a domain index in plan
| 11 | INDEX UNIQUE SCAN | <some index> | 1 | | 2 | 00:00:01 | | |

 

Call stack show as:

[02]: kdsgrp1_assert [KDSRID]<-- Signaling
[03]: kdsgrp [KDSRID]
[04]: qetlbr []
[05]: qertbFetchByRowID [SQL_Execution]
[06]: qerjotFetch [SQL_Execution]
[07]: qerjotFetch [SQL_Execution]
[08]: qerflFetch [SQL_Execution]
[09]: qersoProcessULS [SQL_Execution]
[10]: qersoFetchSimple [SQL_Execution]
[11]: qersoFetch [SQL_Execution]
[12]: qervwFetch [SQL_Execution]
[13]: qercoFetch [SQL_Execution]
[14]: qerwnFetch [SQL_Execution]
[15]: qervwFetch [SQL_Execution]
[16]: opifch2 [OPI]

Changes

Database is upgraded to 18c or higher 

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.