| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>, Tore Halset <halset(at)pvv(dot)ntnu(dot)no>, pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: [JDBC] ERROR: canceling query due to user request |
| Date: | 2004-09-09 21:04:06 |
| Message-ID: | 4140C546.7020801@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Tom Lane wrote:
> Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> writes:
>
>>On 09/09/2004 10:41 Oliver Jowett wrote:
>>
>>>JDBC gives you no way to ensure you only call cancel() on a running query
>>>(there's a race between query execution returning and the call to
>>>cancel()). Calling cancel() on a statement that's not currently executing
>>>should do nothing; if it ends up cancelling a future query, it's a driver
>>>bug.
>
>
>>Thanks for the explaination Oliver. Maybe there is a driver bug then?
>
>
> IIRC there was such a bug at one time, but I thought it had been fixed.
> Maybe the problem is use of an old driver?
My patch for this never got applied, AFAIK. The current driver still
seems to send the cancellation request and continue without waiting for
an EOF from the server.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2004-09-09 21:12:33 | Re: function calls in WHERE clause |
| Previous Message | peter Willis | 2004-09-09 20:47:15 | Re: Where does postgres store records of DROP-ed columns? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tore Halset | 2004-09-10 06:44:32 | Re: [GENERAL] ERROR: canceling query due to user request |
| Previous Message | Tom Lane | 2004-09-09 16:02:14 | Re: [JDBC] ERROR: canceling query due to user request |