[rt-users] Slow RTIR

[Koen Van Impe]

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)

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/