ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues
(Doc ID 1070715.6)
Last updated on MARCH 04, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 8.1.7 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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.
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