| 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: | Whole Thread | Raw Message | 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" |