<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Ruslan,<br>
<br>
Really appreciate the help on this. I'd love to find out why we are
seeing such odd results:<br>
<br>
298 ticket owners when their are only 88 active users<br>
1.5 million rows of data when we only have 9983 ticks as of this
morning.<br>
<br>
Really odd<br>
<br>
Thanks<br>
<br>
Richard<br>
<br>
<br>
Ruslan Zakirov wrote:
<blockquote
cite="mid:589c94400803181402w6168984dw63a9105d9e3d4d2d@mail.gmail.com"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:Richard.Ellis@sun.com"><Richard.Ellis@sun.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> 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@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@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@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@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@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@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 <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
--
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
Technical Developer, .Sun eBusiness
*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
sun.com
--
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
Technical Developer, .Sun eBusiness
*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
sun.com
--
Sun.com <a class="moz-txt-link-rfc2396E" href="http://www.sun.com"><http://www.sun.com></a> * Richard Ellis *
Technical Developer, .Sun eBusiness
*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
sun.com
--
Richard Ellis
Technical Developer, .Sun eBusiness
Sun Microsystems, Inc.
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email <a class="moz-txt-link-abbreviated" href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>