[rt-users] RT 3.6.4 poor query performance

Richard Ellis Richard.Ellis at Sun.COM
Wed Mar 19 04:49:57 EDT 2008


Hi Ruslan,

Really appreciate the help on this. I'd love to find out why we are 
seeing such odd results:

298 ticket owners when their are only 88 active users
1.5 million rows of data when we only have 9983 ticks as of this morning.

Really odd

Thanks

Richard


Ruslan Zakirov wrote:
> Hello, Richard.
>
> Jesse asked me to look into this problem. Could you please run SQL
> commands from the attachment. It's a list of COUNT and EXPLAIN
> queries. I hope that will help us identify problems.
>
> On Tue, Mar 18, 2008 at 7:31 PM, Richard Ellis <Richard.Ellis at sun.com> wrote:
>   
>>  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
>>
>>
>>
>> --
>>
>>  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
>>
>> _______________________________________________
>>  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>>  Community help: http://wiki.bestpractical.com
>>  Commercial support: sales at bestpractical.com
>>
>>
>>  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>>  Buy a copy at http://rtbook.bestpractical.com
>>
>>     
>
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/2f59d4f9/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Search results.sql
Type: text/x-sql
Size: 5129 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/2f59d4f9/attachment.bin>


More information about the rt-users mailing list