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