[rt-users] shredder stuck!

David Hobley david.hobley at mionegroup.com
Mon Sep 21 01:57:21 EDT 2009


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/20090921/3f4f1c16/attachment.htm>


More information about the rt-users mailing list