Deleting mass events

[themactech]

themactech [http://community.zenoss.org/people/themactech] created the discussion

"Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64066#64066

--------------------------------------------------------------
I have a device that I had set to 'Maintenance' because it was generating two errors every 2 minutes.  Back then I didn't know how to use transforms to drop events.  I just did that yesterday.

Now I want to toggle the device back to 'Production' but it has 150 000+ events.  I have tried to delete the device, chossing 'erase all events', but the GUI times out and when I eventually reload, the device and all it's 150 000+ events are still there.

I have tried direct SQL commands I have found here, but even though I have found about 10 different how-to's in here, none of them are identical and since I tried one, my zenoss is slow as hell and my #@$^@$%U&# events are still there.

Any suggestion would be appreciated.

Manuel
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64066#64066]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64067#64067

--------------------------------------------------------------
Manuel:

ssh to the sql server, mysql -u root -p

use events;
delete from status where device = "zen1.lon.rackspace.net" limit 1000;

Repeat until the events are gone. Use limit to make sure that you don't eviscerate mysql.

Best,
--Shane (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64067#64067]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[themactech]

themactech [http://community.zenoss.org/people/themactech] created the discussion

"Re: Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64508#64508

--------------------------------------------------------------
Sorry for the delay, only got around to doing this today.  Worked like a charm, you saved my bacon on this one.  That procedure has gone into the notebook.

Thanks

Manuel
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64508#64508]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64509#64509

--------------------------------------------------------------
Manuel:

http://youtu.be/hoR3ROkBAsI

:)

--Shane (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64509#64509]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[themactech]

themactech [http://community.zenoss.org/people/themactech] created the discussion

"Re: Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64528#64528

--------------------------------------------------------------
Just had a tiny setback, after deleting the 150000 events, I just now started getting a clear alert for each of them.  My email is now dead due to the spamming...

Manuel
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64528#64528]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: Deleting mass events"

To view the discussion, visit: http://community.zenoss.org/message/64522#64522

--------------------------------------------------------------
themactech:

I'm sorry to hear that. I often reccomend using postfix and cluebringger to quota zenoss's email for this reason.

--Shane
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/64522#64522]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]