ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues
Last updated on SEPTEMBER 24, 2013
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
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.
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.
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