Single resource deadlock [message #278590] |
Mon, 05 November 2007 02:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68648 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
|
|
|