XF 1.4 Mysqli statement execute error : Incorrect key file for table

[onelife69]

Hi there,

Recently upgraded to XF 1.4.3 and started getting server errors like the one below. Any idea what is causing this and hopefully a simple remedy?

Many thanks in advance.


Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect key file for table './tilingfo_newforu60/xf_session.MYI'; try to repair it - library/Zend/Db/Statement/Mysqli.php:214

#0 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
#3 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Session.php(827): Zend_Db_Adapter_Abstract->delete('xf_session', 'expiry_date < 1...')
#4 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/CronEntry/CleanUp.php(23): XenForo_Session->deleteExpiredSessions()
#5 [internal function]: XenForo_CronEntry_CleanUp::runHourlyCleanUp(Array)
#6 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#7 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_Cron->execute(Array, Array, 7.999990940094, '')
#9 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 7.999990940094, '', false)
#10 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#11 /var/www/vhosts/tilingforum.co.uk/httpdocs/deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}

#0 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
#3 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Session.php(827): Zend_Db_Adapter_Abstract->delete('xf_session', 'expiry_date < 1...')
#4 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/CronEntry/CleanUp.php(23): XenForo_Session->deleteExpiredSessions()
#5 [internal function]: XenForo_CronEntry_CleanUp::runHourlyCleanUp(Array)
#6 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#7 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_Cron->execute(Array, Array, 7.999990940094, '')
#9 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 7.999990940094, '', false)
#10 /var/www/vhosts/tilingforum.co.uk/httpdocs/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#11 /var/www/vhosts/tilingforum.co.uk/httpdocs/deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}

 

[Paul B]

The errors appear to be related to the session table.

You can try repairing or truncating the xf_session table using phpMyAdmin.

 

[onelife69]

Thanks Brogan, you're the man

 

[reddy ink]

I had the same issue twice and fixed it by repairing the table.

Do you know why this error happens?
Thank you!

 

[Paul B]

Typically it is due to server issues, such as MySQL restarting unexpectedly or not being shut down and restarted correctly.

Your sysadmin or host should be able to investigate.

 

[Xon]

Do you know why this error happens?

The table type 'MyISAM' is not crash safe, meaning if anything vaguely goes wrong the table contents (or even the definition) can be lost.