首页 » ORACLE » ORA-00600: [kwqidrdq: loop], [0] in Oracle 9i

ORA-00600: [kwqidrdq: loop], [0] in Oracle 9i

DB alert log frequently show the following error:

 Wed Dec 27 17:33:09 2017
Errors in file /ora/weejar/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
Wed Dec 27 17:34:14 2017
Errors in file /ora/weejar/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
Wed Dec 27 17:35:19 2017
Errors in file /ora/weejar/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
Wed Dec 27 17:36:24 2017
Errors in file /ora/weejar/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
Wed Dec 27 17:37:29 2017
Errors in file /ora/weejar/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc:

trace file show

Dump file /ora/weejar/db/weejardb/9.2.0/admin/weejar_anbob1/udump/weejar_ora_4458.trc
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /ora/weejar/db/weejardb/9.2.0
System name:	SunOS
Node name:	anbob
Release:	5.10
Version:	Generic_148888-01
Machine:	sun4v
Instance name: weejar
Redo thread mounted by this instance: 1
Oracle process number: 345
Unix process pid: 4458, image: oracle@anbob (TNS V1-V3)

*** 2017-12-26 18:04:09.055
*** SESSION ID:(81.52806) 2017-12-26 18:04:09.049
Txn id , Step# 213
*** 2017-12-26 18:04:09.055
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
Current SQL statement for this session:
BEGIN WF_EVENT_OJMSTEXT_QH.DEQUEUE(:1, :2, :3); END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
f00588bb0       221  package body SYS.DBMS_AQ
f08f4d660      1015  package body APPS.WF_EVENT_OJMSTEXT_QH
f86a0cc70         1  anonymous block
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?
                                                   000000000 ? 00000004A ?
                                                   FFFFFFFF7FFF1B48 ?
                                                   10331A258 ?
kgerinv()+184        PTR_CALL 0000000000000000     00010373F ? 10373F000 ?
                                                   10373F068 ? 103744000 ?
                                                   000102C00 ? 000000000 ?
kgeasnmierr()+28     CALL     kgerinv()            10373F2C8 ? 1038D32F8 ?
                                                   0000013C8 ? 000000004 ?
                                                   1037413D4 ? 103740698 ?
kwqidrdq()+6480      CALL     kgeasnmierr()        10373F2C8 ? 1038D32F8 ?
                                                   1033DD6A8 ? 000000004 ?
                                                   000000004 ? 000000000 ?
kwqididq()+4728      CALL     kwqidrdq()           10373F068 ? 000000020 ?
                                                   FFFFFFFF7FFF5CA0 ?
                                                   000103744 ? 10373F068 ?
                                                   FFFFFFFF7FFF6408 ?
kwqiocideq()+3140    CALL     kwqididq()           10373F408 ? 000103400 ?
                                                   FFFFFFFF7FFF6408 ?
                                                   FFFFFFFF7CA7E2F8 ?
                                                   00010373F ? 00010373F ?
kwqidxdeq()+1816     CALL     kwqiocideq()         000000089 ? 103894838 ?
                                                   000000000 ? 10373F290 ?
                                                   000000540 ?
                                                   FFFFFFFFFFFFFFFF ?
kwqiadtdeq()+780     CALL     kwqidxdeq()          000000000 ? 1038ABF16 ?
                                                   000000089 ? 000000000 ?
                                                   000000000 ? 1038978C8 ?
spefcmpa()+1028      PTR_CALL 0000000000000000     10373F068 ? 000000000 ?
                                                   000000000 ? 1038979F8 ?
                                                   103897960 ? 103897858 ?
spefmccallstd()+184  CALL     spefcmpa()           FFFFFFFF7CA5B288 ?
                                                   103894838 ? 100DDE7A0 ?
                                                   FFFFFFFF7FFF7EB8 ?
                                                   000000000 ? 000000000 ?
peftrusted()+132     CALL     pextproc()           FFFFFFFF7FFF8C78 ?
                                                   FFFFFFFF7FFF8880 ?
                                                   FFFFFFFF7FFF8950 ?
                                                   FFFFFFFF7FFF88C0 ?
                                                   000000000 ? 102EF2000 ?

To search in MOS is matched Note 1070715.6

kwqid==》Streams Advanced Queuing Dequeue Call function

[R]eported on [D]equeue of a messages from an Advanced [Q]ueueing.

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

Cause
In some cases rows have been manually deleted from the Queue Table

In Bug 9593216 the ORA-00600 [kwqidrdq: loop] is raised because a message enqueued with delay specified has been dequeued via msgid before the message state has been switched to READY.

The entry is no longer in the queue table and any other dequeue session which attempts to dequeue the message will report the ORA-00600 [kwqidrdq: loop].

WORKAROUND:
———–
Do not dequeue message with delay using message-id. Alternately the delay
period may be extended so that the race between the aq background and dequeue
can be avoided.

more to read MOS note 1070715.6

打赏

目前这篇文章还没有评论(Rss)

我要评论