Re: ERROR: canceling query due to user request

From: Tore Halset <halset(at)pvv(dot)ntnu(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: canceling query due to user request
Date: 2004-09-08 07:07:03
Message-ID: AF83CF68-0165-11D9-A26A-000A95CD827E@pvv.ntnu.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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?

Regards,
- Tore.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-09-08 07:25:42 Re: Starting and stopping database by JAVA
Previous Message juleni 2004-09-08 06:36:24 Starting and stopping database by JAVA

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-09-08 08:51:22 Re: please help - schema in jdbc connection string
Previous Message Nanu Ram 2004-09-08 00:50:22 please help - schema in jdbc connection string