About once a week or so, we end up with a MYSQL error that crashes the forum. It is embarrassing to have these frequent crashes and time consuming to have to go in a repair the tables which is the only thing that puts us back in business.
The current version of MYSQL is 4.07 gamma-NT. The Box is Small Business Server 2000 Service Pack III. Threads 6.2 (we had the same problem with Threads 6.1)
Here is what the MYSQL error log says at the time of the the crash occurs:
Thu, Jan 16 2003 17:06:18 -0800 /forum/index.php SEAHAWK
Unable to do_query: UPDATE w3t_Users SET U_Laston = 1042765578, U_TempRead = '' WHERE U_Username = 'SEAHAWK' AND U_Laston < (1042765578 - 14300) - Got error 127 from table handler
Thu, Jan 16 2003 17:07:36 -0800 /forum/ubbthreads.php 63.197.185.213
Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number FROM w3t_Users WHERE U_Number = '2' - Can't open file: 'w3t_users.MYD'. (errno: 145)
Thu, Jan 16 2003 17:07:36 -0800 /forum/ubbthreads.php 63.197.185.213
Unable to do_query: SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username FROM w3t_Moderators AS t1, w3t_Users AS t2 WHERE t1.Mod_Uid = t2.U_Number - Can't open file: 'w3t_users.MYD'. (errno: 145)
Thu, Jan 16 2003 17:07:36 -0800 /forum/ubbthreads.php 63.197.185.213
Unable to do_query: SELECT COUNT(*) FROM w3t_Users WHERE U_Approved='yes' - Can't open file: 'w3t_users.MYD'. (errno: 145)
Thu, Jan 16 2003 17:07:36 -0800 /forum/ubbthreads.php 63.197.185.213
Unable to do_query: SELECT U_Username,U_Number FROM w3t_Users WHERE U_Approved='yes' ORDER BY U_Number DESC LIMIT 0,1 - Can't open file: 'w3t_users.MYD'. (errno: 145)
Thu, Jan 16 2003 17:07:36 -0800 /forum/ubbthreads.php 63.197.185.213
Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated, t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain, t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 1 AND (t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') AND (t1.Bo_LastNumber = t3.B_Number OR t1.Bo_LastNumber ='0') AND (t1.Bo_Read_Perm LIKE '%-4-%') ORDER BY t1.Bo_Sorter - Can't open file: 'w3t_users.MYD'. (errno: 145)
Any suggestions will be greatly appreciated.