How do I interpret the data returned from a DeadLock-Exception?(Java)
От | Øyvind Møller Asbjørnsen |
---|---|
Тема | How do I interpret the data returned from a DeadLock-Exception?(Java) |
Дата | |
Msg-id | 43E347DF.8060409@tihlde.org обсуждение исходный текст |
Ответы |
Re: How do I interpret the data returned from a DeadLock-Exception?(Java)
|
Список | 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
В списке pgsql-novice по дате отправления: