RT 3.6 performance problems

Jesse_Vincent · September 11, 2006, 10:32am

Ok. Via RT’s webui, what rights does the “Everyone” group have on your
Testing queue?On Mon, Sep 11, 2006 at 09:31:25AM +0200, Theo Kramer wrote:

Apologies for the length of time in responding on this - been away for a
while.

SELECT * FROM ACL WHERE RightName = ‘OwnTicket’;
| 123 | Group | 3 | OwnTicket | RT::Queue | 13 | 0 | 0 |
SELECT * from Groups where id = 3;
| 3 | | Pseudogroup for internal use | SystemInternal | Everyone | 0 |

select Name,Created,LastUpdated,Disabled from Queues where id = 13;
| testing | 2001-10-03 06:46:42 | 2002-03-04 10:16:24 | 1 |

Theo_Kramer · September 11, 2006, 11:19am

Ok. Via RT’s webui, what rights does the “Everyone” group have on your
Testing queue?

Selecting Configuration → Queues I get the following (after enabling
‘Include disabled queues in listing’)

accounts
- ect
- ect-bounce
- ect-comments
- faxin
- form 5
- legal
- messages
- support
- techsupport
- testing
- testq
- TestQ1
- ___Approvals

Then selecting testing and viewing Group Rights I see that System Group
‘Everyone’ has ‘OwnTicket’ enabled…

So the problem appears due to a disabled Queue having the OwnTicket
right for EveryOne …

Re-ran the query and now instead of 100000+ lines I get 21 lines

Very much appreciated - many thanks.> On Mon, Sep 11, 2006 at 09:31:25AM +0200, Theo Kramer wrote:

Apologies for the length of time in responding on this - been away for a
while.

SELECT * FROM ACL WHERE RightName = ‘OwnTicket’;
| 123 | Group | 3 | OwnTicket | RT::Queue | 13 | 0 | 0 |
SELECT * from Groups where id = 3;
| 3 | | Pseudogroup for internal use | SystemInternal | Everyone | 0 |

select Name,Created,LastUpdated,Disabled from Queues where id = 13;
| testing | 2001-10-03 06:46:42 | 2002-03-04 10:16:24 | 1 |

Regards
Theo

Jackie_Hamilton · September 13, 2006, 10:13pm

Sorry to rehash this thread, but I’m still having trouble with the Tickets page having all 150K+ users in the “Owner” pull down, rendering the page unusable. I downgraded our MySQL to 4.1.21, so I know it’s not a MySQL 5.0 issue.

I’ve reviewed the previous thread where another user was having this problem. I’m not clear on the solution though. In Theo’s case it looked like it was related to a disabled queue having OwnTicket rights. However, none of the queues on my system are disabled:

mysql> SELECT | id | PrincipalType | 2 | Group | | 19 | Group | 37 | Group | 64 | Group | 63 | Group | 65 | Group | 104 | Group | 103 | Group | 130 | Group | 154 | Group | 155 | Group | 156 | Group | 183 | Group | 203 | Group | 220 | Group | | 221 | Group | 244 | Group | 265 | Group 18 rows in set (0.00 sec) * FROM ACL WHERE RightName = ‘OwnTicket’ order by ObjectId;
| PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
11 | OwnTicket | RT::System | 1 | 0 | 0 |
| 332274 | OwnTicket | RT::Queue | 3 | 0 | 0 |
| 332273 | OwnTicket | RT::Queue | 4 | 0 | 0 |
| 193983 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 203501 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 294765 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 217313 | OwnTicket | RT::Queue | 6 | 0 | 0 |
| 332274 | OwnTicket | RT::Queue | 6 | 0 | 0 |
| 332273 | OwnTicket | RT::Queue | 8 | 0 | 0 |
| 332275 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 179139 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 203501 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 332276 | OwnTicket | RT::Queue | 10 | 0 | 0 |
| 332277 | OwnTicket | RT::Queue | 11 | 0 | 0 |
3 | OwnTicket | RT::Queue | 12 | 0 | 0 |
| 332273 | OwnTicket | RT::Queue | 12 | 0 | 0 |
| 332278 | OwnTicket | RT::Queue | 13 | 0 | 0 |
| 294765 | OwnTicket | RT::Queue | 15 | 0 | 0 |

mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in (1,3,4,5,6,7,9,10,11,12,13,15);
| id | Name | Created | LastUpdated | Disabled |
| 3 | backlog | 2003-11-07 00:14:17 | 2003-11-07 00:14:17 | 0 |
| 4 | general | 2002-09-09 13:13:55 | 2002-09-12 06:53:25 | 0 |
| 5 | inventory | 2004-10-12 13:58:14 | 2004-10-12 13:58:14 | 0 |
| 6 | it | 2003-01-10 02:09:41 | 2003-01-10 02:09:41 | 0 |
| 7 | jobs | 2006-06-01 15:15:44 | 2006-06-01 15:15:44 | 0 |
| 9 | ops | 2003-01-10 02:10:16 | 2003-01-10 02:10:16 | 0 |
| 10 | pr | 2003-01-10 02:02:30 | 2003-01-10 02:02:30 | 0 |
| 11 | promotions | 2003-03-06 13:35:56 | 2003-03-06 13:35:56 | 0 |
| 12 | research | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 | 0 |
| 13 | sales | 2003-01-07 12:59:26 | 2003-01-08 16:58:23 | 0 |
| 15 | suggest | 2005-08-12 14:16:21 | 2005-08-12 14:18:11 | 0 |
11 rows in set (0.00 sec)

How do I fix this so the “Owner” list doesn’t consist of every user in the db? What should I be looking for, here?

Thanks,

– Jackie Hamilton
kira@lightsphere.com

Jesse_Vincent · September 13, 2006, 10:15pm

I’m betting it’s your “research” queue.On Wed, Sep 13, 2006 at 05:13:54PM -0500, Jackie Hamilton wrote:

Sorry to rehash this thread, but I’m still having trouble with the Tickets page having all 150K+ users in the “Owner” pull down, rendering the page unusable. I downgraded our MySQL to 4.1.21, so I know it’s not a MySQL 5.0 issue.

I’ve reviewed the previous thread where another user was having this problem. I’m not clear on the solution though. In Theo’s case it looked like it was related to a disabled queue having OwnTicket rights. However, none of the queues on my system are disabled:

mysql> SELECT * FROM ACL WHERE RightName = ‘OwnTicket’ order by ObjectId;
±----±--------------±------------±----------±-----------±---------±------------±--------------+
| id | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
±----±--------------±------------±----------±-----------±---------±------------±--------------+
| 2 | Group | 11 | OwnTicket | RT::System | 1 | 0 | 0 |
| 19 | Group | 332274 | OwnTicket | RT::Queue | 3 | 0 | 0 |
| 37 | Group | 332273 | OwnTicket | RT::Queue | 4 | 0 | 0 |
| 64 | Group | 193983 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 63 | Group | 203501 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 65 | Group | 294765 | OwnTicket | RT::Queue | 5 | 0 | 0 |
| 104 | Group | 217313 | OwnTicket | RT::Queue | 6 | 0 | 0 |
| 103 | Group | 332274 | OwnTicket | RT::Queue | 6 | 0 | 0 |
| 130 | Group | 332273 | OwnTicket | RT::Queue | 8 | 0 | 0 |
| 154 | Group | 332275 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 155 | Group | 179139 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 156 | Group | 203501 | OwnTicket | RT::Queue | 9 | 0 | 0 |
| 183 | Group | 332276 | OwnTicket | RT::Queue | 10 | 0 | 0 |
| 203 | Group | 332277 | OwnTicket | RT::Queue | 11 | 0 | 0 |
| 220 | Group | 3 | OwnTicket | RT::Queue | 12 | 0 | 0 |
| 221 | Group | 332273 | OwnTicket | RT::Queue | 12 | 0 | 0 |
| 244 | Group | 332278 | OwnTicket | RT::Queue | 13 | 0 | 0 |
| 265 | Group | 294765 | OwnTicket | RT::Queue | 15 | 0 | 0 |
±----±--------------±------------±----------±-----------±---------±------------±--------------+
18 rows in set (0.00 sec)

mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in (1,3,4,5,6,7,9,10,11,12,13,15);
±—±-----------±--------------------±--------------------±---------+
| id | Name | Created | LastUpdated | Disabled |
±—±-----------±--------------------±--------------------±---------+
| 3 | backlog | 2003-11-07 00:14:17 | 2003-11-07 00:14:17 | 0 |
| 4 | general | 2002-09-09 13:13:55 | 2002-09-12 06:53:25 | 0 |
| 5 | inventory | 2004-10-12 13:58:14 | 2004-10-12 13:58:14 | 0 |
| 6 | it | 2003-01-10 02:09:41 | 2003-01-10 02:09:41 | 0 |
| 7 | jobs | 2006-06-01 15:15:44 | 2006-06-01 15:15:44 | 0 |
| 9 | ops | 2003-01-10 02:10:16 | 2003-01-10 02:10:16 | 0 |
| 10 | pr | 2003-01-10 02:02:30 | 2003-01-10 02:02:30 | 0 |
| 11 | promotions | 2003-03-06 13:35:56 | 2003-03-06 13:35:56 | 0 |
| 12 | research | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 | 0 |
| 13 | sales | 2003-01-07 12:59:26 | 2003-01-08 16:58:23 | 0 |
| 15 | suggest | 2005-08-12 14:16:21 | 2005-08-12 14:18:11 | 0 |
±—±-----------±--------------------±--------------------±---------+
11 rows in set (0.00 sec)

How do I fix this so the “Owner” list doesn’t consist of every user in the db? What should I be looking for, here?

Thanks,

– Jackie Hamilton
kira@lightsphere.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Joby_Walker · September 13, 2006, 10:36pm

Jackie Hamilton wrote:

mysql> SELECT * FROM ACL WHERE RightName = ‘OwnTicket’ order by ObjectId;
±----±--------------±------------±----------±-----------±---------±------------±--------------+
| id | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
±----±--------------±------------±----------±-----------±---------±------------±--------------+
| 220 | Group | 3 | OwnTicket | RT::Queue | 12 | 0 | 0 |
±----±--------------±------------±----------±-----------±---------±------------±--------------+

mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in (1,3,4,5,6,7,9,10,11,12,13,15);
±—±-----------±--------------------±--------------------±---------+
| id | Name | Created | LastUpdated | Disabled |
±—±-----------±--------------------±--------------------±---------+
| 12 | research | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 | 0 |
±—±-----------±--------------------±--------------------±---------+
How do I fix this so the “Owner” list doesn’t consist of every user in the db? What should I be looking for, here?

This is your problem. You have given “Everyone” (Principal id 3) the
right to own ticket in the research queue.

Joby Walker
C&C SSG, University of Washington

Jackie_Hamilton · September 13, 2006, 10:49pm

I’m betting it’s your “research” queue.

Ok. I deleted that record from the ACL table, it fixes the problem:

| 220 | Group | 3 | OwnTicket | RT::Queue | 12 | 0 | 0 |

I see that group id 3 is “Everyone”, so that’s why it was causing the problem.

Thanks!

– Jackie Hamilton
kira@lightsphere.com