From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Exception from deadlock |
Date: | 2005-07-07 14:29:47 |
Message-ID: | daje8m$k6s$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-07-07 23:16:17 | Re: Exception from deadlock |
Previous Message | Dave Cramer | 2005-07-07 12:26:29 | Re: get row count from a "cursor resultset" |