Dequeue Session reports ORA-600 [KWQIDOREFETCH:ERR] on abnormal session end

(Doc ID 748577.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.1.0 to 10.2.0.4.0



Symptoms

ORA-00600 [kwqidorefetch:err], [604] and ORA-03113 reported in alert.log and trace files generated with following error stack

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kwqidorefetch:err], [604],
[ORA-00604: error occurred at recursive SQL level 2
ORA-03113: end-of-file on communication channel
], [], [], [], [], []
Current SQL statement for this session:
begin dbms_aqin.aq$_dequeue_in( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11,
:12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26,
:27, :28, :29); end;
----- PL/SQL Call Stack -----
object line object
handle number name
7000000ca5fee80 571 package body SYS.DBMS_AQIN
7000000bbc36a20 1 anonymous block
----- Call Stack Trace -----
ksedst
ksedmp
ksfdmp
kgerinv
kgesinv
ksesin
OCIKSIN
kwqidorefetch
kwqidexfcy
kwqidrdq
kwqidsfmp

after a dequeue session ends abnormally.

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