<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>RE: [Rt-devel] Problem with Rt-Shredder</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Hi,</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Thanks for the pointers.</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">RT Version: 3.4.4 </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Shredder: 0.03_01</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">I am running this on a secondary MySQL server to test timings. The error occurs when I run rt-shredder as below:</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Arial">/usr/local/rt3/local/sbin/rtx-shredder --plugin 'Tickets=status,deleted;updated_before,2003-10-05 21:39:34;limit,10</FONT></I></SPAN><I><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">000</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">' --sqldump /tmp/rt3_dump.sql</FONT></SPAN></I><SPAN LANG="en-us"></SPAN></P>
<P><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Now I have tried the limit at various settings as low as 5 and up to 20000, the shredder will work for various periods of time from 30secs to over an hour before it hits this error but it does hit it this error more often than not and in fact the only times it doesn't is when there is a very low limit set "i.e up to 10".</FONT></SPAN></P>
<P><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">The other errors that the shredder reports around this error as below:</FONT></SPAN>
</P>
<P><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">[root@linuxserv02 root]# date</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">Thu Mar 23 14:50:38 GMT 2006</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">[root@linuxserv02 root]# /usr/local/rt3/local/sbin/rtx-shredder --plugin 'Tickets=status,deleted;updated_before,2003-10-05 21:39:34;limit,2000' --sqldump /tmp/rt3_dump.sql --force</FONT></I></SPAN></P>
<P><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">SQL dump file is '/tmp/rt3_dump.sql'</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">[Thu Mar 23 14:52:59 2006] [crit]: RT::Ticket=HASH(0xa66112c) tried to load a bogus ticket: 216</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial"> (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:257)</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">[Thu Mar 23 14:52:59 2006] [crit]: Can't locate object method "caught" via package "RTx::Shredder::Exception::Info" at /usr/local/rt3/local/sbin/rtx-shredder line 107.</FONT></I></SPAN></P>
<P><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial"> (/usr/local/rt3/lib/RT.pm:295)</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">[root@linuxserv02 root]# date</FONT></I></SPAN>
<BR><SPAN LANG="en-gb"><I><FONT SIZE=2 FACE="Arial">Thu Mar 23 14:53:23 GMT 2006</FONT></I></SPAN>
</P>
<P><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">After the above run the</FONT><I> <FONT SIZE=2 FACE="Arial">/tmp/rt3_dump.sql</FONT></I> <FONT SIZE=2 FACE="Arial">logfile was as attached.</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT FACE="Arial" SIZE=2 COLOR="#000000"> <<rt3_dump.sql>> </FONT></SPAN>
</P>
<P><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Regards</FONT></SPAN>
</P>
<P><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Dax</FONT></SPAN><SPAN LANG="en-us"></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">From: Ruslan Zakirov [</FONT></SPAN><A HREF="mailto:ruslan.zakirov@gmail.com"><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:ruslan.zakirov@gmail.com</FONT></U></SPAN></A><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">] </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Sent: 23 March 2006 12:55</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">To: Dave Wells</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Cc: RT users</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Subject: Re: [Rt-devel] Problem with Rt-Shredder</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">RT version? Shredder version?</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">What did you do when you got this?</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">What other errors near that one?</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">This thread should be in rt-users@ and also always Cc to the author of the extension.</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">On 3/23/06, Dave Wells <dave.wells@foreshore.net> wrote:</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> Hi,</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> I am using rt-shredder to thin out my RT database. However I keep </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> getting the following error:</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> [Thu Mar 23 11:31:48 2006] [crit]: Can't locate object method "caught"</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> via package "RTx::Shredder::Exception::Info"</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> Does anyone know how to fix this?</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> Regards</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> Dax</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> ______________________________________________________________________</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> This email has been scanned by the MessageLabs Email Security System.</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> For more information please visit </FONT></SPAN><A HREF="http://www.messagelabs.com/email"><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.messagelabs.com/email</FONT></U></SPAN></A><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> ______________________________________________________________________</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> _______________________________________________</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> List info: </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> </FONT></SPAN><A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel"><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel</FONT></U></SPAN></A><SPAN LANG="en-us"></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> Best Practical is hiring! Come hack Perl for us: </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">> </FONT></SPAN><A HREF="http://bestpractical.com/about/jobs.html"><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://bestpractical.com/about/jobs.html</FONT></U></SPAN></A><SPAN LANG="en-us"></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">--</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Best regards, Ruslan.</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">______________________________________________________________________</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">This email has been scanned by the MessageLabs Email Security System.</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">For more information please visit </FONT></SPAN><A HREF="http://www.messagelabs.com/email"><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.messagelabs.com/email</FONT></U></SPAN></A><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> ______________________________________________________________________</FONT></SPAN></P>
<BR>
______________________________________________________________________<BR>
This email has been scanned by the MessageLabs Email Security System.<BR>
For more information please visit http://www.messagelabs.com/email <BR>
______________________________________________________________________<BR>
</BODY>
</HTML>