[rt-users] RT 3.6.4 poor query performance
Richard Ellis
Richard.Ellis at Sun.COM
Tue Mar 18 12:31:40 EDT 2008
Hi Jesse,
We are using 5.0.51a at the moment, because 5.0.34 was reported as
having issues in several posts on the forum and an upgrade recommended.
Richard
Jesse Vincent wrote:
>
> 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
>>
--
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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080318/41abb8f3/attachment.htm>
More information about the rt-users
mailing list