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]