[rt-users] RT 3.6.4 poor query performance
Jesse Vincent
jesse at bestpractical.com
Tue Mar 18 12:18:46 EDT 2008
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
>
--
More information about the rt-users
mailing list