Re: [rt-users] rt-shredder Users plugin deletes tickets?
I mailed this bug report and still waiting for a response: http://rt3.fsck.com/Ticket/Display.html?id=14170user=guestpass=guest Am 11.03.2010 19:42, schrieb Gary Hall: Hi Howie, I ran into the same problem. In my case, the deleted Tickets contained Correspondence from Users who were otherwise not Watchers (i.e., Requestors, Owners, AdminCCs or CCs) in the system. The Tickets were deleted by the jobs that removed the Users. Seems like a bug to me. Gary -- Gary Hall RT Admin Simon Fraser University On 01/-10/-28163 11:59 AM, Howard Jones wrote: I've just upgraded to RT 3.8.7 from 3.6.5, and I'm catching up on my shredding. Over the weekend I shredded 2 or so deleted tickets (spam mainly), and today I went to start on the users. This has never really worked well before, so we have about 60k users, and at most 1000 of them are active. So I created a user called placeholder, made them privileged and made sure they are the requestor on a long-running ticket. Then... ./rt-shredder --plugin 'Users=status,enabled;replace_relations,placeholder;no_tickets,true;member_of,unprivileged;limit,100' {snipped output} [Tue Mar 9 15:20:39 2010] [info]: RT::Transaction-2992615 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) -- [Tue Mar 9 15:20:39 2010] [info]: RT::Ticket-348651 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193272 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::GroupMember-1394521 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193271 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Transaction-3007389 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Group-1857870 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) Why does the Users plugin delete tickets? Surely it should only be deleting users that have no tickets (no_tickets, true)? Thanks for any illumination... Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 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 Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-shredder Users plugin deletes tickets?
I do not think I agree with this. If you ask for a user to be removed, any ticket that they have touched should go as well. Otherwise you will have unattributed updates in the system. It seems like you may have a bit too aggressive a policy for cleaning out users. Another approach is to put a better anti-spam system in front of RT to keep these deletions to a more manageable number. Good luck. Cheers, Ken On Tue, Mar 16, 2010 at 02:12:46PM +0100, Christian Loos wrote: I mailed this bug report and still waiting for a response: http://rt3.fsck.com/Ticket/Display.html?id=14170user=guestpass=guest Am 11.03.2010 19:42, schrieb Gary Hall: Hi Howie, I ran into the same problem. In my case, the deleted Tickets contained Correspondence from Users who were otherwise not Watchers (i.e., Requestors, Owners, AdminCCs or CCs) in the system. The Tickets were deleted by the jobs that removed the Users. Seems like a bug to me. Gary -- Gary Hall RT Admin Simon Fraser University On 01/-10/-28163 11:59 AM, Howard Jones wrote: I've just upgraded to RT 3.8.7 from 3.6.5, and I'm catching up on my shredding. Over the weekend I shredded 2 or so deleted tickets (spam mainly), and today I went to start on the users. This has never really worked well before, so we have about 60k users, and at most 1000 of them are active. So I created a user called placeholder, made them privileged and made sure they are the requestor on a long-running ticket. Then... ./rt-shredder --plugin 'Users=status,enabled;replace_relations,placeholder;no_tickets,true;member_of,unprivileged;limit,100' {snipped output} [Tue Mar 9 15:20:39 2010] [info]: RT::Transaction-2992615 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) -- [Tue Mar 9 15:20:39 2010] [info]: RT::Ticket-348651 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193272 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::GroupMember-1394521 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193271 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Transaction-3007389 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Group-1857870 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) Why does the Users plugin delete tickets? Surely it should only be deleting users that have no tickets (no_tickets, true)? Thanks for any illumination... Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 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 Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 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 Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-shredder Users plugin deletes tickets?
Kenneth Marshall wrote: I do not think I agree with this. If you ask for a user to be removed, any ticket that they have touched should go as well. No, I asked for users with no tickets to be removed[0]. By definition, there *are no tickets* that need to be removed! :-) Otherwise you will have unattributed updates in the system. It seems like you may have a bit too aggressive a policy for cleaning out users. Another approach is to put a better anti-spam system in front of RT to keep these deletions to a more manageable number. Good luck. If something says it will delete users, but in fact deletes tickets and users, it's a little concerning. I guess it would delete less tickets if there were less users, but that's not really the issue. This is in a system with anti-spam measures ahead of the RT instance. However, historically that wasn't always the case, so we have all these old users hanging around. Howard [0] at least I'm pretty sure I did. The documentation for RT-Shredder is fairly sparse. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-shredder Users plugin deletes tickets?
I do not think I agree with this. If you ask for a user to be removed, any ticket that they have touched should go as well. The shredder gives the option of reassigning ownership (to nobody for instance) when shredding users, otherwise transactions must be wiped to preserve referential integrity. In my experience what happens in these instances where a non-watcher has correspondence on a ticket is that the transactions in question get borked and while the ticket remains, the display is interrupted once it reaches said transaction. I've never seen a ticket get wiped. Your log does show a Ticket being wiped out though, but if you read the archived SQL you will probably find that the only transaction it contained was 2992615, created by a wiped user. It seems to me one usually needs to shred users who have submitted SPAM, and that the ability to shred tickets meeting certain criteria as well as their requestors at the same time would help alleviate this problem e.g; Status = Deleted and Requestor has no other Tickets not marked Deleted. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-shredder Users plugin deletes tickets?
Howard Jones wrote: Why does the Users plugin delete tickets? Surely it should only be deleting users that have no tickets (no_tickets, true)? Is anyone else successfully using RT-Shredder to remove redundant users? What incantation are you using that doesn't also delete tickets? Cheers, Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-shredder Users plugin deletes tickets?
Hi Howie, I ran into the same problem. In my case, the deleted Tickets contained Correspondence from Users who were otherwise not Watchers (i.e., Requestors, Owners, AdminCCs or CCs) in the system. The Tickets were deleted by the jobs that removed the Users. Seems like a bug to me. Gary -- Gary Hall RT Admin Simon Fraser University On 01/-10/-28163 11:59 AM, Howard Jones wrote: I've just upgraded to RT 3.8.7 from 3.6.5, and I'm catching up on my shredding. Over the weekend I shredded 2 or so deleted tickets (spam mainly), and today I went to start on the users. This has never really worked well before, so we have about 60k users, and at most 1000 of them are active. So I created a user called placeholder, made them privileged and made sure they are the requestor on a long-running ticket. Then... ./rt-shredder --plugin 'Users=status,enabled;replace_relations,placeholder;no_tickets,true;member_of,unprivileged;limit,100' {snipped output} [Tue Mar 9 15:20:39 2010] [info]: RT::Transaction-2992615 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) -- [Tue Mar 9 15:20:39 2010] [info]: RT::Ticket-348651 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193272 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::GroupMember-1394521 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193271 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Transaction-3007389 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Group-1857870 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) Why does the Users plugin delete tickets? Surely it should only be deleting users that have no tickets (no_tickets, true)? Thanks for any illumination... Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] rt-shredder Users plugin deletes tickets?
I've just upgraded to RT 3.8.7 from 3.6.5, and I'm catching up on my shredding. Over the weekend I shredded 2 or so deleted tickets (spam mainly), and today I went to start on the users. This has never really worked well before, so we have about 60k users, and at most 1000 of them are active. So I created a user called placeholder, made them privileged and made sure they are the requestor on a long-running ticket. Then... ./rt-shredder --plugin 'Users=status,enabled;replace_relations,placeholder;no_tickets,true;member_of,unprivileged;limit,100' {snipped output} [Tue Mar 9 15:20:39 2010] [info]: RT::Transaction-2992615 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) -- [Tue Mar 9 15:20:39 2010] [info]: RT::Ticket-348651 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193272 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::GroupMember-1394521 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::CachedGroupMember-4193271 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Transaction-3007389 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) [Tue Mar 9 15:20:41 2010] [info]: RT::Group-1857870 wiped out (/opt/rt3/sbin/../lib/RT/Shredder/Record.pm:236) Why does the Users plugin delete tickets? Surely it should only be deleting users that have no tickets (no_tickets, true)? Thanks for any illumination... Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com