[rt-users] shredder stuck!

[David Hobley]

OK, I finally worked this out myself. Note to self. --force stops error messages appearing as well as other output. 

The issue was in the dependency setting for the shredder, we had some tickets with more than 1,000 dependencies (due to a couple of mail loops in the past) and it just stops when it hits that number. I upped ours to 10,000 in the RT_SiteConfig.pm file: 

Set( $DependenciesLimit, 10000 ); 

Cheers, 
David 
----- Original Message ----- 
From: "David Hobley" <david.hobley at mionegroup.com> 
To: "rt-users" <rt-users at lists.bestpractical.com> 
Sent: Monday, 21 September, 2009 3:57:21 PM GMT +10:00 Brisbane 
Subject: [rt-users] shredder stuck! 


Hello, 

I am running the shredder over our database and it has been dutifully deleting the deleted tickets as requested. It has processed around 20,000 so far but is now stuck with the following output in the SQL dump files: 

INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107639','912264','10','3107639'); 
INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107640','912264','10','3107635'); 
INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) VALUES('912264','1168372','10'); 
INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107635','912264','912264','3107635'); 
INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype 
`,`timetaken`,`type`) VALUES('2008-09-26 23:23:48','228052',NULL,NULL,'2001691',NULL,NULL,'912264','RT::Group',NULL,NULL,NULL,'0','Create'); 
INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','912264','192693',NULL,'Owner'); 
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','912264','912264','Group'); 

No other errors or warnings that I can see. Would anyone have any ideas why it is stuck? 

-- 
Cheers, 
David 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091001/b8356ca4/attachment.htm>