ORA-00600 [17183] When Running a Query (Doc ID 1342212.1)

Last updated on MAY 29, 2015

Applies to:

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

Symptoms

Alert log shows:

ORA-00600: internal error code, arguments: [17183], [0x2BA3EE755D00], [], [], []

The associated trace file shows the following call stack:

ksedst <- ksedmp <- ksfdmp <- kgeriv <- kgesiv <- kgesic1 <- kgherror <- kghfrf <- drumchf <- druhclose <- drhirel <- drorel <- drexqpurid <- drexqiftc <- drexqpftc <- drexqftc <- drexrfetch <- qeroifcf <- qeroifcsu <- qeroiFetch

The associated trace file plan table looks as follows:

============
Plan Table
============
-----------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 1 | |
| 1 | WINDOW BUFFER | | 1 | 150 | 1 | 00:00:01 |
| 2 | TABLE ACCESS BY INDEX ROWID | PRODUCT$1 | 1 | 150 | 1 | 00:00:01 |
| 3 | DOMAIN INDEX | PRODUCT_CTX_DE_DE$1| 2128 | | 1 | 00:00:01 |
-----------------------------------------------------------+-----------------------------------+

The ORA-00600 [17183] occurred on the following select statement:

SELECT p.uuid AS UUID, count(*) over() as ROWCOUNT
FROM product p
WHERE contains(p.attributes_de_DE,
:1 ||' INPATH (/ATTRIBUTES_DE_DE/attrs/attr[@name="ITEMATTRIBUTES_GROUPCODE"]/int) OR '|| :2 ||' INPATH (/ATTRIBUTES/attrs/attr[@name="ITEMATTRIBUTES_GROUPCODE"]/int)')>0
AND p.onlineflag = :3
AND p.domainid = :4


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