<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{}
@page Section1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.Section1
{}
ol
{margin-bottom:0cm}
ul
{margin-bottom:0cm}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal">Heya guys! </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Looking at the sqldump file as it comes out, it appears to all be one single “deleted” ticket with a huge mail loop.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">The rt-shredder sqldump file from this 10 hour attempt to remove that single problem ticket is 5.4GB.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">So, I guess my question is whether anyone has any better suggestion for how to get rid of this ticket? </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"> </p>
<p class="MsoListParagraph" style="margin-left:24.75pt; text-indent:-18.0pt"><span style="">-<span style="font:7.0pt "Times New Roman"">
</span></span>Luke</p>
<p class="MsoNormal"> </p>
</div>
<p style="font-family:arial; color:black; font-size:10px">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.</p>
</body>
</html>