XF 1.5 Alot of errors suddenly (xf_session.MYI incorrect key file)

[borgqueenx]

after i restarted my server i suddenly got these errors. anyone have a idea how to fix this?

Stack Trace:

#0 /home/cct/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/cct/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/cct/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_sess...', Array)
#3 /home/cct/public_html/library/XenForo/Session.php(846): Zend_Db_Adapter_Abstract->update('xf_session', Array, 'session_id = 'c...')
#4 /home/cct/public_html/library/XenForo/Session.php(582): XenForo_Session->saveSessionToSource('c52d464cf54a603...', true)
#5 /home/cct/public_html/library/XenForo/Controller.php(414): XenForo_Session->save()
#6 /home/cct/public_html/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'Siropu_Chat_Con...', 'Refresh')
#7 /home/cct/public_html/library/XenForo/FrontController.php(358): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'Siropu_Chat_Con...', 'Refresh')
#8 /home/cct/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/cct/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}

Request State:

array(3) {
["url"] => string(47) "http://cupcakethunder.eu/index.php?chat/refresh"
["_GET"] => array(1) {
["chat/refresh"] => string(0) ""
}
["_POST"] => array(12) {
["room_id"] => string(1) "0"
["last_id"] => string(5) "20423"
["inverse"] => string(1) "0"
["hide_bot"] => string(1) "0"
["no_users"] => string(1) "0"
["show_ignored"] => string(1) "0"
["all_pages"] => string(1) "0"
["embedded"] => string(1) "1"
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

Please help!

 

[Paul B]

after i restarted my server

Did you restart it gracefully?
It sounds like you didn't stop and start MySQL correctly.

Try reparing the xf_session table.

 

[borgqueenx]

how do i do that if i may ask? (almost no knowledge in server management sorry)
i have phpmyadmin on centos web panel.

 

[TPerry]

if you have SSH access, shutdown -r now for a restart (as root) or sudo shutdown -r now (as user)
to halt the server shutdown -h now (as root) or sudo shutdown -h now (as user)

There should also be an ability from cPanel to shut the server down (don't use it so not sure) and am also not sure if there is if it cleanly shuts the server and it's services down.

 

[Jake B.]

There should also be an ability from cPanel to shut the server down (don't use it so not sure) and am also not sure if there is if it cleanly shuts the server and it's services down.

The button for this is in WHM. There is both a graceful and forceful reboot option

 

[borgqueenx]

i always used the restart in virtualiser, no idea how clean that one is. il try "shutdown -r" next time thanks.

I cannot repair anything in phpmyadmin in xf_session since it seems to be an empty table. (no repair button)
however phpmyadmin does say "Table './cct_xenforo/xf_session' is marked as crashed and should be repaired".

I have a recent backup of yesterday of this mysql file. so if nothing else, if someone can explain how to replace this tablewith my backup table it would be cool.

 

[TPerry]

i always used the restart in virtualiser, no idea how clean that one is. il try "shutdown -r" next time thanks.
I have a recent backup of yesterday of this mysql file. so if nothing else, if someone can explain how to replace this tablewith my backup table it would be cool.

Empty it instead (just go ahead and choose the empty option) in phpmyadmin.

 

[borgqueenx]

This will xenforo fill it up again? What will be lost?

 

[HWS]

What will be lost?

Nothing.

 

[borgqueenx]

that did it, thanks