OraFAQ Forum: RAC & Failsafe » Single resource deadlock

Home » Server Options » RAC & Failsafe » Single resource deadlock (Oracle9i Enterprise Edition Release 9.2.0.7.0 Linux 2.4.21-32.ELsmp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Single resource deadlock [message #278590]

Mon, 05 November 2007 02:13

vinu_raj
Messages: 26
Registered: April 2005
Location: Bangalore INDIA

Junior Member

We are using RAC and getting deadlock every now and then and the trace file is not showing any SQLs. Even for SELECT (simple SELECT no SELECT FOR UPDATE) we are sometimes getting deadlock. Below is one sample trace file which
is telling "Single resource deadlock: blocking enqueue which blocks itself". Can somebody aware of the reason for this.

-----------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /vendor/oracle/product/9.2.0
System name: Linux
Node name: db-01
Release: 2.4.21-32.ELsmp
Version: #1 SMP Fri Apr 15 21:17:59 EDT 2005
Machine: i686
Instance name: db1
Redo thread mounted by this instance: 1
Oracle process number: 58
Unix process pid: 734, image: oracle@db-01 (TNS V1-V3)

*** 2007-10-31 14:33:29.107
*** SESSION ID:(46.48548) 2007-10-31 14:33:29.107
Single resource deadlock: blocking enqueue which blocks itself, f 0
----------enqueue------------------------
lock version : 4379
Owner node : 0
grant_level : KJUSERCW
req_level : KJUSERPW
bast_level : KJUSERNL
notify_func : (nil)
resp : 0x8adc83d0
procp : 0x8acc58f8
pid : 1301
proc version : 6819
oprocp : (nil)
opid : 0
gid : 0
xid : 3866625 3234
dd_time : 61.0 secs
dd_count : 0
timeout : 0.0 secs
On_timer_q? : N
On_dd_q? : Y
lock_state : CONVERTING
Open Options : KJUSERDEADLOCK

Report message to a moderator