Re: ERROR: canceling query due to user request

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: canceling query due to user request
Дата
Msg-id 2445.1094580196@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  (Tore Halset <halset@pvv.ntnu.no>)
Список pgsql-general
Tore Halset <halset@pvv.ntnu.no> writes:
> I need to debug all of the trafic between the server and the client to
> track down this problem.

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.  However, if you want to be sure about it, set the
postmaster's log_min_messages to DEBUG2, and then the next time the
problem happens, look in the postmaster log to see if you see anything
about
    processing cancel request: sending SIGINT to process %d

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Table UPDATE is too slow
Следующее
От: David Garamond
Дата:
Сообщение: Re: Salt in encrypted password in pg_shadow