Page 1 of 1

Clear alert for deleted node

Posted: Wed Nov 12, 2008 8:44 pm
by paullanders
Hi Dave.

I removed a node that no longer exists, but the alert in the NATS ALERT window is still there. How do I remove this 'stuck' alert?

Thanks!

P.S. I was going to upload a screen shot but I don't see the option to upload files to the forum.

Paul

Re: Clear alert for deleted node

Posted: Wed Nov 12, 2008 11:04 pm
by dave
Hi Paul,

Yes this is a known quirk (which I said I'd do something about but haven't) :(

What you need to do is execute the following through the SQL console (you may need to enable this, see here):

Code: Select all

update fnalert set closedx=now() where nodeid="your_node_id"
I really really must put a manual close option in if not sort out the deletions properly.

Hope that helps,

Dave.

Re: Clear alert for deleted node

Posted: Wed Nov 12, 2008 11:13 pm
by paullanders
Worked beautifully! Thanks!

Re: Clear alert for deleted node

Posted: Thu Nov 13, 2008 6:51 pm
by dave
Good stuff!

I really really will now go and update some of the delete procedures.

Cheers,

Dave.

Re: Clear alert for deleted node

Posted: Thu Nov 13, 2008 7:03 pm
by dave
In fact... done now in 1.02.2a.

Cheers,

Dave.