ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues
(Doc ID 1070715.6)
Last updated on FEBRUARY 16, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.1.0.7 [Release 8.1.7 to 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
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) worker (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.
Changes
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 |
Changes |
Cause |
Solution |
References |