[rt-users] Issue with RT system

[Edge, Sean]

Also make sure that /var (or where ever MySQL is installed) is not
mounted read-only.

-Sean 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of James
Moseley
Sent: Thursday, August 16, 2007 3:12 PM
To: Tamer Tayea
Cc: RT-Users
Subject: RE: [rt-users] Issue with RT system

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


_______________________________________________
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



This email (including any attachments) is for its intended-recipient's
use only. This email may contain information that is confidential or
privileged.  If you received this email in error, please immediately
advise the sender by replying to this email and then delete this message
from your system.  For further information and disclaimers that apply to
this email, see [http://www.viacom.com/email_disclaimer.jhtml].