How do I interpret the data returned from a DeadLock-Exception?(Java)

From: Øyvind Møller Asbjørnsen <oyvindma(at)tihlde(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: How do I interpret the data returned from a DeadLock-Exception?(Java)
Date: 2006-02-03 12:09:03
Message-ID: 43E347DF.8060409@tihlde.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi folks.

I'm strugeling with a deadlock here, and was hoping that you could help
me out.

Software in use:
I'm using PostgreSQL 8.1.2 together with hibernate 3.1 and Java 1.5 in
windows XP.

The situation:
My java-application is producing dead locks quite frequently, and I
would like to resolve them. How do I interpret the data in the error
message? Are there any ways of finding out e.g what process 3224 is and
what it is doing? Which relation is nr 16409? what is tuple(0,25) and so
on. Any nice tools one could use?

-------ERROR MESSAGE-----------------------
2006-02-03 12:39:41,903 ERROR Thread-12
org.hibernate.util.JDBCExceptionReporter - ERROR: deadlock detected
Detail: Process 3224 waits for ExclusiveLock on tuple (0,25) of relation
30425 of database 16409; blocked by process 2632.
Process 2632 waits for ShareLock on transaction 96197; blocked by
process 2488.
Process 2488 waits for ExclusiveLock on tuple (0,25) of relation 30425
of database 16409; blocked by process 3224.
---------------------------------------------------

I'm looking forward to hearing from you.

Best Regards
Øyvind

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-02-03 12:24:57 Re: Create table and update it within one function ?
Previous Message Arnaud Lesauvage 2006-02-03 11:58:19 Create table and update it within one function ?