Re: Query was cancelled - reason?

Поиск
Список
Период
Сортировка
От Guido Fiala
Тема Re: Query was cancelled - reason?
Дата
Msg-id 200407020911.13470.guido.fiala@dka-gmbh.de
обсуждение исходный текст
Ответ на Re: Query was cancelled - reason?  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Am Donnerstag, 1. Juli 2004 13:20 schrieb Oliver Jowett:
> Guido Fiala wrote:
> > Hello,
> >
> > i'am currently run into a strange problem with fast subsequent updates in
> > the same table.
> >
> > The application is quite complex, so its difficult to to sent a code
> > snippet, i included the network traffic instead:
> >
> > This is whats happening:
>
> [... COMMIT gets cancelled ...]
>
> > So why comes the commit-error?
>
> Three possibilities I can think of:
>
> - Something is sending SIGINT to the backend process.
> - You are calling JDBC's Statement.cancel() method (see below) which

Thank you so much - you are right ! This it was. I didn't destroy my thread
that was intentend to cancel the query, so it run on and triggered...
...
AFAIK the Statement.setqueryTimeOut() is currently not implemented/used
or has this already changed in recent driver snapshots?

> ends up sending a SIGINT (indirectly via a backend process).

Why can't i see the SIGINT in network traffic?

Guido

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

Предыдущее
От: "John Pagakis"
Дата:
Сообщение: Re: Issue with now() within a transaction in pg74.213.jdbc.jar
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Issue with now() within a transaction in pg74.213.jdbc.jar