Unable to open file process_id.MYI

Can somebody help me explain why I would be getting this errors. I have removed the hostname from the error message. Fri Jan 19 14:50:52 2007 error OTRS-GenericAgent-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create) VALUES ('GenericAgent', '3140', 'hostname.abc.com', 1169247052)' Fri Jan 19 14:50:52 2007 error OTRS-GenericAgent-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'SELECT process_name, process_id, process_host, process_create FROM process_id WHERE process_name = 'GenericAgent'' Fri Jan 19 14:50:52 2007 error OTRS-PM3-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create) VALUES ('PostMasterPOP3', '3138', 'hostname.abc.com', 1169247052)' Fri Jan 19 14:50:52 2007 error OTRS-PM3-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'SELECT process_name, process_id, process_host, process_create FROM process_id WHERE process_name = 'PostMasterPOP3'' Thanks for all the assistance in advance. Thanks Parag

Parag Mehta wrote:
Can somebody help me explain why I would be getting this errors. I have removed the hostname from the error message.
Fri Jan 19 14:50:52 2007 error OTRS-GenericAgent-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create) VALUES ('GenericAgent', '3140', 'hostname.abc.com', 1169247052)'
Fri Jan 19 14:50:52 2007 error OTRS-GenericAgent-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'SELECT process_name, process_id, process_host, process_create FROM process_id WHERE process_name = 'GenericAgent''
Fri Jan 19 14:50:52 2007 error OTRS-PM3-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create) VALUES ('PostMasterPOP3', '3138', 'hostname.abc.com', 1169247052)'
Fri Jan 19 14:50:52 2007 error OTRS-PM3-10 Can't open file: 'process_id.MYI'. (errno: 145), SQL: 'SELECT process_name, process_id, process_host, process_create FROM process_id WHERE process_name = 'PostMasterPOP3''
Thanks for all the assistance in advance.
You probably have a crashed database table. Use the REPAIR TABLE command to see if MySQL can repair the table. Nils Breunese.
participants (2)
-
Nils Breunese (Lemonbit)
-
Parag Mehta