[rt-devel] RT 3.0rc1 - "Ticket Create" slow load issue RESOLVED

[Joseph W. Breu]

Still having the same problems here.  I went through the tables and made
sure that my indexes matched the indexes in the schema; no change.


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


> 3.0.0rc2 is now available.  I'd like to get at least one success report
> from someone who had issues with rc1 before announcing it to the masses.
>
> If you're upgrading from an earlier release candidate, you'll need to
> issue the following commands to mysql:
>
>
>  alter table CachedGroupMembers drop index CachedGroupMembers3;
>  alter table CachedGroupMembers drop index CachedGroupMembers4;