XF 1.4 xf_session' is marked as crashed and Incorrect key file for table xf_session.MYI

[rbharathi]

Hi ,
I got this error from today morning,
nobody cant access forum

there are more than 2000 instances ....

This is the starting error,

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


xf_session' is marked as crashed

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table './newxen/xf_session' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago
Stack Trace

#0 /home/rbharathi820/public_html/forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/rbharathi820/public_html/forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/rbharathi820/public_html/forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/rbharathi820/public_html/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/rbharathi820/public_html/forum/library/XenForo/Session.php(814): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
#5 /home/rbharathi820/public_html/forum/library/XenForo/Session.php(532): XenForo_Session->saveSessionToSource('bdc740f3e51bec1...', false)
#6 /home/rbharathi820/public_html/forum/library/XenForo/Controller.php(414): XenForo_Session->save()
#7 /home/rbharathi820/public_html/forum/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_Error), 'XenForo_Control...', 'Errornotfound')
#8 /home/rbharathi820/public_html/forum/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_Error), 'XenForo_Control...', 'Errornotfound')
#9 /home/rbharathi820/public_html/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/rbharathi820/public_html/forum/index.php(13): XenForo_FrontController->run()
#11 {main}

 

[Jeremy P]

Repair the table (xf_session) from phpMyAdmin or your DBA tool of choice.

 

[rbharathi]

Repair the table (xf_session) from phpMyAdmin or your DBA tool of choice.

Thanks a lot @Jeremy P
I have done this from phpMyAdmin
What can cause this error?
is there any VPS server setting, involved in this??

 

[Paul B]

Table crashes can be caused by various things such as server instability, MySQL shutting down/restarting unexpectedly, etc.

 

[rbharathi]

Table crashes can be caused by various things such as server instability, MySQL shutting down/restarting unexpectedly, etc.

Correct, my server's Mysql server is getting restarted often and i will contact my host, Thank you Brogan