From: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
---|---|
To: | David Kerr <dmk(at)mr-paradox(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Uncable to commit: transaction marked for rollback |
Date: | 2010-07-01 18:26:14 |
Message-ID: | 4C2CDDC6.8030600@proventis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Phil Jackson | 2010-07-01 19:11:09 | Re: Cannot open table in new database |
Previous Message | Phil Jackson | 2010-07-01 18:11:29 | Re: Cannot open table in new database |