Hi,

Why is this error called fatal error ? whats basically happening is nothing other than an insert failure in the child table as the parent doesn't have the corresponding key values in it. It's one of those insert failures becuase of foreign key violation. But why is this error called "fatal error" ? Does this error means something is really going bad or is this a normal error message? The trace file is given below.


thanks

Parijat Paul



----trace file------

ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 5, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows NT Version 4.0 Service Pack 5, CPU type 586
Instance name: gendb


Redo thread mounted by this instance: 1

Oracle process number: 16

Windows thread id: 262, image: ORACLE.EXE


*** 2001-07-30 18:10:25.578
*** SESSION ID:(73.5572) 2001-07-30 18:10:25.578
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2001-07-30 18:10:25.578
ksedmp: internal or fatal error
ORA-20002: Cannot INSERT Properties_Text_Indexed because Global_Objects does not exist.
ORA-06512: at "TEST.TI_PROPERTIES_TEXT_INDEXED", line 17
ORA-04088: error during execution of trigger 'TEST.TI_PROPERTIES_TEXT_INDEXED'
Current SQL statement for this session:
insert into Properties_Text_Indexed(objecttypeid,objectid,propertyid,sequence,valueproperty)
values( :1 , :2 , :3 , :4 , :5 )
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
6CCE480
_opitsk+f50 CALLrel _ksedmp+0 2
_opiino+50c CALLrel _opitsk+0 0
_opiodr+506 CALLreg 00000000 3C 4
36CCFBFC
_opidrv+384 CALLrel _opiodr+0 3C 4
36CCFBFC
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+49f CALLrel _opimai+0 2
36CCFE78
77F04EE5 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=36cce480.
Dump of memory from 0x36CCE440 to 0x36CCE580
36CCE440 00000003 00000000 6552211D 00000033 [.........!Re3...]
36CCE450 00000000 00000003 36CCE415 00000000 [...........6....]
36CCE460 00000000 00000000 168C5F00 00000000 [........._......]
36CCE470 0000001D 36CCE48C 0041E204 00000001 [.......6..A.....]
36CCE480 00E191B4 00E191B4 00E191B4 00E191BC [................]
36CCE490 00E191B4 00E191B4 00E191B4 00E191B4 [................]
36CCE4A0 00E191BC 00000000 00000000 00000000 [................]
36CCE4B0 168C5F00 36CCE568 0041F119 36CCE4CC [._..h..6..A....6]
36CCE4C0 0000001C 168C5F00 00000002 2A2A2A0A [....._.......***]
36CCE4D0 30303220 37302D31 2030332D 313A3831 [ 2001-07-30 18:1]
36CCE4E0 35323A30 32332D25 2D252073 25207338 [0:25%-32s %-8s %]
36CCE4F0 7332332D 36CC0020 60B16307 00000000 [-32s ..6.c.`....]
36CCE500 0000311B 43363320 37454643 25200038 [.1.. 36CCFE78. %]
36CCE510 7332332D 342D2520 36000A73 0000311B [-32s %-4s..6.1..]
36CCE520 655221B4 168C0033 00000000 00000000 [.!Re3...........]
36CCE530 00000000 00000000 00000000 00000000 [................]
36CCE540 36CCFFEC 00000000 36CCFE78 00000000 [...6....x..6....]
36CCE550 00000001 00000001 00000000 36CCDCC8 [...............6]
36CCE560 00000003 36CCE58C 00477F2D 36CCE4A4 [.......6-.G....6]
36CCE570 00000000 0000311B 168C8B98 00000000 [.....1..........]
Argument/Register addr=36ccfbfc.
Dump of memory from 0x36CCFBBC to 0x36CCFCFC
36CCFBB0 77F1C823 [#..w]
36CCFBC0 36CCFBF0 001F0003 36D04AFC 60840538 [...6.....J.68..`]
36CCFBD0 00000000 00000000 00000000 0000004C [............L...]
36CCFBE0 36CCFBD0 00000000 00000000 00000000 [...6............]
36CCFBF0 000005F0 36CCFC14 77F1C7A6 36CCFD84 [.......6...w...6]
36CCFC00 FFFFFFFF 00000000 00000001 00000000 [................]
36CCFC10 36CCFE8C 77F02ECF 36CCFFB8 00403154 [...6...w...6T1@.]
36CCFC20 00000002 36CCFE78 00000000 00000000 [....x..6........]
36CCFC30 018A908C 168CB930 00000000 00000000 [....0...........]
36CCFC40 00000000 00000000 00000000 00000000 [................]
36CCFC50 00000000 00000000 44414853 00000000 [........SHAD....]
36CCFC60 00000000 00000002 011D7E18 00000000 [.........~......]
36CCFC70 00000634 00000000 00000000 00000000 [4...............]
36CCFC80 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
36CCFCE0 00000002 61100000 00000000 00000000 [.......a........]
36CCFCF0 77B27081 77B20000 00000002 [.p.w...w....]
Argument/Register addr=36ccfe78.
Dump of memory from 0x36CCFE38 to 0x36CCFF78
36CCFE30 FFFFFFFF 36CCFE54 [....T..6]
36CCFE40 77F8882F 00400000 00131DDC 00400000 [/..w..@.......@.]
36CCFE50 77663BC8 36CCFE9C 77F64027 00400000 [.;fw...6'@.w..@.]
36CCFE60 00000001 00000009 36CCFE78 00131DDC [........x..6....]
36CCFE70 7FFDF000 77663BC8 36CCFD78 36CCFD84 [.....;fwx..6...6]
36CCFE80 36CCFE3C 36CCFE6C 36CCFF0C 61726F2A [<..6l..6...6*ora]
36CCFE90 77617073 65725F6E 5F796C70 646E6567 [spawn_reply_gend]
36CCFEA0 36325F62 00002A32 00000002 36CCFF1C [b_262*.........6]
36CCFEB0 00000000 77F6125B 77FA5560 77F61261 [....[..w`U.wa..w]
36CCFEC0 36CCFF30 00000000 018A908C 00000000 [0..6............]
36CCFED0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
36CCFF00 00000000 36CCFEC0 00000000 FFFFFFFF [.......6........]
36CCFF10 77F91FA4 77F9D0E8 FFFFFFFF 00000000 [...w...w........]
36CCFF20 77F76387 77F7638F 36CCFF30 00000001 [.c.w.c.w0..6....]
36CCFF30 00010017 00000000 00000000 00000000 [................]
36CCFF40 00000000 00000000 00000000 80D41648 [............H...]
36CCFF50 00000001 00000000 093F1067 093F1067 [........g.?.g.?.]
36CCFF60 F16C5E64 8012E069 C030036C C00DB000 [d^l.i...l.0.....]
36CCFF70 7FFA9000 80D41580 [........]
----- End of Call Stack Trace -----
===================================================
Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
process: 2e3f7ac, call: 0, xact: 0, curses: 0, usrses: 2e83798
----------------------------------------
SO: 2e3f7ac, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=16, calls cur/top: 0/53cd004, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 85 0 4
last post received-location: kslpsr
last process to post me: 2e3d1cc 1 2
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 2e59eb0
O/S info: user: SYSTEM, term: EKISRVR4, ospid: 262
OSD pid info: 262
----------------------------------------
SO: 2e83798, type: 3, owner: 2e3f7ac, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: 2e3f7ac, flag: (8000041) USR/- -/-/-/-/-/-
DID: 0001-0010-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 46/TEST
O/S info: user: rashmeet, term: unknown, ospid: , machine: ekidv2
program: JDBC Thin Client
last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=90 wait_time=-2
driver id=28414444, break?=1, =0
----------------------------------------
SO: 3be12dc, type: 35, owner: 2e83798, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3be12dc handle=61fd7c0 mode=N
call pin=3808994 session pin=0
user=2e83798 session=2e83798 count=1 flags=[00] savepoint=142
LIBRARY OBJECT HANDLE: handle=61fd7c0
name=SYS.DBMS_STANDARD
hash=50748dda timestamp=11-14-2000 19:57:30
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch=0
lwt=61fd7d8[61fd7d8,61fd7d8] ltm=61fd7e0[61fd7e0,61fd7e0]
pwt=61fd7f0[61fd7f0,61fd7f0] ptm=61fd848[61fd848,61fd848]
ref=61fd7c8[61fd7c8,61fd7c8] lnd=61fd854[5e3d028,5e70278]
LIBRARY OBJECT: object=61fd548
type=PCKG flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 61fd750 61fd62c I/-/A 0 NONE
2 61fd5dc 538c6fc I/-/A 0 NONE
4 5ca9184 5ca900c I/-/A 0 NONE
----------------------------------------
SO: 5cfe0cc, type: 36, owner: 2e83798, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=5cfe0cc handle=0 lock=368fb98
user=2e83798 session=2e83798 count=0 mask=0000 savepoint=140 flags=[00]
----------------------------------------
SO: 368fb98, type: 35, owner: 2e83798, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=368fb98 handle=4b3f7e0 mode=N
call pin=0 session pin=5cfe0cc
user=2e83798 session=2e83798 count=1 flags=[00] savepoint=124
LIBRARY OBJECT HANDLE: handle=4b3f7e0
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=4b3f7f8[4b3f7f8,4b3f7f8] ltm=4b3f800[4b3f800,4b3f800]
pwt=4b3f810[4b3f810,4b3f810] ptm=4b3f868[4b3f868,4b3f868]
ref=4b3f7e8[5200e60,5200e60] lnd=4b3f874[4b3f874,4b3f874]
LIBRARY OBJECT: object=3ca67f4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 55b5370 5d748b8 I/P/A 0 NONE
6 3ca6888 4e7f614 I/-/A 0 NONE
----------------------------------------
SO: 381324c, type: 35, owner: 2e83798, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=381324c handle=5938544 mode=N
call pin=3687ba8 session pin=0
user=2e83798 session=2e83798 count=1 flags=[00] savepoint=124
LIBRARY OBJECT HANDLE: handle=5938544
name=SELECT COUNT(*) FROM GLOBAL_OBJECTS WHERE :b1 = GLOBAL_OBJECTS.OBJECTTYPEID AND :b2 = GLOBAL_OBJECTS.OBJECTID
hash=44201a26 timestamp=07-30-2001 18:00:04
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=593855c[593855c,593855c] ltm=5938564[5938564,5938564]
pwt=5938574[5938574,5938574] ptm=59385cc[59385cc,59385cc]
ref=593854c[593854c,593854c] lnd=59385d8[614e258,614a758]
LIBRARY OBJECT: object=5200cd8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 5200e94 5200e60 4b3f7e0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 4af77e8 5200d5c I/P/A 0 NONE
----------------------------------------
SO: 37aab48, type: 35, owner: 2e83798, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=37aab48 handle=61ccb88 mode=N
call pin=37a6e7c session pin=0
user=2e83798 session=2e83798 count=2 flags=[00] savepoint=110
LIBRARY OBJECT HANDLE: handle=61ccb88
name=TEST.TI_PROPERTIES_TEXT_INDEXED