From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to cancel a query if SIGINT does not work? |
Date: | 2005-08-19 17:27:14 |
Message-ID: | BF2BD502.4B22C%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 19/8/05 6:20 pm, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote:
> On Fri, Aug 19, 2005 at 06:10:28PM +0100, Adam Witney wrote:
>>> If you get a pile of purely numeric output from bt, it's useless
>>> (means you're running symbol-stripped executables). I'm hoping
>>> for at least some function names.
>
> [trace below]
>
> That's not stuck, somebody has typed COPY FROM STDIN and not sent any
> data (or not finished it). Should be able to Ctrl-C it though. Are you
> sure you have the right backend?
>
> Closing the frontend attached to it should do...
Ah.... Its a web application... I assumed that because the browser had been
closed that the query must have hung. But just restarted the apache server
and that cancelled it, so apache must have kept the query running despite
the user closing the browser.
Sorry I probably should have thought of that!
Thanks for your help Tom and Martijn
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-08-19 17:29:04 | Re: libpq and unwanted stderr output |
Previous Message | Tom Lane | 2005-08-19 17:20:48 | Re: How to cancel a query if SIGINT does not work? |