Hi Steve, that's what I did in the end but I would really like to know why
removing the row didn't work

On 18 July 2013 14:43, Steve Wiser <steve@...>wrote:

> If it is classic server you can you find the PID and kill the process?
>
> -steve
>
>
> --
> Steve Wiser
> President
> Specialized Business Software
> 6325 Cochran Road, Unit 1
> Solon, OH 44139
>
> www.specializedbusinesssoftware.com
> www.docunym.com
> (440) 542-9145 - fax (440) 542-9143
> Toll Free: (866) 328-4936
>
>
>
> On Thu, Jul 18, 2013 at 8:54 AM, Nick Upson <nu@...> wrote:
>
> > **
> >
> >
> > A
> > nyone?
> >
> >
> > ---------- Forwarded message ----------
> >
> > Hi,
> >
> > (running 2.1.5 on centos) I tried to kill a exceptionally long-running
> > query (several hours) by deleting the row from MON$STATEMENT, no errors
> but
> > it didn't delete. I was connected via isql as sysdba, the query wasn't
> > using sysdba
> >
> > select * from
> > MON$STATEMENTS where MON$STATEMENT_ID = 30;
> >
> > showed the query, then I did
> >
> > SQL> delete from
> > MON$STATEMENTS where MON$STATEMENT_ID = 30;
> > SQL> commit;
> >
> > select * from
> > MON$STATEMENTS where MON$STATEMENT_ID = 30;
> >
> > and it was still there, disconnected and connected again, still there.
> >
> > Should I have done something different, how can I ensure this works in
> > future?
> >
> > --
> > Nick Upson, Telensa Ltd
> >
> > --
> > Nick Upson, Telensa Ltd
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > This message and any files transmitted with it may contain information
> > that is privileged, confidential, and exempt from disclosure under
> > applicable law. They are intended solely for the use of the intended
> > recipient. If you are not the intended recipient, distributing, copying,
> > disclosing, or reliance on the contents of this communication is strictly
> > prohibited. If this has reached you in error, kindly destroy this
> message
> > and notify the sender immediately. Thank you for your assistance.
> >
> > We attempt to sweep harmful content (e.g. viruses) from e-mail and
> > attachments, however we cannot guarantee their safety and can accept no
> > liability for any resulting damage. The recipient is responsible to
> verify
> > the safety of this message and any attachments before accepting them.
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


--
Nick Upson, Telensa Ltd


[Non-text portions of this message have been removed]