[rt-users] rt-shredder choking on gigantic ticket.

[Luke Benfey]

Heya guys!

We're running rt4 on an Ubuntu 12.04 system.  We're in the process of moving to a new server, and as part of that process I'm trying to us rt-shredder to cull out old resolved/rejected/deleted tickets.     I've run into an issue where rt-shredder is encountering a ticket with too many dependencies.  No problem, I think, and I tweak the DependenciesLimit upwards.  Still doesn't work.  So I tweak it up a bit more, and then a bit more, and then a bit more... and finally, with the DependenciesLimit up at 50000, rt-shredder will actually take a crack at it.

Looking at the sqldump file as it comes out, it appears to all be one single "deleted" ticket with a huge mail loop.

However, rt-shredder just  churns and churns, gradually consuming all of the memory on the system.  I actually went ahead and added 26GB of Swap just to see if it would complete, but eventually it used that up too, and killed the rt-shredder proc in the middle of last night.

The rt-shredder sqldump file from this 10 hour attempt to remove that single problem ticket is 5.4GB.

So, I guess my question is whether anyone has any better suggestion for how to get rid of this ticket?

Thanks,


-          Luke


Copyright in this message and any attachments remains with us. It is confidential and may be legally privileged. If this message is not intended for you it must not be read, copied or used by you or disclosed to anyone else. Please advise the sender immediately if you have received this message in error. Although this message and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Encore Tickets Limited for any loss or damage in any way arising from its use.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140911/fc9a52e6/attachment.htm>