Re: Uncable to commit: transaction marked for rollback - Mailing list pgsql-general

From Thomas Markus
Subject Re: Uncable to commit: transaction marked for rollback
Date
Msg-id 4C2CDDC6.8030600@proventis.net
Whole thread Raw
In response to Uncable to commit: transaction marked for rollback  (David Kerr <dmk@mr-paradox.net>)
List pgsql-general
Hi,

it happens fi at transaction timeout or you executed a broken/failed
statement und catched the exception

try {  call invalid sql  } catch (Exception e) {}
connection.commit() <- exception throws here, happens automatically
inside your appserver


regards
Thomas

Am 01.07.2010 20:06, schrieb David Kerr:
> I'm intermittantly getting this error message in a java app.
> using Geronimo / Hibernate / Postgres 8.3.9
>
> javax.transaction.RollbackException: Unable to commit: transaction marked for
> rollback
>
> Can someone give me a scenario where this would happen? "unable to commit"
> makes everyone immediatly go to database issue. But it seems like an app
> issue to me.
>
> I was thinking that maybe it's a 2 phase commit / XA or something like that.
> (TX open, phase 1 commit fails, phase 2 commit throws this error?)
>
> I can't imagine how this would happen within a single transaction setup.
>
> Thanks!
>
> Dave
>
>


pgsql-general by date:

Previous
From: aaaawwww
Date:
Subject: problems with encoding and accent letters
Next
From: Peter Geoghegan
Date:
Subject: Re: problems with encoding and accent letters