Re: rollback ignored until end of transaction block

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: rollback ignored until end of transaction block
Дата
Msg-id 4383A843.7050101@opencloud.com
обсуждение исходный текст
Ответ на Re: rollback ignored until end of transaction block  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Kris Jurka wrote:
>
>
> On Wed, 23 Nov 2005, Oliver Jowett wrote:
>
>> I just tried against a server built from HEAD and couldn't reproduce
>> the problem any of the obvious ways.. Think we will need a testcase here.
>>
>
> Another idea that occurred to me that I don't have time to test is that
> processDeadParsedQueries or processDeadPortals doesn't like getting run
> in a stalled transaction.

No errors against CVS HEAD with the CloseStatement/ClosePortal messages
being sent after an error, just before the ROLLBACK:

[...]
  <=BE ReadyForQuery(E)
caught expected exception
closing query: select * from pg_proc
simple execute,
handler=org.postgresql.jdbc2.AbstractJdbc2Connection$TransactionCommandHandler@6443226,
maxRows=0, fetchSize=0, flags=22
  FE=> CloseStatement(S_11)
  FE=> ClosePortal(C_12)
  FE=> Bind(stmt=S_4,portal=null)
  FE=> Execute(portal=null,limit=1)
  FE=> Sync
  <=BE CloseComplete
  <=BE CloseComplete
  <=BE BindComplete [null]
  <=BE CommandStatus(ROLLBACK)
  <=BE ReadyForQuery(I)
rollback was ok

-O

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: rollback ignored until end of transaction block
Следующее
От: smitha
Дата:
Сообщение: Reg : Exception in Postgresql with Java