Hi,
Recently, there was a deadlock in my Oracle database
(8.1.7.4 on Ms Windows NT 4.0) but I can't figure out
what caused the deadlock. The deadlock occurs for nearly
12 hrs and miraculously disappear. Since then the database
has been running fine without problem for the past 48 hrs.
I have attached part of the trace file. Any help is appericated.
- SESSION ID:(41.12030) 2006-05-21 21:33:07.770
DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE AGENTBALANCE SET BALANCE=BALANCE - :b1 WHERE UPPER(AGENTID) =
UPPER(:b2) AND CURRENCYID = :b3
----- PL/SQL Call Stack -----
object line object
handle number name
13000a1c 179 procedure GVUSER.UP_CALLREC3
117101d4 1 anonymous block
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)------
---
Resource Name process session holds waits process session holds
waits
TX-0004005e-00014edf 8 47 X 21 41
X
session 47: DID 0001-001A-00000002 session 41: DID 0001-001A-00000002
Rows waited on:
Session 41: obj - rowid = 00003393 - AAADOTAAKAAABJtAAQ
PROCESS STATE
Process global information:
process: 1008fa3c, call: 100ead78, xact: 102fee64, curses: 100badcc,
usrses: 100badcc
SO: 1008fa3c, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=21, calls cur/top: 100ead78/100eacd8, flag: (20) MS
SERVER
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 112
last post received-location: kmcmbf: attached server
last process to post me: 1008d784 1 64
last post sent: 269863992 13 118
last post sent-location: kmcpdp
last process posted by me: 1008d784 1 64
(latch info) wait_event=0 bits=10
holding 13d9440 Parent+children enqueue hash chains level=4
Location from where latch is held: ksqcmi: kslgpl:
Context saved from call: 0
state=busy
recovery area:
Dump of memory from 0x1008B620 to 0x1008B628
1008B620 00000000 00000000 [........]
Process Group: DEFAULT, pseudo proc: 100a2300
O/S info: user: SYSTEM, term: GVDATA1, ospid: 179
OSD pid info: 179
Received on Tue May 23 2006 - 18:21:23 CDT