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.
--
RT Training - Boston, September 9-10
http://bestpractical.com/training