<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=376510610-11042005><FONT face=Arial color=#0000ff
size=2>Ian,</FONT></SPAN></DIV>
<DIV><SPAN class=376510610-11042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=376510610-11042005><FONT face=Arial color=#0000ff
size=2>1.mysql 4.0.18 </FONT></SPAN></DIV>
<DIV><SPAN class=376510610-11042005><FONT face=Arial color=#0000ff size=2>2.
DBIx::SearchBuilder ver 1.22<BR></FONT></DIV>
<DIV></SPAN><SPAN class=376510610-11042005></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Regards,</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=376510610-11042005>
Yoav</SPAN></FONT></FONT></FONT></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Norton, Ian
[mailto:i.norton@lancaster.ac.uk] <BR><B>Sent:</B> Monday, April 11, 2005 1:01
PM<BR><B>To:</B> Yoav Daniely; rt-users@lists.fsck.com<BR><B>Subject:</B> RE:
[rt-users] RT Hangs when removing users from group<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=380445909-11042005><FONT face=Arial
color=#0000ff size=2>Yoav,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=380445909-11042005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=380445909-11042005><FONT face=Arial
color=#0000ff size=2>What database are you using and which version of
SearchBuilder?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=380445909-11042005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=380445909-11042005><FONT face=Arial
color=#0000ff size=2>Regards, Ian.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Yoav
Daniely<BR><B>Sent:</B> 11 April 2005 09:14<BR><B>To:</B>
rt-users@lists.fsck.com<BR><B>Subject:</B> [rt-users] RT Hangs when removing
users from group<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial
size=2>Greetings,</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>I have an RT
installation version 3.4.1 that has been upgraded from rt
3.0.10.</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>I followed the
upgrade path as documents and everything seemed fine until I had to remove a
user from a group.</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>When I remove the
users httpd hangs on 80% CPU and I cannot access rt unless I restart
apache.</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>I enabled logging on
mysql and I get the following line when removing the user (in an endless
loop)</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2> 6
Query SELECT * FROM CachedGroupMembers
WHERE MemberId = '1' AND GroupId = '36' AND Disabled =
'0'<BR></FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>When I run this
query by hang I get an empty set.</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>other logs are
empty.</DIV></FONT></SPAN>
<DIV><SPAN class=319470908-11042005><FONT face=Arial size=2>Any Ideas?
</FONT></SPAN></DIV>
<DIV><SPAN class=319470908-11042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=319470908-11042005>Regards,</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=319470908-11042005> </SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=319470908-11042005>
Yoav Daniely.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=319470908-11042005></SPAN><SPAN
class=319470908-11042005> </DIV></SPAN></FONT></FONT></BODY></HTML>