[rt-users] Unchecking "Let this user be granted rights" results in hang

[Carl Makin]

Hi Jesse, Peter,

Jesse Vincent wrote:

>Peter wrote...
>  
>
>>Easiest way to reproduce: Toggle "Let this user be granted rights". 
>>Some other administrative tasks also cause it to hang.
>>
>>Symptoms: Apache child process is using all cpu, slowly eating all memory.
>>
>>Associated rt.log entry is:
>>[Mon Sep 12 18:42:07 2005] [warning]: Deep recursion on subroutine 
>>"RT::ACE::_Value" at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 425.
>>(/usr/share/request-tracker3.4/lib/RT.pm:277)
>>    
>>
I'm not seeing that particular message although everything else is the same.

MySQL was showing heavy traffic but a light load and RT seemed to be 
executing the following query in a tight loop;

SELECT  * FROM CachedGroupMembers WHERE Disabled = '0' AND GroupId = '4' 
AND MemberId = '1'

This returns an empty set.  There are no records in that table with a 
MemberId of 1.

When I kill the MySQL thread I get a heap of;

[Wed Sep 14 00:40:21 2005] [err]: ACE 109 couldn't load its principal 
object (/usr/local/rt3/lib/RT/ACE_Overlay.pm:839)

in rt.log.

>
>
>Ok. Now we're getting somewhere. In RT::ACE::_Value, add a Carp::cluck;
>
>That will tell us _how_ it's recurring. then it should be a 30 second
>fix.
>  
>
[Wed Sep 14 11:28:13 2005] [error] [client 10.0.100.18] FastCGI: server 
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: 
\tDBIx::SearchBuilder::Record::__ANON__('RT::ACE=HASH(0x8cc60a0)') 
called at /usr/local/rt3/lib/RT/ACE_Overlay.pm line 815, referer: 
http://newton/Admin/Users/Modify.html?id=70
[Wed Sep 14 11:28:13 2005] [error] [client 10.0.100.18] FastCGI: server 
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: 
\tRT::ACE::Object('RT::ACE=HASH(0x8cc60a0)') called at 
/usr/local/rt3/lib/RT/ACE_Overlay.pm line 869, referer: 
http://newton/Admin/Users/Modify.html?id=70
[Wed Sep 14 11:28:13 2005] [error] [client 10.0.100.18] FastCGI: server 
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: 
\tRT::ACE::_Value('RT::ACE=HASH(0x8cc60a0)', 'ObjectType') called at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm line 
425, referer: http://newton/Admin/Users/Modify.html?id=70

I put the Carp::cluck into the _Value subroutine in ACE_Overlay.pm.

Is there anything more I can give you?

Carl.