[rt-users] RT 3.6.4 poor query performance

Jesse Vincent jesse at bestpractical.com
Tue Mar 18 12:28:40 EDT 2008


[Please keep ccing the list. Free support is a lot more valuable when  
the community's involved]

What version of mysql is this again?

My explain output looks like this:

+----------------------+--------+----------------------------- 
+---------+---------+-------------------------------+------ 
+-----------------------------------------------------------+
| table                | type   | possible_keys               |  
key     | key_len | ref                           | rows |  
Extra                                                     |
+----------------------+--------+----------------------------- 
+---------+---------+-------------------------------+------ 
+-----------------------------------------------------------+
| Groups_3             | ref    | PRIMARY,Groups1,Groups2     |  
Groups1 |      65 | const                         |  108 | Using  
where; Using index; Using temporary; Using filesort |
| CachedGroupMembers_2 | ref    | DisGrouMem,GrouMem,MemberId |  
GrouMem |       5 | Groups_3.id                   |    1 | Using  
where; Using index                                  |
| Principals_1         | eq_ref | PRIMARY                     |  
PRIMARY |       4 | CachedGroupMembers_2.MemberId |    1 | Using  
where                                               |
| ACL_4                | range  | ACL1                        |  
ACL1    |      50 | NULL                          |   36 | Using  
where; Using index                                  |
| main                 | eq_ref | PRIMARY,Users3              |  
PRIMARY |       4 | Principals_1.id               |    1  
|                                                           |
+----------------------+--------+----------------------------- 
+---------+---------+-------------------------------+------ 
+-----------------------------------------------------------+

You'll note that it's starting on the Groups table rather than the  
Users table, which I suspect is a lot less expensive (and yes, we have  
a smaller RT database than you)

I sort of wonder whether that "member1" key is causing your RT to make  
a bad call about join ordering.




On Mar 18, 2008, at 12:21 PM, Richard Ellis wrote:
> Database changed
> mysql> EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL  
> ACL_4 JOIN
>   -> Principals Principals_1  ON ( Principals_1.id = main.id ) JOIN
>   -> CachedGroupMembers CachedGroupMembers_2  ON (
>   -> CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups  
> Groups_3
>   -> ON ( Groups_3.id = CachedGroupMembers_2.GroupId )  WHERE
>   -> (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType =  
> Groups_3.Type)
>   -> AND (Principals_1.id != '1') AND (Principals_1.PrincipalType =  
> 'User')
>   -> AND (ACL_4.RightName = 'OwnTicket') AND (Groups_3.Domain =
>   -> 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR
>   -> (ACL_4.ObjectType = 'RT::System'))  ORDER BY main.Name ASC;
> +----+-------------+----------------------+-------- 
> +-----------------------------------+---------+--------- 
> +----------------------------------+------ 
> +----------------------------------------------+
> | id | select_type | table                | type   |  
> possible_keys        | key     | key_len |  
> ref                              | rows |  
> Extra                                     |
> +----+-------------+----------------------+-------- 
> +-----------------------------------+---------+--------- 
> +----------------------------------+------ 
> +----------------------------------------------+
> |  1 | SIMPLE      | main                 | range  |  
> PRIMARY,Users3        | PRIMARY | 4       |  
> NULL                             | 1378 | Using where; Using  
> temporary; Using filesort |
> |  1 | SIMPLE      | Principals_1         | eq_ref | PRIMARY         
> | PRIMARY | 4       | rt3.main.id                      |    1 |  
> Using where; Distinct                        |
> |  1 | SIMPLE      | CachedGroupMembers_2 | ref    |  
> DisGrouMem,GrouMem,group1,member1 | member1 | 5       |  
> rt3.Principals_1.id              |    1 | Using where;  
> Distinct                        |
> |  1 | SIMPLE      | ACL_4                | range  | ACL1        |  
> ACL1    | 54      | NULL                             |  296 | Using  
> where; Using index; Distinct           |
> |  1 | SIMPLE      | Groups_3             | eq_ref |  
> PRIMARY,Groups1,Groups2        | PRIMARY | 4       |  
> rt3.CachedGroupMembers_2.GroupId |    1 | Using where;  
> Distinct                        |
> +----+-------------+----------------------+-------- 
> +-----------------------------------+---------+--------- 
> +----------------------------------+------ 
> +----------------------------------------------+
> 5 rows in set (0.01 sec)
>
> mysql>
>
>
> Is this giving you a clue where the problem is? Didn't think their  
> were 15 million rows of data, their are only 10,000 tickets in total.
>
> Jesse Vincent wrote:
>> So, you have a query that ran for 400+ seconds an examined fifteen
>> million rows. That seems..wrong. What does this say?
>>
>> EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4  
>> JOIN
>> Principals Principals_1  ON ( Principals_1.id = main.id ) JOIN  
>> CachedGroupMembers CachedGroupMembers_2  ON (
>> CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups  
>> Groups_3  ON ( Groups_3.id = CachedGroupMembers_2.GroupId )  WHERE  
>> (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType =  
>> Groups_3.Type) AND (Principals_1.id != '1') AND  
>> (Principals_1.PrincipalType = 'User')  AND (ACL_4.RightName =  
>> 'OwnTicket') AND (Groups_3.Domain =  'RT::Queue-Role') AND  
>> ((ACL_4.ObjectType = 'RT::Queue') OR  (ACL_4.ObjectType =  
>> 'RT::System'))  ORDER BY main.Name ASC;
>>
>>
>> On Tue, Mar 18, 2008 at 04:10:19PM +0000, Richard Ellis wrote:
>>
>>> Hi Jesse,
>>>
>>> The output of the slow query log for the last 23 hours:
>>>
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 6  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
>>> use rt3;
>>> SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',  
>>> 3600);
>>> # Time: 080317 12:17:03
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 6  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
>>> SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',  
>>> 3600);
>>> # Time: 080317 12:17:47
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 8  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
>>> SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',  
>>> 3600);
>>> # Time: 080317 13:07:11
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 411  Lock_time: 0  Rows_sent: 0  Rows_examined:  
>>> 15418603
>>> SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN  
>>> Principals Principals_1  ON ( Principals_1.id = main.id ) JOIN  
>>> CachedGroupMembers CachedGroupMembers_2  ON  
>>> ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups  
>>> Groups_3  ON ( Groups_3.id = CachedGroupMembers_2.GroupId )  WHERE  
>>> (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType =  
>>> Groups_3.Type) AND (Principals_1.id != '1') AND  
>>> (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName =  
>>> 'OwnTicket') AND (Groups_3.Domain = 'RT::Queue-Role') AND  
>>> ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType =  
>>> 'RT::System'))  ORDER BY main.Name ASC;
>>> # Time: 080317 13:07:13
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 46  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
>>> SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551',  
>>> 3600);
>>> # User at Host: rt_user[rt_user] @ localhost []
>>> # Query_time: 346  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
>>> SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551',  
>>> 3600);
>>>
>>> Thanks
>>>
>>> Richard
>>>
>>> Jesse Vincent wrote:
>>>
>>>> Sounds like someone previously changed the config file without
>>>> restarting.
>>>>
>>>>
>>>> On Mon, Mar 17, 2008 at 05:22:52PM +0000, Richard Ellis wrote:
>>>>
>>>>> Looks like theres a problem with the logfile
>>>>>
>>>>> 080317 10:04:58  mysqld started
>>>>> InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of  
>>>>> different size 0 5242880 bytes
>>>>> InnoDB: than specified in the .cnf file 0 16777216 bytes!
>>>>> 080317 10:04:59 [Note] /usr/local/mysql/bin/mysqld: ready for  
>>>>> connections.
>>>>> Version: '5.0.51a-log'  socket: '/tmp/mysql.sock'  port: 3306   
>>>>> MySQL Community Server (GPL)
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ACL.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ACL.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Attachments.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Attachments.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Attributes.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Attributes.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/CustomFieldValues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/CustomFieldValues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/CustomFields.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/CustomFields.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Groups.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Groups.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Links.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Links.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ObjectCustomFieldValues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ObjectCustomFieldValues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Principals.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Principals.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Queues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Queues.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ScripActions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ScripActions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ScripConditions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/ScripConditions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Scrips.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Scrips.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Templates.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Templates.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Tickets.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Tickets.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Transactions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Transactions.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect  
>>>>> information in file: './rt3/Users.frm'
>>>>> 080317 10:16:25 [Note] /usr/local/mysql/bin/mysqld: Normal  
>>>>> shutdown
>>>>>
>>>>> 080317 10:16:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown  
>>>>> complete
>>>>>
>>>>> 080317 10:16:27  mysqld ended
>>>>>
>>>>>
>>>>>
>>>>> Jesse Vincent wrote:
>>>>>
>>>>>> Note that mysqlcheck WILL report corruption if the database is  
>>>>>> being accessed.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mar 17, 2008, at 1:13 PM, Richard Ellis wrote:
>>>>>>
>>>>>>
>>>>>>> Restarted to apply that change and now it looks like the  
>>>>>>> database has gone bang.
>>>>>>>
>>>>>>> gpsummit# /usr/local/mysql/bin/safe_mysqld &
>>>>>>> [2] 6970
>>>>>>> gpsummit# Starting mysqld daemon with databases from /usr/ 
>>>>>>> local/mysql/data
>>>>>>>
>>>>>>> gpsummit# mysqlcheck rt3
>>>>>>> rt3.ACL
>>>>>>> Error    : Incorrect information in file: './rt3/ACL.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Attachments
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> Attachments.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Attributes
>>>>>>> Error    : Incorrect information in file: './rt3/Attributes.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.CachedGroupMembers
>>>>>>> Error    : Can't find file: 'CachedGroupMembers' (errno: 2)
>>>>>>> error    : Corrupt
>>>>>>> rt3.CustomFieldValues
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> CustomFieldValues.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.CustomFields
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> CustomFields.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.GroupMembers
>>>>>>> Error    : Can't find file: 'GroupMembers' (errno: 2)
>>>>>>> error    : Corrupt
>>>>>>> rt3.Groups
>>>>>>> Error    : Incorrect information in file: './rt3/Groups.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Links
>>>>>>> Error    : Incorrect information in file: './rt3/Links.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.ObjectCustomFieldValues
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> ObjectCustomFieldValues.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.ObjectCustomFields
>>>>>>> Error    : Can't find file: 'ObjectCustomFields' (errno: 2)
>>>>>>> error    : Corrupt
>>>>>>> rt3.Principals
>>>>>>> Error    : Incorrect information in file: './rt3/Principals.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Queues
>>>>>>> Error    : Incorrect information in file: './rt3/Queues.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.ScripActions
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> ScripActions.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.ScripConditions
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> ScripConditions.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Scrips
>>>>>>> Error    : Incorrect information in file: './rt3/Scrips.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Templates
>>>>>>> Error    : Incorrect information in file: './rt3/Templates.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Tickets
>>>>>>> Error    : Incorrect information in file: './rt3/Tickets.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Transactions
>>>>>>> Error    : Incorrect information in file: './rt3/ 
>>>>>>> Transactions.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.Users
>>>>>>> Error    : Incorrect information in file: './rt3/Users.frm'
>>>>>>> error    : Corrupt
>>>>>>> rt3.sessions
>>>>>>>
>>>>>>> I am so pooched now. No idea if this is recoverable or not.
>>>>>>>
>>>>>>> Rik
>>>>>>>
>>>>>>> Jesse Vincent wrote:
>>>>>>>
>>>>>>>> On Mar 17, 2008, at 12:26 PM, Richard Ellis wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>> mysql> SELECT * from ACL, CachedGroupMembers, Groups where  
>>>>>>>>> ACL.RightName = 'OwnTicket' and ACL.PrincipalId = Groups.id  
>>>>>>>>> and Groups.id = CachedGroupMembers.GroupId;
>>>>>>>>>
>>>>>>>> Ok. Those results tell me there should be 290 names in your  
>>>>>>>> "SelectOwner" drop down. (That's a lot, but not enough that  
>>>>>>>> you should see 400s perf ;)
>>>>>>>>
>>>>>>>> Do you have mysql logging slow queries? If not, can you?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>> -- 
>>>>>>>
>>>>>>> Richard Ellis
>>>>>>> Technical Developer, .Sun eBusiness
>>>>>>>
>>>>>>> Sun Microsystems, Inc.
>>>>>>> Phone x(70) 24727/+44-1252-424 727
>>>>>>> Fax +44 1252 420410
>>>>>>> Email richard.ellis at Sun.COM
>>>>>>>
>>>>>>>
>>>>> -- 
>>>>> Sun.com <http://www.sun.com> 	* Richard Ellis *
>>>>> Technical Developer, .Sun eBusiness
>>>>>
>>>>> *Sun Microsystems, Inc.*
>>>>> Phone x(70) 24727/+44-1252-424 727
>>>>> Fax +44 1252 420410
>>>>> Email richard.ellis at Sun.COM
>>>>> 	sun.com
>>>>>
>>>>>
>>>>
>>> -- 
>>> Sun.com <http://www.sun.com> 	* Richard Ellis *
>>> Technical Developer, .Sun eBusiness
>>>
>>> *Sun Microsystems, Inc.*
>>> Phone x(70) 24727/+44-1252-424 727
>>> Fax +44 1252 420410
>>> Email richard.ellis at Sun.COM
>>> 	sun.com
>>>
>>>
>>
>>
>
> -- 
> Sun.com <http://www.sun.com> 	* Richard Ellis *
> Technical Developer, .Sun eBusiness
>
> *Sun Microsystems, Inc.*
> Phone x(70) 24727/+44-1252-424 727
> Fax +44 1252 420410
> Email richard.ellis at Sun.COM
> 	sun.com
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080318/b35aa6c2/attachment.sig>


More information about the rt-users mailing list