Re: ERROR: canceling query due to user request

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: canceling query due to user request
Дата
Msg-id 19720.1094652023@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: canceling query due to user request  (Tore Halset <halset@pvv.ntnu.no>)
Ответы Re: ERROR: canceling query due to user request
Список pgsql-general
Tore Halset <halset@pvv.ntnu.no> writes:
> On Sep 7, 2004, at 20:03, Tom Lane wrote:
>> I suspect that it's got nothing at all to do with the traffic between
>> the server and the client, and that the SIGINT is coming from some
>> outside agency.

> Yes, you are correct.

No, I'm not ;-)

> I added the debug flag and reproduced the
> problem. This was written to the log:

> <2004-09-08 08:55:43 CEST 413eacee.3402>DEBUG:  processing cancel
> request: sending SIGINT to process 13311

This is a smoking gun: your client *is* issuing cancel requests, whether
you know it or not.  (Either that or some other process has magically
acquired the secret cancel key that was issued to your connection.)

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Postgresql and scripting
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql and scripting