• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

xf_session needs repairs now and then... why?

andrewkm

Active member
#1
After restarting my VPS / and other random times... my xf_session tables shoots off an error and the forums simply don't work.

Mysqli statement execute error : Incorrect key file for table './andymidu_xen/xf_session.MYI'; try to repair it

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 690
XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 431
XenForo_Session->save() in XenForo/Controller.php at line 403
XenForo_Controller->updateSession() in XenForo/Controller.php at line 350
XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 317
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/andymidu/public_html/forum/index.php at line 13

The only thing that fixes it is a repair on that table through phpmyadmin. Any ideas why this happens so often?
 

Jake Bunce

XenForo moderator
Staff member
#3
Superficial corruption can happen when a service or server crashes or unexpectedly shuts down in the middle of a write. It's nothing to worry about unless it recurs, then you need to examine your uptime and logs to see what's going on.