Deadlocks

From: Chuck Hamilton <chuck_hamilton_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:24:18 GMT
Message-ID: <9hsmma$g3p1k$1@ID-85580.news.dfncis.de>

Anyone ever gotten a deadlock detected error where the trace file doesn't show the row locks causing the deadlock? What causes this type of deadlock. I had several this morning and here's the deadlock graph from the trace file.

Deadlock graph:

                       ---------Blocker(s)--------  ---------Waiter(s)------


---

Resource Name          process session holds waits  process session holds
waits
TM-00000afb-00000000        22      24     S             14      43
SX
TM-00000b07-00000000        14      43    SX             22      24
S
session 24: DID 0001-0016-00000002      session 43: DID 0001-000E-00000002
session 43: DID 0001-000E-00000002      session 24: DID 0001-0016-00000002

Rows waited on:
Session 43: no row
Session 24: no row

--

Never share a foxhole with anyone braver than yourself!

Chuck Hamilton
chuck_hamilton_at_hotmail.com Received on Sat Jul 21 2001 - 16:24:18 CDT