Re: rollback ignored until end of transaction block - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: rollback ignored until end of transaction block
Date
Msg-id 43848B1B020000250000090B@gwmta.wicourts.gov
Whole thread Raw
In response to rollback ignored until end of transaction block  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: rollback ignored until end of transaction block  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
I haven't seen any of these today.  Ran part of the day with loglevel=2
and part without.  I'll keep trying.

We have fixed a couple underlying exceptions which might have set
up the conditions for this.  Is it worth intentionally regressing those
in
my application code to try to track this down if it doesn't otherwise
manifest?  It is disconcerting to be told that a rollback won't be
accepted until the end of the transaction block.   :-(

-Kevin


>>> Oliver Jowett <oliver@opencloud.com>  >>>
Kevin Grittner wrote:
> Is there any context where this would make sense?:
>
> org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
>     at
>
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
>     at
>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
>     at
>
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>     at
>
org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:617)
>     at
>
org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:654)

Huh, that *is* weird. rollback() should do nothing but execute ROLLBACK,

which shouldn't trigger that error.. How did you get it into that state?

Can you run with loglevel=2 and see what the trace says? What driver
version?

-O


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [BUGS] BUG #2060: Issue with Data base connection
Next
From: Kris Jurka
Date:
Subject: Re: Again the JSCreator and Metadata issues