Re: ERROR: canceling query due to user request - Mailing list 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