XF 1.3 Xf_Search_Index keeps crashing

[denisx04]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table './enixor_den/xf_search_index' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Wyvern, Today at 6:50 PM

My users are reporting that it crashed yet again, this is after I rebuilt it in myphpadmin three times already. Anyone else experiencing this and have a fix?

 

[Jeremy P]

I got this occasionally. Turns out something was killing the mysql process, unclean shutdowns can cause tables to crash.

 

[denisx04]

I got this occasionally. Turns out something was killing the mysql process, unclean shutdowns can cause tables to crash.

What did you do to resolve the issue?

 

[Jeremy P]

Checked to see why mysql was being force quit and made appropriate changes so it didn't happen again. In my case it was being killed for using too much memory but it could be any number of things.