My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
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.