Re: ERROR: canceling query due to user request

From: Mr Pink <mr_pink_is_the_only_pro(at)yahoo(dot)com>
To: Tore Halset <halset(at)pvv(dot)ntnu(dot)no>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: canceling query due to user request
Date: 2004-09-07 14:46:56
Message-ID: 20040907144656.66586.qmail@web41113.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi,

We were getting that problem on an old, low spec server that we know has memory problems. The
error message occured only on larger jobs, such as restoring a large table.

IIRC, I got the same problem last year after messing around with postgres config parameters,
probably also a memory issue since it went away when I reset my parameters to more reasonable
settings.

The server log may have some information.

I hope this gives you some clue as to where to start looking for your problem.
regards
Mr Pink

--- Tore Halset <halset(at)pvv(dot)ntnu(dot)no> wrote:

> Hello.
>
> I am trying to port an old java application from MS SQL Server to
> PostgreSQL running on Mac OS X. I have access to the java source code
> and can make modifications. I have tried with PostgreSQL version 7.4.2
> and 8.0.0beta2, but get the same error. I am using pgdev.305.jdbc3.jar
> for 8.0.0beta2. The PostgreSQL installation are standard, except for
> log_statement = 'all' to debug this problem.
>
> The problem is that the server returns "ERROR: canceling query due to
> user request" on some of the queries. I do not find any (other) signs
> of small timeouts or that the query could be cancelled in the java
> client. I have tried the queries from the psql promt, and they are all
> pretty fast. Where should I start looking? Are there any more debug
> flags than log_statement that should be turned on?
>
> Regards,
> - Tore.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>


__________________________________
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.
http://messenger.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-07 14:54:38 Re: ERROR: canceling query due to user request
Previous Message Tom Lane 2004-09-07 14:39:44 Re: explain with placeholders?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2004-09-07 14:54:38 Re: ERROR: canceling query due to user request
Previous Message Paul Thomas 2004-09-07 13:11:50 Re: ERROR: canceling query due to user request