[rt-devel] Re: [rt-users] RT 3.0.3 - severe problems in web frontend

[Harald Wagener]

On Wed, Jun 25, 2003 at 10:36:47AM +0200, Harald Wagener wrote:
> Dear list, after seeing no grave error reports on 3.0.3, I decided to
> upgrade from 3.0.3pre1 (which ran fine except for some tickets setting
> up MySQL to run in an endless loop, resulting in an internal server
> error message from apache). 
[snip] 
> Upgrading MySQL from 4.0.12 to 4.0.13 improved system behavior (no
> mysqld eating up all available cpu time anymore), but still I get the
> internal server error. 

Depending on what I do, I still manage to get mysql to utilize 99.x
percent cpu time. mtop reports the query[1] to stick:

Now, after setting a query cache for MySQL, I can do the following:
Select 'Resolve' as action, wait for the internal server error and two
additional minutes, go 'back' in my browser, select 'Resolve' again and
everything works in subsecond time due to the query result being served
from the query_cache. 

So, how do I get MySQL up to speed again? Any hints are welcome. 

Regards,
    Harald Wagener

[1]
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 = 'OwnTicket')OR(ACL_5.RightName =
'SuperUser')) AND
     ((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled
= '0'))
     AND ((Principals_1.PrincipalType = 'User')) AND ((ACL_5.PrincipalId
=
     Principals_4.id AND Principals_4.id = Groups_3.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 = 5) OR (Groups_3.Domain =
     'RT::Ticket-Role' AND Groups_3.Instance = 4638)) AND Groups_3.Type
=
     ACL_5.PrincipalType AND Groups_3.id = Principals_4.id)) AND
     (ACL_5.ObjectType = 'RT::System' OR (ACL_5.ObjectType = 'RT::Queue'
AND
     ACL_5.ObjectId = 5)) 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