Re: Query cancelled errors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query cancelled errors
Дата
Msg-id 25832.1063737954@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query cancelled errors  (David Rickard <David.Rickard@GTScompanies.com>)
Ответы Re: Query cancelled errors  (David Rickard <David.Rickard@GTScompanies.com>)
Список pgsql-novice
David Rickard <David.Rickard@GTScompanies.com> writes:
> We have encountered numerous instances when we have encountered the
> following error message:
>          ERROR:  Query was cancelled.

Something is sending the backend a SIGINT.  What platform are you on?
(For that matter, what PG version are you using?)

You might look to see if your platform sends SIGINT when it thinks
a process has exhausted resource limits, or some such.  Most Unixen
I'm familiar with use different signals for that, but it's hard to
think of other obvious reasons for unsolicited signals.

Also, how did you start the postmaster?  If you launched it by hand
and weren't careful to dissociate it from the shell session, then
control-C typed at that shell could SIGINT the postmaster and backends.

            regards, tom lane

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

Предыдущее
От: David Rickard
Дата:
Сообщение: Query cancelled errors
Следующее
От: David Rickard
Дата:
Сообщение: Re: Query cancelled errors