HW deadlock?

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 04 Aug 2003 23:24:49 +0100 (BST)
Message-ID: <1Jp*mD7Yp@news.chiark.greenend.org.uk>

Hi,

I've had a somewhat confusing deadlock, before I raise an ITAR, could somebody confirm (or deny) my interpretation. To me this looks like two sessions deadlocking while extending the high water mark. The two tables are in the same tablespace. Is this a bug in Oracle? We're running version 9.2.0.3 on HP-UX 11.11. I've had a look on metalink, but can't see anything relevant.

DEADLOCK DETECTED
Current SQL statement for this session:
INSERT INTO CUSTPRODUCTTARIFFDETAILS [...] Deadlock graph:

                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
HW-00000001-00800021        13      31           X       15      12           S
HW-00000001-00800021        15      12     S             13      31           X
session 31: DID 0001-000D-00000002      session 12: DID 0001-000F-00000002
session 12: DID 0001-000F-00000002      session 31: DID 0001-000D-00000002

Rows waited on:
Session 12: no row
Session 31: no row
Information on the OTHER waiting sessions: Session 12:
  pid=15 serial=11836 audsid=247 user: 21/ADMIN   O/S info: user: oracle, term: , ospid: 19494, machine: cvg130

            program: CDG_at_cvg130 (TNS V1-V3)   application name: CDG_at_cvg130 (TNS V1-V3), hash value=0   Current SQL Statement:

INSERT INTO CUSTHASPRODUCT [...]

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Mon Aug 04 2003 - 17:24:49 CDT