Re: java.sql.SQLException: ERROR: canceling query due to user

Oliver Jowett wrote:
> Kevin Grittner wrote:
>
>>The server is 8.0.3 running on Windows. The client is using the 311 build with some patches we need (from the stable branch). There is nothing we know of which would be canceling things on the server side, and nothing we know of which would be doing so on the JDBC client. (In fact, when this happens during invocation of the Connection.commit method, I don't think there is a way to cancel it programatically.)
>
>
>>java.sql.SQLException: ERROR: canceling query due to user request
>
>
> On a unix system I'd say that something is sending SIGINT to the backend
> process. Certainly, the JDBC driver never sends a cancel request unless
> you explicitly call Statement.cancel(), and as you say there's no way to
> cancel a commit().

Oh -- another possibility is that you've set statement_timeout, which is
implemented in the backend as sending a query cancel after the timeout.

-O