Home » Server Options » RAC & Failsafe » Single resource deadlock (Oracle9i Enterprise Edition Release 9.2.0.7.0 Linux 2.4.21-32.ELsmp)
Single resource deadlock [message #278590] Mon, 05 November 2007 02:13 Go to next message
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

Re: Single resource deadlock [message #278602 is a reply to message #278590] Mon, 05 November 2007 02:36 Go to previous message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are cases where Oracle dead lock itself.
You have to send your trace file to Oracle support to get a diagnosis.

Regards
Michel
Previous Topic: "Cleanup after failed RDBMS Installation"
Next Topic: Node 1 won't start after CRS installation
Goto Forum:
  


Current Time: Mon Sep 22 01:13:55 CDT 2014

Total time taken to generate the page: 0.08253 seconds