Re: [JDBC] [GENERAL] ERROR: canceling query due to user request

2004-09-09 Thread Tom Lane
Paul Thomas <[EMAIL PROTECTED]> writes: > On 09/09/2004 10:41 Oliver Jowett wrote: >> JDBC gives you no way to ensure you only call cancel() on a running query >> (there's a race between query execution returning and the call to >> cancel()). Calling cancel() on a statement that's not currently e

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-08 Thread Tom Lane
Tore Halset <[EMAIL PROTECTED]> writes: > On Sep 7, 2004, at 20:03, Tom Lane wrote: >> I suspect that it's got nothing at all to do with the traffic between >> the server and the client, and that the SIGINT is coming from some >> outside agency. > Yes, you are correct. No, I'm not ;-) > I added

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-08 Thread Tore Halset
On Sep 8, 2004, at 11:25, Tore Halset wrote: I installed beta2 on a local linux box instead and now everything is working :/ Something must trigger Mac OS X to send those evil SIGINTs. Will it happens on the linux box as well, but not that often. Grr. - Tore. ---(end of br

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Tom Lane
Tore Halset <[EMAIL PROTECTED]> writes: > I need to debug all of the trafic between the server and the client to > track down this problem. I suspect that it's got nothing at all to do with the traffic between the server and the client, and that the SIGINT is coming from some outside agency. How

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Andrew Janian
: Re: [GENERAL] ERROR: canceling query due to user request "Andrew Janian" <[EMAIL PROTECTED]> writes: > I am experiencing a similar problem with PostgreSQL running on Debian. > I am not doing anything special when it happens, just once and a > while. It is not a product

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Tore Halset
On Sep 7, 2004, at 16:54, Tom Lane wrote: Tore Halset <[EMAIL PROTECTED]> 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 pr

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Tore Halset
On Sep 7, 2004, at 15:11, Paul Thomas wrote: It sounds to my like your Java app is issueing the cancel. Something fishy is going on here as the application is very stable under MS SQL Server. I have tried to set log_statement to 'all'. All queries are displayed, but everything looks ok except for

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Tom Lane
"Andrew Janian" <[EMAIL PROTECTED]> writes: > I am experiencing a similar problem with PostgreSQL running on Debian. > I am not doing anything special when it happens, just once and a > while. It is not a production system (on which this problem does not > occur) so I just restart and everything i

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Andrew Janian
is happening to anyone else though. Thanks, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane Sent: Tuesday, September 07, 2004 9:55 AM To: Tore Halset Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] ERROR: canceling query due to user request

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Tom Lane
Tore Halset <[EMAIL PROTECTED]> 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

Re: [GENERAL] ERROR: canceling query due to user request

2004-09-07 Thread Mr Pink
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 issu