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
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。