Re: Uncable to commit: transaction marked for rollback

Поиск
Список
Период
Сортировка
От Thomas Markus
Тема Re: Uncable to commit: transaction marked for rollback
Дата
Msg-id 4C2CDDC6.8030600@proventis.net
обсуждение исходный текст
Ответ на Uncable to commit: transaction marked for rollback  (David Kerr <dmk@mr-paradox.net>)
Список 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 по дате отправления:

Предыдущее
От: aaaawwww
Дата:
Сообщение: problems with encoding and accent letters
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: problems with encoding and accent letters