[rt-users] Search hangs RT

[Anne-Marie Achrenius]

Hello!

Sorry, no change in RT behaviour. Still keeps hanging on searches.

Regards,

/Anne-Marie

Torsten Brumm skrev:
> Hi Anne Marie,
> to optimize tables use mysql> optimize table sessions;
> we had the same issue in the past and turned down the session locking
> time in the mysql.pm <http://mysql.pm> from your first mail to 1sec,
> it fixes it for us.
>
> torsten
>
> btw, we also clean each night the session table, which makes rt lot
> faster.
>
>
>
> 2009/2/10 Anne-Marie Achrenius <ama at chalmers.se <mailto:ama at chalmers.se>>
>
>     Kenneth Marshall skrev:
>     > On Tue, Feb 10, 2009 at 02:21:15PM +0100, Anne-Marie Achrenius
>     wrote:
>     >
>     >> Hello!
>     >>
>     >> I'm new to the list and I'm in a bit of a pickle, our RT-guru is on
>     >> paternity leave and we've started having problems with our
>     RT-installation.
>     >> I've tried searching the list archives for something similar, but
>     >> nothing fits exactly:
>     >>
>     >> The problem: Often (not every time, maybe 8 out of 10) when I
>     perform a
>     >> Search in RT, the search hangs.
>     >> The mysqld process is at 100 % cpu. When reading the log files,
>     this
>     >> jumps out:
>     >>
>     >> /var/lib/mysql/blaha.log:
>     >>
>     >> SELECT
>     GET_LOCK('Apache-Session-ed5bea237ae21873fecd13ade9cb3f63', 3600)
>     >>
>     >> and after a few minutes the web-interface returns with "500
>     Internal
>     >> Server Error"
>     >>
>     >> I've so far tried to decrease the LOCK time in
>     >> /usr/lib/perl5/site_perl/5.8.5/Apache/Session/Lock/MySQL.pm
>     >> but that doesn't seem to help at all.
>     >> I've enabled logging of slow mysql queries, but so far no log
>     entries
>     >>
>     >> We're running RT 3.7.5
>     >>                      mysql 14.7
>     >>                      apache 2.0.52
>     >>
>     >> Does anyone have any suggestions or similar problems?
>     >> I can't pinpoint when we started having problems, 2-3 weeks
>     ago, and the
>     >> problem seems to slowly escalate.
>     >>
>     >> /Anne-Marie
>     >>
>     >>
>     >>
>     > Maybe your session table needs to be cleaned up. Try deleting any
>     > sessions over a couple of days old and then optimize the table. I
>     > cannot help with the specific commands since we use PostgreSQL for
>     > our RT instance but in SQL I run a command like:
>     >
>     > DELETE FROM sessions WHERE lastupdated < '2009-1-30';
>     >
>     > or even
>     >
>     > TRUNCATE TABLE sessions;
>     >
>     > to get them all. You may just have a bloat problem. Try a
>     >
>     > SELECT COUNT(*) FROM sessions;
>     >
>     > Hope this helps.
>     >
>     > Cheers,
>     > Ken
>     >
>
>     Thanks for the help, unfortunately the problem doesn't seem to lie
>     there:
>
>     mysql> SELECT COUNT(*) FROM sessions;
>     +----------+
>     | COUNT(*) |
>     +----------+
>     |      323 |
>     +----------+
>     1 row in set (0.00 sec)
>
>     and deleting anything older than 30/1 left 11. Still the same problem,
>     search keeps hanging.
>     How do I optimize the table? (I used to work with Oracle db:s
>     around 10
>     years ago, I'm pretty rusty!)
>
>     Depressed,
>
>     /Anne-Marie
>     _______________________________________________
>     http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>     Community help: http://wiki.bestpractical.com
>     Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
>
>
>     Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     Buy a copy at http://rtbook.bestpractical.com
>
>
>
>
> -- 
> MFG
>
> Torsten Brumm
>
> http://www.torsten-brumm.de