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.vani...@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
