Re: ERROR: canceling query due to user request - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: canceling query due to user request
Date
Msg-id 2445.1094580196@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: canceling query due to user request  (Tore Halset <halset@pvv.ntnu.no>)
Responses Re: ERROR: canceling query due to user request  (Tore Halset <halset@pvv.ntnu.no>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] Table UPDATE is too slow
Next
From: David Garamond
Date:
Subject: Re: Salt in encrypted password in pg_shadow