Re: Query was cancelled - reason? - Mailing list pgsql-jdbc

From Guido Fiala
Subject Re: Query was cancelled - reason?
Date
Msg-id 200407020911.13470.guido.fiala@dka-gmbh.de
Whole thread Raw
In response to Re: Query was cancelled - reason?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Am Donnerstag, 1. Juli 2004 13:20 schrieb Oliver Jowett:
> Guido Fiala wrote:
> > Hello,
> >
> > i'am currently run into a strange problem with fast subsequent updates in
> > the same table.
> >
> > The application is quite complex, so its difficult to to sent a code
> > snippet, i included the network traffic instead:
> >
> > This is whats happening:
>
> [... COMMIT gets cancelled ...]
>
> > So why comes the commit-error?
>
> Three possibilities I can think of:
>
> - Something is sending SIGINT to the backend process.
> - You are calling JDBC's Statement.cancel() method (see below) which

Thank you so much - you are right ! This it was. I didn't destroy my thread
that was intentend to cancel the query, so it run on and triggered...
...
AFAIK the Statement.setqueryTimeOut() is currently not implemented/used
or has this already changed in recent driver snapshots?

> ends up sending a SIGINT (indirectly via a backend process).

Why can't i see the SIGINT in network traffic?

Guido

pgsql-jdbc by date:

Previous
From: "John Pagakis"
Date:
Subject: Re: Issue with now() within a transaction in pg74.213.jdbc.jar
Next
From: Kris Jurka
Date:
Subject: Re: Issue with now() within a transaction in pg74.213.jdbc.jar