[rt-users] Issue with RT system

James Moseley jmoseley at corp.xanadoo.com
Thu Aug 16 15:11:51 EDT 2007

Did you check to make sure the mysqld process is running?  Have you checked
the mysql logs for errors?  If the mysqld process is running and your
Tickets table exists, it's possible the Tickets table is corrupted.  Try a
repair table operation if so.

And like Ole stated, you need to provide a lot more information in order to
get help.

James Moseley

             "Tamer Tayea"                                                 
             <Tamer.Tayea at payb                                             
             ytouch.com>                                                To 
             Sent by:                  "Ole Craig"                         
             rt-users-bounces@         <ocraig at stillsecure.com>            
             lists.bestpractic                                          cc 
             al.com                    RT-Users                            
                                       <RT-Users at lists.bestpractical.com>  
             08/16/2007 02:01          RE: [rt-users] Issue with RT system 

This server has been running for 3 years at least. Today , the server
wan hung , I had to reboot it ..
Since rebooting it , I am getting these errors. Yes, the backend is

How I go about fixing this db issue ( I am not expert on DB)


-----Original Message-----
From: Ole Craig [mailto:ocraig at stillsecure.com]
Sent: Thursday, August 16, 2007 2:59 PM
To: Tamer Tayea
Cc: RT-Users
Subject: RE: [rt-users] Issue with RT system

On Thu, 2007-08-16 at 14:31 -0400, Tamer Tayea wrote:
> [Thu Aug 16 14:52:36 2007] [crit]: Couldn't create a ticket: Internal
> Error: Couldn't execute the query 'INSERT INTO Tickets (Subject,
> Status, Queue, Creator, Owner, LastUpdatedBy, Started, Type, Starts,
> Resolved, Created, Priority, Due, LastUpdated) VALUES
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Can't open file:
> 'Tickets.MYI' (errno: 145)
> (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:590)

Tamer -
    What are you actually running? "RT 3" covers years and years of
development; 3.6.4 (latest stable) is *worlds* away from RT 3.0. Also,
when asking for help on this list, you're more likely to get meaningful
responses if you list all the components -- and versions thereof --
you're using to run RT: host OS, webserver, database, and RT codebase

Anyway, this is a database problem. "Can't open file: 'Tickets.MYI'"
says to me that you're using a mysql backend, but the schema hasn't been
created. Is this a new install? Did you run the database initializer?

/Ole Craig
Security Engineer
Team lead, customer support

ocraig at stillsecure.com
303-381-3824 direct
303-381-3802 support
303-381-3880 fax



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

More information about the rt-users mailing list