Hello, 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?
[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) Stack trace: HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135 HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245 HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411 HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168 HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826 HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125 (eval)() called at /opt/rt3/bin/webmux.pl:125 RT::Mason::handler() called at -e:0 (eval)() called at -e:0 [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) Stack trace: HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135 HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245 HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411 HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168 HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826 HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125 (eval)() called at /opt/rt3/bin/webmux.pl:125 RT::Mason::handler() called at -e:0 (eval)() called at -e:0 -- Cheers, David
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
