Exception from deadlock

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Exception from deadlock
Дата
Msg-id daje8m$k6s$1@news.hub.org
обсуждение исходный текст
Ответы Re: Exception from deadlock  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
org.postgresql.util.PSQLException: ERROR: deadlock detected

    at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
    at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
    at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
    at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
    at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259)

When I get a deadlock on psql, I get:

ERROR:  deadlock detected
DETAIL:  Process 12189 waits for ShareLock on transaction 3657282;
blocked by process 12109.
Process 12109 waits for ShareLock on transaction 3657280; blocked by
process 12189.


So my quesion is where did that detail information go in the jdbc driver?

I'm using postgres 7.4.7 with the jdbc driver that comes with it.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: get row count from a "cursor resultset"
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Exception from deadlock