Deadlock Detected Involving INDEX (Revisions dRevClassID_2 ..) (Doc ID 1340645.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

Symptoms

 
- Ora-60 deadlock detected - errors are frequently reported to the log files :


DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]

Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00070018-0000f452 295 145 X 314 528 X
TX-00090001-000b7ca0 314 528 X 295 145 X

session 145: DID 0001-0127-00000002 session 528: DID 0001-013A-00000002
session 528: DID 0001-013A-00000002 session 145: DID 0001-0127-00000002

Rows waited on:
Session 145: obj - rowid = 00015D13 - AAAV0TAAJAAAAV5AAT
(dictionary objn - 89363, file - 9, block - 1401, slot - 19)
Session 528: obj - rowid = 00015D13 - AAAV0TAAJAAAAUBAAb
(dictionary objn - 89363, file - 9, block - 1281, slot - 27)

----- Information for the OTHER waiting sessions -----
Session 528:
sid: 528 ser: 17 audsid: 4063809 user: 84/.._CONTRIB
flags: (0x8000045) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40008) -/-
pid: 314 O/S info: user: ..., term: UNKNOWN, ospid: 611
image: ...
client details:
O/S info: user: ucm, term: unknown, ospid: 1234
machine: bi04uxp3 program: JDBC Thin Client
application name: JDBC Thin Client, hash value=2546894660
current SQL:
UPDATE/*+ INDEX (Revisions dRevClassID_2)*/ Revisions SET dRevRank=dRevRank+:"SYS_B_0" WHERE dRevClassID=:"SYS_B_1" and dID<:"SYS_B_2"

----- End of information for the OTHER waiting sessions -----

Information for THIS session:

----- Current SQL Statement for this session (sql_id=9wy03tft31c2w) -----
UPDATE/*+ INDEX (Revisions dRevClassID_2)*/ Revisions SET dIndexerState = :"SYS_B_0"
WHERE dRevClassID = :"SYS_B_1"
AND (dIndexerState in (:"SYS_B_2", :"SYS_B_3") OR dIndexerState is null)
AND (dID <= :"SYS_B_4" OR dStatus = :"SYS_B_5" OR dReleaseState in (:"SYS_B_6", :"SYS_B_7", :"SYS_B_8", :"SYS_B_9"))

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms