Postgres Pro
Downloads
Home   >   mailing lists

Exception from deadlock - Mailing list pgsql-jdbc

From Joseph Shraibman
Subject Exception from deadlock
Date
Msg-id daje8m$k6s$1@news.hub.org
Whole thread Raw
Responses Re: Exception from deadlock  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tree view 
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 by date:

Previous
From: Dave Cramer
Date:
Subject: Re: get row count from a "cursor resultset"
Next
From: Oliver Jowett
Date:
Subject: Re: Exception from deadlock