Slow RTIR

RT Users
1

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@belnet.be
PGP Key Id 0xED12AD79
Contact: http://cert.belnet.be/

2

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).

3

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.

[…]

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).

The problem was solved by upgrading to RT 3.8.7.

Thanks for the feedback,

koen

Koen Van Impe - BELNET CERT
koen.vanimpe@belnet.be
PGP Key Id 0xED12AD79
Contact: http://cert.belnet.be/