[rt-users] Slow RTIR

[Jesse Vincent]

On Sat, Mar 27, 2010 at 08:28:14PM +0100, Koen Van Impe wrote:
> Hello,
> 
> We run RT 3.8.4 on Ubuntu 9.04 (mysql 5.0.75). RTIR is working fine with
> decent speed (some 4000 tickets in the queue). Unfortunately when we
> click on the "Lookup" link next to an IP, RT just stalls.
> 
> mysql takes all of the cpu (99%), there's nothing unusual in the logs.
> The last two lines in the mysql log show
> 
> 100327 17:47:28	     33 Query       SELECT
> GET_LOCK('Apache-Session-16749711901078a349aea9e34d956e74', 3600)
> 		     29 Query       SELECT
> GET_LOCK('Apache-Session-16749711901078a349aea9e34d956e74', 3600)

Those are user sessions. There's something _earlier_ that's causing your blocking problem. What was the last "real" query in the log? (Also, 3.8.7, should fix a bunch of issues related to performance. You'll also want to be current on RTIR).
> 
> After that the site becomes un-responsive to all users, the only
> solution is to restart mysql.
> 
> All other lookups seem to work decently, only the "lookup an ip" stalls
> the machine.
> 
> I've seen posts for the GET_LOCK issue but without a solution ... Does
> anyone has a clue where I should start looking?
> 
> Thanks in advance,
> 
> Koen
> 
> 
> -- 
> Koen Van Impe - BELNET CERT
> koen.vanimpe at belnet.be
> PGP Key Id 0xED12AD79
> Contact: http://cert.belnet.be/
> 
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com

--