| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tore Halset <halset(at)pvv(dot)ntnu(dot)no> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: canceling query due to user request |
| Date: | 2004-09-08 14:00:23 |
| Message-ID: | 19720.1094652023@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Tore Halset <halset(at)pvv(dot)ntnu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-08 14:05:25 | Re: Postgresql and scripting |
| Previous Message | Greg Stark | 2004-09-08 13:48:56 | Re: Postgresql and scripting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-08 14:02:45 | Re: please help - schema in jdbc connection string |
| Previous Message | Ashok...... | 2004-09-08 13:34:50 | HI! Need Help |