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

From Tom Lane
Subject Re: ERROR: canceling query due to user request
Date
Msg-id 24756.1126629063@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: canceling query due to user request  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> One more thought -- I keep coming back to the fact that when we turn
> on logging in the JDBC driver on the client side, the problem does not
> occur.  The only possible reason I can see for this having any affect
> on the problem is the small delay introduced by the synchronous
> logging.  Since this is only showing up on commit of a database
> transaction which follows close on the heels of a rollback on the same
> connection, is there any chance that there is some very small
> "settling time" needed for a rollback, and we're sometimes getting in
> ahead of this?

(1) No.

(2) Even if we posit the existence of such a serious bug as that, it
wouldn't explain how control gets to the SIGINT response code.

            regards, tom lane

pgsql-admin by date:

Previous
From: Marcin Giedz
Date:
Subject: Re: plperl again but different problem
Next
From: Tom Lane
Date:
Subject: Re: plperl again but different problem