<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jesse,<br>
<br>
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.<br>
<br>
Richard<br>
<br>
<br>
Jesse Vincent wrote:<br>
<blockquote
cite="mid:1379F0BA-F139-4A18-A669-AC9F37A86538@bestpractical.com"
type="cite"><br>
What version of mysql is this again?
<br>
<br>
My explain output looks like this:
<br>
<br>
+----------------------+--------+-----------------------------+---------+---------+-------------------------------+------+-----------------------------------------------------------+
<br>
| table | type | possible_keys | key
| key_len | ref | rows |
Extra |
<br>
+----------------------+--------+-----------------------------+---------+---------+-------------------------------+------+-----------------------------------------------------------+
<br>
| Groups_3 | ref | PRIMARY,Groups1,Groups2 | Groups1
| 65 | const | 108 | Using where; Using
index; Using temporary; Using filesort |
<br>
| CachedGroupMembers_2 | ref | DisGrouMem,GrouMem,MemberId | GrouMem
| 5 | Groups_3.id | 1 | Using where; Using
index |
<br>
| Principals_1 | eq_ref | PRIMARY | PRIMARY
| 4 | CachedGroupMembers_2.MemberId | 1 | Using
where |
<br>
| ACL_4 | range | ACL1 | ACL1
| 50 | NULL | 36 | Using where; Using
index |
<br>
| main | eq_ref | PRIMARY,Users3 | PRIMARY
| 4 | Principals_1.id | 1
| |
<br>
+----------------------+--------+-----------------------------+---------+---------+-------------------------------+------+-----------------------------------------------------------+
<br>
<br>
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)
<br>
<br>
I sort of wonder whether that "member1" key is causing your RT to make
a bad call about join ordering.
<br>
<br>
<br>
<br>
<br>
On Mar 18, 2008, at 12:21 PM, Richard Ellis wrote:
<br>
<blockquote type="cite">Database changed
<br>
mysql> EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL
ACL_4 JOIN
<br>
-> Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN
<br>
-> CachedGroupMembers CachedGroupMembers_2 ON (
<br>
-> CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups
Groups_3
<br>
-> ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE
<br>
-> (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType =
Groups_3.Type)
<br>
-> AND (Principals_1.id != '1') AND (Principals_1.PrincipalType =
'User')
<br>
-> AND (ACL_4.RightName = 'OwnTicket') AND (Groups_3.Domain =
<br>
-> 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR
<br>
-> (ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC;
<br>
+----+-------------+----------------------+--------+-----------------------------------+---------+---------+----------------------------------+------+----------------------------------------------+
<br>
| id | select_type | table | type |
possible_keys | key | key_len |
ref | rows |
Extra |
<br>
+----+-------------+----------------------+--------+-----------------------------------+---------+---------+----------------------------------+------+----------------------------------------------+
<br>
| 1 | SIMPLE | main | range |
PRIMARY,Users3 | PRIMARY | 4 |
NULL | 1378 | Using where; Using temporary;
Using filesort |
<br>
| 1 | SIMPLE | Principals_1 | eq_ref | PRIMARY |
PRIMARY | 4 | rt3.main.id | 1 | Using
where; Distinct |
<br>
| 1 | SIMPLE | CachedGroupMembers_2 | ref |
DisGrouMem,GrouMem,group1,member1 | member1 | 5 |
rt3.Principals_1.id | 1 | Using where;
Distinct |
<br>
| 1 | SIMPLE | ACL_4 | range | ACL1 |
ACL1 | 54 | NULL | 296 | Using
where; Using index; Distinct |
<br>
| 1 | SIMPLE | Groups_3 | eq_ref |
PRIMARY,Groups1,Groups2 | PRIMARY | 4 |
rt3.CachedGroupMembers_2.GroupId | 1 | Using where;
Distinct |
<br>
+----+-------------+----------------------+--------+-----------------------------------+---------+---------+----------------------------------+------+----------------------------------------------+
<br>
5 rows in set (0.01 sec)
<br>
<br>
mysql>
<br>
<br>
<br>
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.
<br>
<br>
Jesse Vincent wrote:
<br>
<blockquote type="cite">So, you have a query that ran for 400+
seconds an examined fifteen
<br>
million rows. That seems..wrong. What does this say?
<br>
<br>
EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4
JOIN
<br>
Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN
CachedGroupMembers CachedGroupMembers_2 ON (
<br>
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;
<br>
<br>
<br>
On Tue, Mar 18, 2008 at 04:10:19PM +0000, Richard Ellis wrote:
<br>
<br>
<blockquote type="cite">Hi Jesse,
<br>
<br>
The output of the slow query log for the last 23 hours:
<br>
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
<br>
use rt3;
<br>
SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',
3600);
<br>
# Time: 080317 12:17:03
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
<br>
SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',
3600);
<br>
# Time: 080317 12:17:47
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
<br>
SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e',
3600);
<br>
# Time: 080317 13:07:11
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 411 Lock_time: 0 Rows_sent: 0 Rows_examined: 15418603
<br>
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;
<br>
# Time: 080317 13:07:13
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 46 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
<br>
SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551',
3600);
<br>
# User@Host: rt_user[rt_user] @ localhost []
<br>
# Query_time: 346 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
<br>
SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551',
3600);
<br>
<br>
Thanks
<br>
<br>
Richard
<br>
<br>
Jesse Vincent wrote:
<br>
<br>
<blockquote type="cite">Sounds like someone previously changed
the config file without
<br>
restarting.
<br>
<br>
<br>
On Mon, Mar 17, 2008 at 05:22:52PM +0000, Richard Ellis wrote:
<br>
<br>
<blockquote type="cite">Looks like theres a problem with the
logfile
<br>
<br>
080317 10:04:58 mysqld started
<br>
InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of
different size 0 5242880 bytes
<br>
InnoDB: than specified in the .cnf file 0 16777216 bytes!
<br>
080317 10:04:59 [Note] /usr/local/mysql/bin/mysqld: ready for
connections.
<br>
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
Community Server (GPL)
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ACL.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ACL.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Attachments.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Attachments.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Attributes.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Attributes.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/CustomFieldValues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/CustomFieldValues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/CustomFields.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/CustomFields.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Groups.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Groups.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Links.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Links.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ObjectCustomFieldValues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ObjectCustomFieldValues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Principals.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Principals.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Queues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Queues.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ScripActions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ScripActions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ScripConditions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/ScripConditions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Scrips.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Scrips.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Templates.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Templates.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Tickets.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Tickets.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Transactions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Transactions.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect
information in file: './rt3/Users.frm'
<br>
080317 10:16:25 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
<br>
<br>
080317 10:16:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
<br>
<br>
080317 10:16:27 mysqld ended
<br>
<br>
<br>
<br>
Jesse Vincent wrote:
<br>
<br>
<blockquote type="cite">Note that mysqlcheck WILL report
corruption if the database is being accessed.
<br>
<br>
<br>
<br>
On Mar 17, 2008, at 1:13 PM, Richard Ellis wrote:
<br>
<br>
<br>
<blockquote type="cite">Restarted to apply that change
and now it looks like the database has gone bang.
<br>
<br>
gpsummit# /usr/local/mysql/bin/safe_mysqld &
<br>
[2] 6970
<br>
gpsummit# Starting mysqld daemon with databases from
/usr/local/mysql/data
<br>
<br>
gpsummit# mysqlcheck rt3
<br>
rt3.ACL
<br>
Error : Incorrect information in file: './rt3/ACL.frm'
<br>
error : Corrupt
<br>
rt3.Attachments
<br>
Error : Incorrect information in file: './rt3/Attachments.frm'
<br>
error : Corrupt
<br>
rt3.Attributes
<br>
Error : Incorrect information in file: './rt3/Attributes.frm'
<br>
error : Corrupt
<br>
rt3.CachedGroupMembers
<br>
Error : Can't find file: 'CachedGroupMembers' (errno: 2)
<br>
error : Corrupt
<br>
rt3.CustomFieldValues
<br>
Error : Incorrect information in file: './rt3/CustomFieldValues.frm'
<br>
error : Corrupt
<br>
rt3.CustomFields
<br>
Error : Incorrect information in file: './rt3/CustomFields.frm'
<br>
error : Corrupt
<br>
rt3.GroupMembers
<br>
Error : Can't find file: 'GroupMembers' (errno: 2)
<br>
error : Corrupt
<br>
rt3.Groups
<br>
Error : Incorrect information in file: './rt3/Groups.frm'
<br>
error : Corrupt
<br>
rt3.Links
<br>
Error : Incorrect information in file: './rt3/Links.frm'
<br>
error : Corrupt
<br>
rt3.ObjectCustomFieldValues
<br>
Error : Incorrect information in file:
'./rt3/ObjectCustomFieldValues.frm'
<br>
error : Corrupt
<br>
rt3.ObjectCustomFields
<br>
Error : Can't find file: 'ObjectCustomFields' (errno: 2)
<br>
error : Corrupt
<br>
rt3.Principals
<br>
Error : Incorrect information in file: './rt3/Principals.frm'
<br>
error : Corrupt
<br>
rt3.Queues
<br>
Error : Incorrect information in file: './rt3/Queues.frm'
<br>
error : Corrupt
<br>
rt3.ScripActions
<br>
Error : Incorrect information in file: './rt3/ScripActions.frm'
<br>
error : Corrupt
<br>
rt3.ScripConditions
<br>
Error : Incorrect information in file: './rt3/ScripConditions.frm'
<br>
error : Corrupt
<br>
rt3.Scrips
<br>
Error : Incorrect information in file: './rt3/Scrips.frm'
<br>
error : Corrupt
<br>
rt3.Templates
<br>
Error : Incorrect information in file: './rt3/Templates.frm'
<br>
error : Corrupt
<br>
rt3.Tickets
<br>
Error : Incorrect information in file: './rt3/Tickets.frm'
<br>
error : Corrupt
<br>
rt3.Transactions
<br>
Error : Incorrect information in file: './rt3/Transactions.frm'
<br>
error : Corrupt
<br>
rt3.Users
<br>
Error : Incorrect information in file: './rt3/Users.frm'
<br>
error : Corrupt
<br>
rt3.sessions
<br>
<br>
I am so pooched now. No idea if this is recoverable or not.
<br>
<br>
Rik
<br>
<br>
Jesse Vincent wrote:
<br>
<br>
<blockquote type="cite">On Mar 17, 2008, at 12:26 PM,
Richard Ellis wrote:
<br>
<br>
<br>
<blockquote type="cite">mysql> SELECT * from ACL,
CachedGroupMembers, Groups where ACL.RightName = 'OwnTicket' and
ACL.PrincipalId = Groups.id and Groups.id = CachedGroupMembers.GroupId;
<br>
<br>
</blockquote>
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 ;)
<br>
<br>
Do you have mysql logging slow queries? If not, can you?
<br>
<br>
<br>
<br>
</blockquote>
-- <br>
<br>
Richard Ellis
<br>
Technical Developer, .Sun eBusiness
<br>
<br>
Sun Microsystems, Inc.
<br>
Phone x(70) 24727/+44-1252-424 727
<br>
Fax +44 1252 420410
<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
<br>
<br>
<br>
</blockquote>
</blockquote>
-- <br>
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
<br>
Technical Developer, .Sun eBusiness
<br>
<br>
*Sun Microsystems, Inc.*
<br>
Phone x(70) 24727/+44-1252-424 727
<br>
Fax +44 1252 420410
<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
<br>
sun.com
<br>
<br>
<br>
</blockquote>
<br>
</blockquote>
-- <br>
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
<br>
Technical Developer, .Sun eBusiness
<br>
<br>
*Sun Microsystems, Inc.*
<br>
Phone x(70) 24727/+44-1252-424 727
<br>
Fax +44 1252 420410
<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
<br>
sun.com
<br>
<br>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
-- <br>
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
<br>
Technical Developer, .Sun eBusiness
<br>
<br>
*Sun Microsystems, Inc.*
<br>
Phone x(70) 24727/+44-1252-424 727
<br>
Fax +44 1252 420410
<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
<br>
sun.com
<br>
<br>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table border="0" cellpadding="0" cellspacing="0" width="519">
<tbody>
<tr valign="top">
<td height="121" width="98"><a href="http://www.sun.com"><img
moz-do-not-send="true" src="file://///home/re100941/6h_top.gif"
alt="Sun.com" border="0" height="92" width="98"></a></td>
<td style="font-family: Helvetica; font-size: 12px;" height="121"
width="249"><b> Richard Ellis </b><br>
Technical Developer, .Sun eBusiness <br>
<br>
<b>Sun Microsystems, Inc.</b><br>
Phone x(70) 24727/+44-1252-424 727<br>
Fax +44 1252 420410<br>
Email <a class="moz-txt-link-abbreviated"
href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a><br>
</td>
<td style="font-family: Helvetica; font-size: 12px;" width="172"><img
moz-do-not-send="true" src="file://///home/re100941/q01.gif"
alt="sun.com" height="118" width="172"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>