[rt-users] Strange Shredder/MySQL Behaviour

[Konstantin Naryzhniy]

Mason cache?
Are the shredded records still in database?

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Mathew Snyder
Sent: Wednesday, December 19, 2007 2:43 PM
To: rt-users at lists.fsck.com
Subject: [rt-users] Strange Shredder/MySQL Behaviour

For the past week I've been cleaning out our user cache to eliminate orphaned
"users" created by since deleted spam.  Looking in var/data/RTx-Shredder I see
the .sql files created during these Shredder runs so I would expect to see users
which I've already removed within these files.  However, this isn't the case.
After an instance of Shredder completes, I go back to continue my task and find
the same users are, again, in the list.

In order to make sure I'm not doing anything wrong I've removed some of these
users in small batches of one to 10 and reloaded to see if they have been
removed.  The page reload after Shredder completes indicates that they have been
taken out.  I've then grep'ed the files created for the users I had removed and
sure enough, there they were in the .sql files.  However, after a significant
period of time (the last instance completed sometime yesterday afternoon and I'm
looking at it again for the first time at 6am) the users I removed are once
again in the list.

I've also cleared out my browser cache to make sure it wasn't loading an old
version of the page.

The settings which I'm using for the Users plugin:
Limit: 1700
status: any
name:
email:
replace_relations: user_name
no_tickets: 1 (I've tried leaving this blank as well with the same results)

What the crap is happening here?

--
Keep up with me and what I'm up to: http://theillien.blogspot.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today.
    Email us at sales at bestpractical.com or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com