[rt-users] Slow Query when Displaying "Owners" dropdown (Query Builder, Reply, etc.)

[mark matyas]

Hi Jesse,
Thanks for responding. Before I got your email I decided to go ahead and 
try 3.5.6 for the heck of it, and it seems to have fixed the problem. I 
really like 3.5.6 actually  especially the WebUI and Simple Search. I 
have another problem now though.
Myspecs: RT 3.5.6 + apache 2 + fastcgi + + mysql 4.1 + HTML::Mason 
v1.3101 + DBI v1.48 + DBIx::SearchBuilder v1.36;
The only problem now though is that I get alot of the following errors 
in my apache log:
[Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Fri Dec 30 07:12:13 
2005] [err]: Couldn't load  from the users database. 
(/opt/rt3/lib/RT/CurrentUser.pm:146)
[Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized 
value in concatenation (.) or string at 
/opt/rt3/lib/RT/Principal_Overlay.pm line 425.
[Thu Dec 29 23:12:13 2005] [error] [client 64.233.172.40] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Fri Dec 30 07:12:13 
2005] [err]: Couldn't load  from the users database. 
(/opt/rt3/lib/RT/CurrentUser.pm:146)
[Thu Dec 29 23:12:13 2005] [error] [client 64.233.172.40] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized 
value in concatenation (.) or string at 
/opt/rt3/lib/RT/Principal_Overlay.pm line 425.
[Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute 
failed: You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'AND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR 
(ACL.ObjectType = '' at line 1 at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 493.
[Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI: 
server "/opt/rt3/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0xaabfb6c) couldn't execute the query 'SELECT ACL.id 
from ACL, Groups, Principals, CachedGroupMembers WHERE  (ACL.RightName = 
'SuperUser' OR  ACL.RightName = 'ModifySelf') AND Principals.Disabled = 
0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND 
Principals.PrincipalType = 'Group' AND Principals.id = 
CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId =  AND 
((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType 
= 'RT::System')) AND ACL.PrincipalId = Principals.id AND 
ACL.PrincipalType = 'Group'  LIMIT 1' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 506


what could this be? should I downgrade or upgrade a certain perl module? 
I would really like to keep using 3.5.6 if possible. should i downgrade RT?
Thanks for your help,
mark matyas

Jesse Vincent wrote:
> 
> 
> On Wed, Dec 28, 2005 at 03:16:09PM -0800, mark matyas wrote:
> 
>>Hello RT Users,
>>
>>We just upgraded from RT 3.0 to 3.4.4 and everything went fine expect 
>>for one thing:
>>There is a specific query that takes more than 50 Seconds and is 
>>executed frequently as the results of the Query seems to be the list of 
>>Owners in the Drop down menu for the Query Builder page or When 
>>Selecting Reply, etc. So when a user clicks on the Query Builder it 
>>takes 50 seconds, making it very hard to use sometimes.
> 
> 
> 
> Mark, 
> 
> Can you please test out RT 3.4.5RC2 to see if it solves your performance
> problem? We spent about half a man week working on just that for this
> release.
> 
> Jesse