Re: ERROR: canceling query due to user request

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