Re: Query cancelled errors - Mailing list pgsql-novice

From Tom Lane
Subject Re: Query cancelled errors
Date
Msg-id 25832.1063737954@sss.pgh.pa.us
Whole thread Raw
In response to Query cancelled errors  (David Rickard <David.Rickard@GTScompanies.com>)
Responses Re: Query cancelled errors
List 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 by date:

Previous
From: David Rickard
Date:
Subject: Query cancelled errors
Next
From: David Rickard
Date:
Subject: Re: Query cancelled errors