<html><head><style type='text/css'>p { margin: 0; }</style><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body>Hello,<br><br>We have been running RT for about a year and it has suddenly started running slowly. Looking at the RT.log file, we are seeing a whole bunch of stack-traces, for no reason I can ascertain. Anyone any ideas why these would suddenly start appearing?<br><br>[Fri May 16 04:33:57 2008] [error]: SQL(0.00s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Queue = '22' AND main.Status = 'stalled') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt3/share/html/autohandler:319)<br><br>Stack trace:<br> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135<br> HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245<br> HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411<br> HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168<br> HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826<br> HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125<br> (eval)() called at /opt/rt3/bin/webmux.pl:125<br> RT::Mason::handler() called at -e:0<br> (eval)() called at -e:0<br>[Fri May 16 04:33:57 2008] [error]: SQL(0.00s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Queue = '13' AND main.Status = 'new') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt3/share/html/autohandler:319)<br><br>Stack trace:<br> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135<br> HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245<br> HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459<br> (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411<br> HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168<br> HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826<br> HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125<br> (eval)() called at /opt/rt3/bin/webmux.pl:125<br> RT::Mason::handler() called at -e:0<br> (eval)() called at -e:0<br><br>-- <br>Cheers,<br>David<br><br></body></html>