Re: ERROR: canceling query due to user request

On Sep 8, 2004, at 9:07, Tore Halset wrote:

> 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.  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
>
> Yes, you are correct. 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
> <2004-09-08 08:55:43 CEST >DEBUG:  server process (PID 13314) exited
> with exit code 0
> <2004-09-08 08:55:43 CEST 413eace4.33ff>ERROR:  canceling query due to
> user request
> <2004-09-08 08:55:43 CEST >DEBUG:  forked new backend, pid=13315
> socket=60
> <2004-09-08 08:55:43 CEST 413eacef.3403>DEBUG:  processing cancel
> request: sending SIGINT to process 13311
>
> Are the OS sending the SIGINT to PostgreSQL or are postmaster sending
> it to one of its child?

I installed beta2 on a local linux box instead and now everything is
working :/ Something must trigger Mac OS X to send those evil SIGINTs.

Regards,
  - Tore.