Rt-shredder choking on gigantic ticket

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.

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

Shred all the transactions, one at a time (in a programmed loop) and
then come back for the ticket itself.

-kevin

Hi @Kevin_Falcone and @Luke_Benfey
I can see this post is quite old, but would ask if you can give an example of how to delete a specific number of transactions for a specific ticket.

As far as I have been able to see the Shredder option for transactions only works with files names or file sizes.

We are using RT 4.0.17 and mysql and have a massive ticket caused by an email loop.

Rob