Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> FATAL ERROR IN TWO-TASK SERVER: error = 12571
Hi,
Yesterday I faced a problem when I inserting data through VB6
interface.
But It was hanging at the time of inserting data in database.But the
same insert query when I run through SQL* it is working
perfectly.After that I shutdown and restart my database instance.After
that from application end it is working fine.Today I check the
udump.There the .TRC file is telling..I am giving the details below.What can be the problem.It is not a deadlock.Then what type of error.Please explain me.
Redo thread mounted by this instance: 1
Oracle process number: 27
Windows thread id: 2952, image: ORACLE.EXE
AEE480
_opitsk+f50 CALLrel _ksedmp+0
2
_opiino+50c CALLrel _opitsk+0
0
_opiodr+506 CALLreg 00000000
3C 4
BAEFBFC
_opidrv+384 CALLrel _opiodr+0
3C 4
BAEFBFC
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart_at_4+49f CALLrel _opimai+0
2
BAEFE78
77E4A98D CALLreg 00000000----- Argument/Register Address Dump ----- Argument/Register addr=baee480.
BAEE440 00000003 E647C400 6552211C 00000033 [......G..!Re3...] BAEE450 00000000 FFFFFFFD 00000048 00000000 [........H.......] BAEE460 00000000 00000000 0020EB90 00000000 [.......... .....] BAEE470 0000001D 0BAEE48C 0041E204 00000001 [..........A.....] BAEE480 00E191B4 00E191B4 00E191B4 00E191BC [................] BAEE490 00E191B4 00E191B4 00E191B4 00E191B4 [................] BAEE4A0 00E191BC 00000000 00000000 00000000 [................] BAEE4B0 0020EB90 0BAEE568 0041F119 0BAEE4CC [.. .h.....A.....] BAEE4C0 0000001C 0020EB90 00000002 2A2A2A0A [...... ......***] BAEE4D0 30303220 36302D34 2039322D 323A3631 [ 2004-06-29 16:2] BAEE4E0 31343A35 32332D25 2D252073 25207338 [5:41%-32s %-8s %] BAEE4F0 7332332D 0BAE0020 60B16307 00000000 [-32s ....c.`....] BAEE500 0000311B 45414220 38374546 25207300 [.1.. BAEFE78.s %] BAEE510 7332332D 342D2520 0B000A73 0000311B [-32s %-4s....1..] BAEE520 655221B4 00200033 00000000 00000000 [.!Re3. .........] BAEE530 00000000 00000000 00000000 00000000 [................] BAEE540 0BAEFFEC 00000000 0BAEFE78 00000000 [........x.......] BAEE550 00000001 00000001 00000000 0BAEDCC8 [................] BAEE560 00000003 0BAEE58C 00477F2D 0BAEE4A4 [........-.G.....] BAEE570 00000000 0000311B 00211828 00000000 [.....1..(.!.....]Argument/Register addr=baefbfc.
BAEFBB0 00000020 [ ...] BAEFBC0 77F42AC3 77E5AAA3 0BB24B00 60840538 [.*.w...w.K..8..`] BAEFBD0 00000000 00000000 00000000 0BAEFBEC [................] BAEFBE0 00000000 00000000 00000000 00000000 [................] BAEFBF0 7FF9FC00 0BAEFC14 77E5AB09 0BAEFD85 [...........w....] BAEFC00 FFFFFFFF 00000000 00000001 00000000 [................] BAEFC10 77F4331F 77F42397 0BAEFFB8 00403154 [.3.w.#.w....T1@.] BAEFC20 00000002 0BAEFE78 00000000 00000000 [....x...........] BAEFC30 00E5908C 002145C0 77FC2340 77F5D0E7 [.....E!.@#.w...w] BAEFC40 00000000 7FFDF000 00000000 00000024 [............$...] BAEFC50 00000001 00000000 44414853 00000000 [........SHAD....] BAEFC60 FFFF0000 00000002 011D88C0 00000000 [................] BAEFC70 00000580 00000001 00000000 00000000 [................] BAEFC80 00000070 FFFFFFFF FFFFFFFF 77F5D045 [p...........E..w] BAEFC90 77F5D10F 00247578 71B21570 7FFDF000 [...wxu$.p..q....] BAEFCA0 77FC23B4 0BAEFC40 00000000 0BAEFD0C [.#.w@...........] BAEFCB0 77F45A34 77F8C7B0 FFFFFFFF 77F5D0E7 [4Z.w...w.......w] BAEFCC0 77F4363F 77F5CEE5 0BAEFD30 00000000 [?6.w...w0.......] BAEFCD0 00E5908C 00000000 00000000 00000000 [................] BAEFCE0 00000000 00000000 00000000 00000000 [................] BAEFCF0 00000000 00000000 7FFDF000 [............]Argument/Register addr=baefe78.
BAEFE30 00000000 00000000 [........] BAEFE40 00000000 00000000 00000000 00000000 [................] Repeat 2 times BAEFE70 00000000 00000000 0BAEFD78 0BAEFD85 [........x.......] BAEFE80 00000000 00000000 00000000 61726F2A [............*ora] BAEFE90 77617073 65725F6E 5F796C70 6C696568 [spawn_reply_heil]BAEFEA0 325F6264 2A323539 00000000 00000000 [db_2952*........]
BAEFEB0 00000000 00000000 00000000 00000000 [................] Repeat 9 times BAEFF50 804E3B5C 00000000 FF247700 F6614BFC [\;N......w$..Ka.] BAEFF60 804E3B9A FF2478E0 F6614C30 804E3CB0 [.;N..x$.0La..<N.] BAEFF70 FF247750 FF247750 [Pw$.Pw$.]----- End of Call Stack Trace -----
process: 28a1a64, call: 0, xact: 2af6ee8, curses: 0, usrses: 28c9aec
int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 0 0 18
last post received-location: ksqrcl last process to post me: 28a1414 30 0 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
DID: 0001-001B-00000002, short-term DID: 0000-0000-00000000
txn branch: 0 oct: 0, prv: 0, user: 36/SCOTTO/S info: user: SHANTA\Administrator, term: SYSTEL1, ospid: 3176:3584, machine: SHANTA\SYSTEL1
program: vb6.exe
last wait for 'SQL*Net break/reset to client' blocking sess=0x0
seq=306 wait_time=-2
driver id=54435000, break?=1, =0 ---------------------------------------- SO: 2af6ee8, type: 25, owner: 28c9aec, pt: 0, flag: INIT/-/-/0x00 (trans) bsn = 360, flg = 0x1e03, flg2 = 0x00, prx = 0x0, ros = 2147483647, spn = 367 efd = 5 parent xid: 0x0000.000.00000000 env: (scn: 0x0000.000c12b1 xid: 0x0003.025.00000036 uba: 0x008005e0.0013.34) cev: (spc = 1962 usi = 3 ubk tsn: 1 rdba: 0x008005e0 useg tsn: 1 rdba: 0x00800402 hwm uba: 0x008005e0.0013.34 col uba: 0x00000000.0000.00 num bl: 1 bk list: 0x2ae32a4) (enqueue) TX-00030025-00000036 DID: 0001-001B-00000002 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res: 2979d00, mode: X, prv: 2979d08, sess: 28c9aec, proc: 28a1a64 xga: 0x0, heap: UGA ---------------------------------------- SO: 2ae32a4, type: 24, owner: 2af6ee8, pt: 0, flag: -/-/-/0x00 (List of Blocks) next index = 2 index savepoint itli buffer hint -------------------------------------- 0 363 1 0x 2a01054 1 366 2 0x 2a012fc ---------------------------------------- SO: 2acd28c, type: 22, owner: 2af6ee8, pt: 0, flag: INIT/-/-/0x00 DML LOCK: tab=25979 flg=01 chi=0 his[0]: mod=3 spn=360 (enqueue) TM-0000657B-00000000 DID: 0001-001B-00000002 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res: 2979cb8, mode: SX, prv: 2979cc0, sess: 28c9aec, proc: 28a1a64 ---------------------------------------- SO: 2bafc60, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=2bafc60 handle=0 lock=2baef28 user=28c9aec session=28c9aec count=0 mask=0000 savepoint=358 flags=[00] ---------------------------------------- SO: 2baef28, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2baef28 handle=5627dc0 mode=N call pin=0 session pin=2bafc60 user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357 LIBRARY OBJECT HANDLE: handle=5627dc0 namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0 lwt=5627dd8[5627dd8,5627dd8] ltm=5627de0[5627de0,5627de0] pwt=5627df0[5627df0,5627df0] ptm=5627e48[5627e48,5627e48] ref=5627dc8[5628210,5628210] lnd=5627e54[5627e54,5627e54] LIBRARY OBJECT: object=5627b84 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 DEPENDENCIES: count=2 size=16 ACCESSES: count=1 size=16 TRANSLATIONS: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 5627d50 56273b8 I/P/A 0 NONE 6 5627c18 5626398 I/-/A 0 NONE ---------------------------------------- SO: 2baeaf0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2baeaf0 handle=5627e7c mode=N call pin=2bafca8 session pin=0 user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357 LIBRARY OBJECT HANDLE: handle=5627e7c name= Insert into transaction2(Voucherkey,VoucherNo,DateField,Narration ) values(2,'',to_date('06/29/2004','MM-DD-YYYY'),'Cash Transferred ') hash=30bdef64 timestamp=06-29-2004 16:24:35 namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0 lwt=5627e94[5627e94,5627e94] ltm=5627e9c[5627e9c,5627e9c] pwt=5627eac[5627eac,5627eac] ptm=5627f04[5627f04,5627f04] ref=5627e84[5627e84,5627e84] lnd=5627f10[5627f10,5627f10] LIBRARY OBJECT: object=5628088 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 5628244 5628210 5627dc0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 5628290 562810c I/P/A 0 NONE ---------------------------------------- SO: 2bb02d8, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=2bb02d8 handle=0 lock=2baedc0 user=28c9aec session=28c9aec count=0 mask=0000 savepoint=351 flags=[00] ---------------------------------------- SO: 2baedc0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2baedc0 handle=5748c5c mode=N call pin=0 session pin=2bb02d8 user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351 LIBRARY OBJECT HANDLE: handle=5748c5c namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0 lwt=5748c74[5748c74,5748c74] ltm=5748c7c[5748c7c,5748c7c] pwt=5748c8c[5748c8c,5748c8c] ptm=5748ce4[5748ce4,5748ce4] ref=5748c64[5740a4c,5740a4c] lnd=5748cf0[5748cf0,5748cf0] LIBRARY OBJECT: object=5748a44 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 574083c 5748804 I/P/A 0 NONE 6 5748ad8 573e980 I/-/A 0 NONE ---------------------------------------- SO: 2bae8d4, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2bae8d4 handle=5748d18 mode=N call pin=2baf510 session pin=0 user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351 LIBRARY OBJECT HANDLE: handle=5748d18 name=Select max(VoucherKey) from transaction2 hash=5fb7057d timestamp=06-29-2004 15:00:31 namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0 lwt=5748d30[5748d30,5748d30] ltm=5748d38[5748d38,5748d38] pwt=5748d48[5748d48,5748d48] ptm=5748da0[5748da0,5748da0] ref=5748d20[5748d20,5748d20] lnd=5748dac[5748dac,5748dac] LIBRARY OBJECT: object=57408c4 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 5740a80 5740a4c 5748c5c DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 5740acc 5740948 I/P/A 0 NONE ---------------------------------------- SO: 2bb3e4c, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=2bb3e4c handle=575c244 mode=S lock=2baedfc user=28c9aec session=28c9aec count=1 mask=0041 savepoint=343 flags=[00] ---------------------------------------- SO: 2baedfc, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2baedfc handle=575c244 mode=N call pin=0 session pin=2bb3e4c user=28c9aec session=28c9aec count=1 flags=PNS/[08] savepoint=343 LIBRARY OBJECT HANDLE: handle=575c244 namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0 lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264] pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc] ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8] LIBRARY OBJECT: object=575c02c 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 575d6c0 575bdec I/P/A 0 NONE 6 575c0c0 575b968 I/P/A 1 NONE ---------------------------------------- SO: 2baf900, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=2baf900 handle=0 lock=2baea78 user=28c9aec session=28c9aec count=0 mask=0000 savepoint=193 flags=[00] ---------------------------------------- SO: 2baea78, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2baea78 handle=575c244 mode=N call pin=0 session pin=2baf900 user=28c9aec session=28c9aec count=1 flags=[00] savepoint=193 LIBRARY OBJECT HANDLE: handle=575c244 namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0 lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264] pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc] ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8] LIBRARY OBJECT: object=575c02c 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 575d6c0 575bdec I/P/A 0 NONE 6 575c0c0 575b968 I/P/A 1 NONE ---------------------------------------- SO: 2bb53e8, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2bb53e8 handle=575f5fc mode=N call pin=2bb3dbc session pin=0 user=28c9aec session=28c9aec count=2 flags=[00] savepoint=193 LIBRARY OBJECT HANDLE: handle=575f5fc name=select AccountMaster.*, AccountMaster."ROWID" from AccountMaster order by accountcode hash=94670588 timestamp=06-29-2004 11:05:39 namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0 lwt=575f614[575f614,575f614] ltm=575f61c[575f61c,575f61c] pwt=575f62c[575f62c,575f62c] ptm=575f684[575f684,575f684] ref=575f604[575f604,575f604] lnd=575f690[575f690,575f690] LIBRARY OBJECT: object=575f44c type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 575c4d4 575c308 575c244 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 575d720 575f4d0 I/P/A 0 NONE ---------------------------------------- SO: 2bb4fb0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2bb4fb0 handle=59ee220 mode=N call pin=2bb3984 session pin=0 user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76 LIBRARY OBJECT HANDLE: handle=59ee220 name=SYS.DATABASE hash=aea96fa0 timestamp=12-31-4712 23:59:59 namespace=EVNT flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0 lwt=59ee238[59ee238,59ee238] ltm=59ee240[59ee240,59ee240] pwt=59ee250[59ee250,59ee250] ptm=59ee2a8[59ee2a8,59ee2a8] ref=59ee228[59ee228,59ee228] lnd=59ee2b4[59ee2b4,59ee2b4] LIBRARY OBJECT: object=59ee008 type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 59e8d04 59ee0ec I/-/A 0 NONE 3 59ee09c 59ede9c I/-/A 0 NONE ---------------------------------------- SO: 2bb4f38, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2bb4f38 handle=57b6284 mode=N call pin=2bb3aec session pin=0 user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76 LIBRARY OBJECT HANDLE: handle=57b6284 name=SCOTT.SCOTT hash=7727a61d timestamp=12-31-4712 23:59:59 namespace=EVNT flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0 lwt=57b629c[57b629c,57b629c] ltm=57b62a4[57b62a4,57b62a4] pwt=57b62b4[57b62b4,57b62b4] ptm=57b630c[57b630c,57b630c] ref=57b628c[57b628c,57b628c] lnd=57b6318[57b6318,57b6318] LIBRARY OBJECT: object=57b600c type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 57b6214 57b60f0 I/-/A 0 NONE 3 57b60a0 57b5f1c I/-/A 0 NONE ---------------------------------------- SO: 57437c4, type: 34, owner: 28c9aec, pt: 0, flag: INIT/-/-/0x00 user lock: lock=57437c4 mode=S user resource: user=2bc2dd4 uid=36 mode=S ---------------------------------------- SO: 562ca14, type: 34, owner: 28c9aec, pt: 0, flag: INIT/-/-/0x00 user lock: lock=562ca14 mode=S user resource: user=2bc2dd4 uid=36 mode=S ----------------------------------------SO: 29a2a24, type: 9, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00 (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 28a1a64,
event: 69, last message event: 69, messages read: 0 channel: (29a3c2c) system events broadcast channel scope: 101, event: 69, last mesage event: 0, publishers/subscribers: 0/26, messages published: 0 ----------------------------------------SO: 29170f8, type: 2, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00 (call) sess: cur 28c9aec, rec 0, usr 28c9aec; depth: 0 END OF PROCESS STATE