Re: ERROR: canceling query due to user request

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tore Halset <halset(at)pvv(dot)ntnu(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: canceling query due to user request
Date: 2004-09-07 14:54:38
Message-ID: 714.1094568878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Tore Halset <halset(at)pvv(dot)ntnu(dot)no> writes:
> I am trying to port an old java application from MS SQL Server to
> PostgreSQL running on Mac OS X.
> ...
> The problem is that the server returns "ERROR: canceling query due to
> user request" on some of the queries.

The proximate cause of this has to be that something is sending SIGINT
to the backend process that's running the query. You'll have to look
around for reasons for that to happen, if you're sure that your client
code isn't doing it. A couple of possibilities come to mind:

1. You accidentally typed ^C on the terminal window the postmaster was
launched from.

2. The postmaster was launched under non-infinite resource limits
(ulimit settings) and whatever enforces that on OS X does it by sending
SIGINT rather than the more standard signals for such things. Do the
SIGINTs come at predictable times, such as when the backend has
accumulated X amount of runtime?

This isn't the first time I've heard of unexpected SIGINTs being
delivered on OS X. (I vaguely recall seeing the MySQL guys complaining
of just that.) I have not seen it happen in my own testing, though,
so I'm not sure what's going on. Let us know if you find the cause.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dino Vliet 2004-09-07 14:54:49 Re: error: insert has more expressions than target column
Previous Message Mr Pink 2004-09-07 14:46:56 Re: ERROR: canceling query due to user request

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tore Halset 2004-09-07 16:08:35 Re: ERROR: canceling query due to user request
Previous Message Mr Pink 2004-09-07 14:46:56 Re: ERROR: canceling query due to user request