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, 1 );
Cheers,
David
- Original Message -
From: David Hobley david.hob...@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
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com