[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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] Strange Shredder/MySQL Behaviour
Mason cache? Are the shredded records still in database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder Sent: Wednesday, December 19, 2007 2:43 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Strange Shredder/MySQL Behaviour
Just to hash this, I've just completed cleaning up more users and some of those that are causing this problem are once again in the list despite being specifically removed. Keep up with me and what I'm up to: http://theillien.blogspot.com Mathew Snyder wrote: > 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? > ___ 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Strange Shredder/MySQL Behaviour
More info: I've done a search for both Watcher Name and Watcher Email and found no tickets for which these users are associated. Additionally, the mysql log only indicates that the users were created. Not to what they were added as a watcher. 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
