Thread: Uncable to commit: transaction marked for rollback
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
David Kerr <dmk@mr-paradox.net> writes:
> 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
You might have better luck asking about that on pgsql-jdbc --- there's
no such error condition in Postgres proper, so it must be coming from
somewhere on the Java side.
regards, tom lane
On 7/1/2010 11:10 AM, Tom Lane wrote: > David Kerr<dmk@mr-paradox.net> writes: >> 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 > > You might have better luck asking about that on pgsql-jdbc --- there's > no such error condition in Postgres proper, so it must be coming from > somewhere on the Java side. > > regards, tom lane > Ok - thanks! Dave
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
>
>
On 2010-07-01, David Kerr wrote: > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To > make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Hallo, as Tom Lane already pointed out, the issue is definitely on the Java side if you cannot find any PSQLException related to it. The exception is generated by the Java Transaction Api. May be an EJB failed could was not available during the transaction or threw an exception. -- Robert...