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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
