pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: tgl@sss.pgh.pa.us
Cc: pgsql-admin@postgresql.org
Subject: Re: ERROR: canceling query due to user request
Date: Tue, 13 Sep 2005 08:51:29 -0500
Message-ID: <s326931e.001@gwmta.wicourts.gov> (raw)

Thanks, Tom.
 
The statement_timeout setting was also raised on the JDBC list, and has been checked -- there is nothing setting statement_timeout.  The connection shows this value at zero.  None of our code contains anything PostgreSQL specific, so there is nothing in our framework or applications that would be aware of the "set statement_timeout" command to be able to issue it.  I created the database instance, the user and the database, and have not set this as a default anywhere.
 
Regarding the possibility that a ulimit setting is sending the signal, I am using "su" to set user id to root, issuing the ulimit statements to set everything unlimited or very high, then using "su" to set user id to postgres.  At that point the settings from root still show.  Then I'm starting postgres using pg_ctl.  Is there any reason the ulimit settings would not carry through with this approach?  Is there a better way to do it?
 
Other than that, what external causes might be at fault when I have both Windows machines and Linux machines which have nothing installed but the operating system and PostgreSQL?  The only ulimit settings I couldn't set to "unlimited" were pipe size and open files.  Is there any chance that the error/rollback path in the code is leaking open files on the server?  Is there anything I should run during the test to watch for potential resource exhaustion?
 
-Kevin
 
 
>>> Tom Lane <tgl@sss.pgh.pa.us> 09/12/05 5:39 PM >>>
"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




view thread (14+ messages)  latest in thread

Message-ID: <s326931e.001@gwmta.wicourts.gov>
Permalink:  ../s326931e.001@gwmta.wicourts.gov/
Also on:    postgresql.org/message-id/s326931e.001@gwmta.wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, tgl@sss.pgh.pa.us
  Subject: Re: ERROR: canceling query due to user request
  In-Reply-To: <s326931e.001@gwmta.wicourts.gov>
  References: <s326931e.001@gwmta.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox