[rt-users] RT 3.6 performance problems

[Jesse Vincent]

On Thu, Aug 24, 2006 at 05:50:53PM +0200, Theo Kramer wrote:
> > > But I do not know what RT does by default when a ticket is created on
> > > receipt of an email - ie. does it set OwnTicket even if the permissions
> > > are set as above?
> > 
> > It should not.
> 
> Hmmm - perhaps some history would be useful
> 
> Our system was migrated from RT 2 to RT 3.0.2 which we are currently
> running. The problem occurs when trying to upgrade to RT 3.4.[4-5] -
> tried both.
> 
> I decided to do some testing by submitting a ticket from a non existent
> user via email to our upgrade test system running 3.4.5. 
> 
> I executed the following query (as derived from the mysql logs)
> 
> SELECT COUNT(DISTINCT main.Name) FROM 
>   Users main, 
>   Principals Principals_1,
>   ACL ACL_2,
>   CachedGroupMembers CachedGroupMembers_3
> WHERE ((ACL_2.PrincipalId = CachedGroupMembers_3.GroupId)) 
>   AND ((ACL_2.PrincipalType = 'Group')) 
>   AND ((ACL_2.RightName = 'OwnTicket'))
>   AND ((CachedGroupMembers_3.MemberId = Principals_1.id)) 
>   AND ((Principals_1.Disabled = '0')) 
>   AND ((Principals_1.PrincipalType = 'User')) 
>   AND ((Principals_1.id != '1'))
>   AND ((main.id = Principals_1.id))
>   AND ((ACL_2.ObjectType = 'RT::Queue') OR 
>        (ACL_2.ObjectType = 'RT::System'));
> 
> The value returned before emailing the new ticket was 97602 and after
> sending a new ticket from an arbitrary new email address it went up to
> 97603...
> 
> This with the permissions as above.
> 
> I then decided to do the same with RT 3.6.1 but with an empty database.
> Before emailing a ticket the value returned was 1 (user Nobody), and
> after emailing a ticket the value returned was still 1.

Yes. That's saying the same thing as "the owner dropdown has too many
people in it"

> 
> So this now raises the following question
> 
> Is it possible that somehow permissions for Everyone includes
> 'OwnTicket' but is not visible via the configuration interface? 

I suspect, but can't prove, that you're just not looking in the right
place.

Send this to the list:

SELECT * FROM ACL WHERE RightName = 'OwnTicket';