ORA-00600 [17183] When Running a Query

Last updated on MAY 29, 2015

Applies to:

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