[rt-users] RT 3.6.4 poor query performance

Ruslan Zakirov ruz at bestpractical.com
Tue Mar 18 17:02:05 EDT 2008 

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
>



-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: search_possible_owners.mysql.sql
Type: application/octet-stream
Size: 1567 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080319/5d1df760/attachment.obj>

More information about the rt-users mailing list