RE: ORA-600 [7999][113] - Full Call Stack... Beware!
- From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
- To: nnahata@xxxxxxxxxxxx, "'K Gopalakrishnan'" <kaygopal@xxxxxxxxx>
- Date: Wed, 29 Sep 2004 07:56:42 -0500
Looking at the stack trace, it looks like you are hitting a bug during
context (Intermedia/Oracle text) index sync on a table with LOB column.
There are couple of corruption bugs in this area due to heavy concurrent
DML and ctx_ddl index sync operations on the same columns. You might
want to consider reducing the concurrency or schedule index sync
operations accordingly as a workaround.
I guess, OSS also can provide much more details/patch.
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nahata, Naveen (US -
Hyderabad)
Sent: Wednesday, September 29, 2004 7:20 AM
To: K Gopalakrishnan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: ORA-600 [7999][113] - Full Call Stack... Beware!
Hi Mladen, Steve and KG
I've found a bug 3361118 related to ORA-600 [7999} on metalink, but the
second argument differs (bug is for [9] I get [113]). I have asked
Oracle if I can go ahead and apply the same patch.
As per KGs suggestion I'm pasting the entire call stack. I didn't paste
earlier since that would have made the mail quite long.
Here it goes:
ORA-00600: internal error code, arguments: [7999], [113], [], [], [],
[], [], [] No current SQL statement being executed.
----- PL/SQL Call Stack -----
object line object
handle number name
c00000012b4e1318 0 procedure CTXSYS.SYNCRN
c000000101e18c28 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
----------------------------
ksedmp()+184 ? ksedst() 4000000002EA463F ?
000000039 ? 000000004
?
8000000100124378 ?
ksfdmp()+32 ? ksedmp() 000000000 ? 400000000
?
000000071 ?
40000000005DC610 ?
kgeriv()+152 ? ksfdmp() 000000071 ?
40000000005DC610 ?
8000000100122E18 ?
8000000100122E18 ?
kgeasi()+172 ? kgeriv() 8000000100122E18 ?
0001200FF ?
kgeasi()+172 ? kgeriv() 8000000100122E18 ?
0001200FF ?
8000000100126D48 ?
400000000117577B ?
kdlclose()+1220 ? kgeasi() 8000000100124368 ?
400000000125C547 ?
800000010021CE50 ?
000000000 ?
kdl_write()+8328 ? kdlclose() 8000000100109548 ?
8000000100109548 ?
000930A44 ? 000000000
?
koklcwrite()+700 ? kdl_write() 000000000 ? 000000000
?
002000000 ?
8000000100109548 ?
kpolob()+904 ? koklcwrite() 000000000 ? 0000000D0
?
000000000 ? 000000000
?
opiodr()+2396 ? kpolob() 40000000012968BB ?
800003FA0003DBC0 ?
C0000000F2168FD0 ?
400000000130959F ?
ttcpip()+1320 ? opiodr() 000000458 ?
40000000005DC340 ?
40000000013ADFCB ?
800003FAC00804B8 ?
opitsk()+1260 ? ttcpip() C000000000000000 ?
3E35798EE2308C41 ?
800003FA0003CE88 ?
00021BF80 ?
opicdr()+288 ? opitsk() 40000000016D524B ?
8000000100004730 ?
400000000088F228 ?
000126D48 ?
opidrv()+76 ? opicdr() 3E35798EE2308C41 ?
800003FA401D3868 ?
8000000100124378 ?
00000001D ?
sou2o()+40 ? opidrv() 5F400000692C041 ?
80424A0000CD8CE0 ?
8CE005F400000692 ?
9280416C0000CD8C ?
osnsglw()+212 ? sou2o() 8CE005F400000692 ?
9280416C0000CD8C ?
osnsglw()+212 ? sou2o() 8CE005F400000692 ?
9280416C0000CD8C ?
CD8CE005F4000006 ?
6928041420000 ?
upirtrc()+988 ? osnsglw() 400000000051D600 ?
800003FFFE0079CC ?
800003FA00030A80 ?
40000000012A50E3 ?
kpurcsc()+100 ? upirtrc() 000000000 ?
800003FA401C2EF8 ?
000000001 ?
40000000012AC05B ?
kpulfwr()+6372 ? kpurcsc() 40000000012AC05B ?
C0000000F82B0D98 ?
40000000012F5D4B ?
00000BA88 ?
OCILobWrite()+68 ? kpulfwr() 000000000 ? 000000000
?
775F6E6F203D203A ?
073656C65 ?
drekrtd()+1008 ? OCILobWrite() 000000000 ? 000000000
?
000000000 ? 000000000
?
drexdsync()+208 ? drekrtd() 40000000012CF91B ?
8000000100124328 ?
4000000001327FE3 ?
8000000100126D48 ?
spefcmpa()+308 ? drexdsync() C00000010F4905B8 ?
000000000 ?
800003FB8005FE30 ?
800003FB80050070 ?
spefmccallstd()+212 ? spefcmpa() 400000000345D19F ?
8000000100120018 ?
800003FA0005AA88 ?
800003FFFDFFF9B0 ?
pextproc()+252 ? spefmccallstd() 800003FFFDFFEFB8 ?
C0000000DA185FC0 ?
800003FC8000EEF0 ?
8000000100124368 ?
peftrusted()+420 ? pextproc() 800003FC8000EEF0 ?
8000000100124368 ?
800003FFFDFFF978 ?
8000000100124368 ?
800003FFFDFFF978 ?
8000000100109D48 ?
psdexsp()+76 ? peftrusted() C0000000A6F8BE00 ?
C000000049FD0200 ?
000000000 ? 000001530
?
rpiswu2()+420 ? psdexsp() 800003FB80059638 ?
4000000001299237 ?
800003FFFDFFC2C8 ?
4000000001300648 ?
psdextp()+516 ? rpiswu2() 400000000345907F ?
C000000101E18C28 ?
000000000 ?
8000000100122E18 ?
pefccal()+900 ? psdextp() 000000006 ? 000000000
?
000000000 ? 000000000
?
pefcal()+124 ? pefccal() 000000000 ?
800003FA0003AF10 ?
800003FFFDFFF0B8 ?
C0000001277FC750 ?
pevm_FCAL()+360 ? pefcal() 800003FA0005AA88 ?
800003FFFDFFCFB0 ?
800003FB8005F6E4 ?
800003FA0005AAF0 ?
pfrrun()+79480 ? pevm_FCAL() 000000000 ?
4000000000538C78 ?
C0000000FBFE6808 ?
800003FFFDFFEC10 ?
peicnt()+276 ? pfrrun() 800003FF00000002 ?
000000000 ? 000000000
?
8000000100122E18 ?
kkxexe()+620 ? peicnt() 000000000 ?
C0000000DDFDA280 ?
000000000 ?
400000000130140F ?
opiexe()+10556 ? kkxexe() 800000010000B478 ?
000000000 ?
800003FFFDFFB6E8 ?
000000000 ?
opiall0()+2424 ? opiexe() 000000000 ? 3019DC8AF
?
000000000 ? 100000000
?
opiall0()+2424 ? opiexe() 000000000 ? 3019DC8AF
?
000000000 ? 100000000
?
opikpr()+404 ? opiall0() 000000000 ?
8000000100126D48 ?
800003FFFDFF9D28 ?
8000000100126D48 ?
opiodr()+2396 ? opikpr() 1036700000000 ?
000126D48 ?
800003FFFDFF7BD0 ?
C000000000205E17 ?
rpidrus()+160 ? opiodr() 000000000 ? 000000000
?
000010000 ?
800003FFFDFF4DB0 ?
skgmstack()+156 ? rpidrus() 40000000012F8067 ?
000000001 ? 000000000
?
8000000100126D48 ?
rpidru()+152 ? skgmstack() 000000000 ? 0011C005F
?
100439A88 ?
C0000000ED37B1E0 ?
rpiswu2()+420 ? rpidru() 4000000000439A88 ?
FFFFFFFF00000001 ?
000010000 ?
800003FFFDFF4DB0 ?
kprball()+1268 ? rpiswu2() 000000008 ?
4000000000000000 ?
800003FFFDFF7818 ?
8000000100109548 ?
drexds()+684 ? kprball() 40000000005DC2F0 ?
800003FFFDFF74B0 ?
000126D48 ?
400000000160D3A0 ?
ktcccdel()+284 ? drexds() 800000010000B948 ?
8000000100126D48 ?
8000000100126D48 ?
800003FAC0085070 ?
ktcrcm()+1728 ? ktcccdel() 8000000100126D48 ?
4000000002E9EED7 ?
C00000000B007888 ?
000000018 ?
ktdcmt()+112 ? ktcrcm() 800003FAC0084E70 ?
800000010000B948 ?
000000000 ?
800000010000B948 ?
k2lcom()+104 ? ktdcmt() 0000007A0 ?
40000000013E3087 ?
4000000001300648 ?
C00000007FFFFFFF ?
k2send()+848 ? k2lcom() C00000007FFFFFFF ?
800003FFFDFF6B70 ?
800003FFFDFF6B70 ?
4000000000444900 ?
xctctl()+92 ? k2send() 400000000118E307 ?
8000000100124328 ?
40000000005DC228 ?
8000000100126D48 ?
xctcom()+264 ? xctctl() 400000000226A5AF ?
4000000001011483 ?
400000000160D447 ?
000000000 ?
kpoltxen()+28 ? xctcom() 40000000012F5F1F ?
8000000100124360 ?
800000010000B478 ?
000000005 ?
kpotxen()+164 ? kpoltxen() 800000010000B478 ?
000000005 ?
80000001001EA018 ?
000000000 ?
opiodr()+2396 ? kpotxen() 000000000 ?
4000000001113DEB ?
C000000000205E17 ?
800003FFFDFF2E00 ?
ttcpip()+1320 ? opiodr() 80000001000047A0 ?
000000002 ?
32300000000 ?
80000001001653B8 ?
opitsk()+1260 ? ttcpip() 000000100 ? 000000020
?
800003FC8000EEF0 ?
800003FC800143A8 ?
opiino()+1484 ? opitsk() 000000000 ? 000000000
?
000000000 ? 000000000
?
opiodr()+2396 ? opiino() 000000000 ? 000000000
?
800003FDC0002F50 ?
000000000 ?
800003FDC0002F50 ?
000000000 ?
opidrv()+752 ? opiodr() 800003FFFDFF13E0 ?
C0000000002043CB ?
800003FFFDFF13E0 ?
800000010019A7F8 ?
sou2o()+40 ? opidrv() 800003FFBFFFF480 ?
C0000000000218B3 ?
000000000 ?
C0000000002045AB ?
main()+228 ? sou2o() 000000000 ?
C0000000002045AB ?
000000002 ?
70726F642F70726F ?
$START$()+160 ? main() 800003FFFDFF0E38 ?
800003FFFDFF0BF6 ?
800003FFFDFF0A1E ?
800003FFFDFF0905 ?
-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]=20
Sent: Wednesday, September 29, 2004 5:44 PM
To: Nahata, Naveen (US - Hyderabad)
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-600 [7999][113]
Naveen,
>=20
> Anyways, what does "ksedmp" mean?
KSEDMP is the functions which dumps the error stack/process state
depending on the failure (Kernel Services Errorstack DuMP or something
similar to that). BTW your errorstack is not complete. We need the
functions followed by KGE to get the cause as KGE is also a generic
error reporting function.. Just post the some more lines (after KGE
functions) and someone (!) may be able to help you.
--=20
Best Regards,
K Gopalakrishnan=20
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/00722272
This message (including any attachments) contains confidential =
information intended for a specific individual and purpose, and is =
protected by law. If you are not the intended recipient, you should =
delete this message. Any disclosure, copying, or distribution of this =
message, or the taking of any action based on it, is strictly =
prohibited.
--
//www.freelists.org/webpage/oracle-l
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
--
//www.freelists.org/webpage/oracle-l
Other related posts: