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
29 Query SELECT
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
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,