usually about twice a month I will receive this error message...
Code: Select all
DB function failed with error number 1034 Incorrect key file for table 'mos_session'; try to repair it SQL=SELECT session_id FROM mos_session WHERE session_id = MD5( '7e8312f6e57c106d600629d460bb2e88' ) SQL = SELECT session_id FROM mos_session WHERE session_id = MD5( '7e8312f6e57c106d600629d460bb2e88' )
When I check the MySQL server, everything APPEARS fine, but in all actuallity, the server has went into MySQL-Safe mode, AND has locked everything single table dealing with my website... I have to actually reboot the whole server to get it running normal again..
i have searched high and low to figure this out but I can't... If anyone has any ideas please lert me know...
Dual Xeon's (dual core)
160GB 7200 EIDE
If there is any more information needed to figure out WHY MySQL seems to crumble like this (ALWAYS in the middle of the night when no one is on) I'd like to know....