[rt-devel] problem with rt3-rc1, 'Reply' to a ticket, and slow mysql query...

[Joseph W. Breu]

With RT3 RC1, replying to a ticket creates a slow query on the mysql server:

SELECT DISTINCT main.* FROM Users main, Principals Principals_1,
CachedGroupMembers CachedGroupMembers_2, Groups Groups_3, Principals
Principals_4, ACL ACL_5, CachedGroupMembers CachedGroupMembers_6   WHERE
((ACL_5.RightName = 'SuperUser')OR(ACL_5.RightName = 'OwnTicket')) AND
((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled = '0'))
AND ((Principals_1.PrincipalType = 'User')) AND (ACL_5.ObjectType =
'RT::System'  OR (ACL_5.ObjectType = 'RT::Queue'  AND ACL_5.ObjectId =
'9') ) AND ( Principals_4.id = Groups_3.id  AND (ACL_5.PrincipalId =
Principals_4.Id  AND ACL_5.PrincipalType = 'Group' AND (Groups_3.Domain =
'SystemInternal' OR Groups_3.Domain = 'UserDefined' OR Groups_3.Domain =
'ACLEquivalence'))  OR ( ( (Groups_3.Domain = 'RT::Queue-Role' AND
Groups_3.Instance = '9')  OR ( Groups_3.Domain = 'RT::Ticket-Role' AND
Groups_3.Instance = '3222')  )  AND Groups_3.Type = ACL_5.PrincipalType
AND Principals_4.PrincipalType = 'Group') )  AND main.id = Principals_1.id
 AND Principals_1.id = CachedGroupMembers_2.MemberId  AND
CachedGroupMembers_6.MemberId = Principals_1.Id  AND
CachedGroupMembers_6.GroupId = Principals_4.Id  ORDER BY main.Name ASC


The application pauses for almost 5 minutes before the query completes and
the reply screen comes up.

Latest modules and mysql 3.23.54 on a redhat 7.3 machine.  This only
started to happen when I went to 3.0 rc1.  We were running a 3.0 beta
before.


-- 
Thanks,

---------------------------------------------------------
Joseph W. Breu, CCNA             fax : +1.319.266.8158
Senior Network Administrator     url : http://www.cfu.net
Cedar Falls Utilities

                question = ( to ) ? be : ! be;
		              -- Wm. Shakespeare