RE: [rt-users] Issue with RT system
Another error , I believe both errors are due to same reason .. This error gets logged in the rt.log when somebody tries to connect to RT system. Any Idea what may be the problem.. Thanks [Thu Aug 16 14:52:35 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:36 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [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) [Thu Aug 16 14:52:36 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:36 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [Thu Aug 16 14:52:39 2007] [crit]: Couldn't create a ticket: Internal Error: Couldn't execute the query 'INSERT INTO Tickets (Subject, Status, Queue, Creator, Owner, Started, Type, LastUpdatedBy, Resolved, Starts, Created, Priority, Due, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Can't open file: 'Tickets.MYI' (errno: 145) (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:590) [Thu Aug 16 14:52:39 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:39 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [Thu Aug 16 14:52:40 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) [Thu Aug 16 14:52:40 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:40 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] Issue with RT system
Looks like your Tickets mysql table is missing (or doesn't have the right permissions). Is this a new install? If so, you might want to reinitialize your database. James Moseley Tamer Tayea [EMAIL PROTECTED] ytouch.comTo Sent by: Tamer Tayea rt-users-bounces@ [EMAIL PROTECTED], lists.bestpractic RT-Users@lists.bestpractical.com al.com cc Subject 08/16/2007 01:31 RE: [rt-users] Issue with RT system PM Another error , I believe both errors are due to same reason .. This error gets logged in the rt.log when somebody tries to connect to RT system. Any Idea what may be the problem.. Thanks [Thu Aug 16 14:52:35 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:36 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [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) [Thu Aug 16 14:52:36 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:36 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [Thu Aug 16 14:52:39 2007] [crit]: Couldn't create a ticket: Internal Error: Couldn't execute the query 'INSERT INTO Tickets (Subject, Status, Queue, Creator, Owner, Started, Type, LastUpdatedBy, Resolved, Starts, Created, Priority, Due, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Can't open file: 'Tickets.MYI' (errno: 145) (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:590) [Thu Aug 16 14:52:39 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:39 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) [Thu Aug 16 14:52:40 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) [Thu Aug 16 14:52:40 2007] [crit]: Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:756) [Thu Aug 16 14:52:40 2007] [error]: Create failed: 0 / 0 / Ticket could not be created due to an internal error (/usr/local/rt3/lib/RT/Interface/Email.pm:762) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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 mysql.. How I go about fixing this db issue ( I am not expert on DB) Thanks Tamer -Original Message- From: Ole Craig [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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 [EMAIL PROTECTED] ytouch.comTo Sent by: Ole Craig rt-users-bounces@ [EMAIL PROTECTED] lists.bestpractic cc al.comRT-Users RT-Users@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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Issue with RT system
Hey Tamer, I would really help to know what all software you are running as outlined bellow, but chances are your database became corrupted. You might want to check your file systems, make sure there is enough free space, possibly just restoring from your most recent backup will solve the problem. This doesn't really sound like a RT problem, more of something to do with MySQL or the underlying OS. I could give you a few commands to run but I have no idea what type of OS you're running this on. Are you seeing any type of filesystem or hardware related errors in the logs? Is MySQL logging anything? .Robert Tamer Tayea wrote: 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 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] Issue with RT system
Also make sure that /var (or where ever MySQL is installed) is not mounted read-only. -Sean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] ytouch.com To Sent by: Ole Craig rt-users-bounces@ [EMAIL PROTECTED] lists.bestpractic cc al.comRT-Users RT-Users@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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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]. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com