Postgres Pro
Downloads
Home   >   mailing lists

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 6248.1126564784@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: canceling query due to user request  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> org.postgresql.util.PSQLException: ERROR: canceling query due to user request

The only possible trigger of that message is a SIGINT sent to the backend.
Now the backend will SIGINT itself if a statement timeout expires, so one
possibility is that you have statement_timeout set and it's getting
exceeded.  Otherwise you need to be looking for external causes.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: Re: Server Time Setting
Next
From: Tom Lane
Date:
Subject: Re: Server Time Setting