1. 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?

Discussion in 'XenForo Questions and Support' started by andrewkm, Jan 18, 2013.

  1. andrewkm

    andrewkm Active Member

    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?
     
  2. Rodrigo Farcas

    Rodrigo Farcas Active Member

    I have the same issue often. Why?
     
    andrewkm likes this.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
    andrewkm likes this.
  4. Dinh Thanh

    Dinh Thanh Well-Known Member

    Check your Disk IO, upgrade to SSD if needed.
     
    andrewkm likes this.
  5. andrewkm

    andrewkm Active Member

    Thnx for the responses guys! :)
     

Share This Page