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@pvv.ntnu.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