Shredder stuck!

RT Users
#1

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

#2

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@mionegroup.com
To: “rt-users” rt-users@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