[rt-users] Issue with RT system

[James Moseley]

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>  
                                                                   Subject 
             08/16/2007 02:01          RE: [rt-users] Issue with RT system 
             PM                                                            
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




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
mysql..

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

Thanks
Tamer

-----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
itself.


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

www.stillsecure.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