ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues (Doc ID 1070715.6)

Last updated on SEPTEMBER 24, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.1.0.7 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.



Symptoms

A variety of symptoms may be reported including

ORA-00600: [kwqidrdq: loop] reported on dequeue of a message from an Advanced Queueing (AQ) Multi-Consumer Queue Table.

The following functions appear in the stack trace.

kwqidrdq
kwqididq
kwqidrdq
kwqiocideq
kwqididq

A Queue Monitor (QMON) slave (q00*) consuming a large amount of CPU and this being associated with work on a single queue table.

A message stuck in READY state but not being able to dequeue it or propagate it.

A message stuck in WAITING state but not being changed to the READY state after the appropriate time interval.

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