XF 2.2 MySQL query error [126]: Incorrect key file for table '.

[CedricV]

Any idea someone? Stores an error in the log, once every hour.

• XF\Db\Exception: MySQL query error [126]: Incorrect key file for table './threadxp_plf/xf_session.MYI'; try to repair it
• src/XF/Db/AbstractStatement.php:230
• Generated by: Unknown account
• Feb 14, 2024 at 2:11 PM

Stack trace​

DELETE FROM xf_session WHERE expiry_date < ?
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 126, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(78): XF\Db\Mysqli\Statement->getException('MySQL query err...', 126, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(290): XF\Db\AbstractAdapter->query('DELETE FROM `x...', 1707919874)
#4 src/XF/Session/DbStorage.php(62): XF\Db\AbstractAdapter->delete('xf_session', 'expiry_date < ?', 1707919874)
#5 src/XF/Cron/CleanUp.php(94): XF\Session\DbStorage->deleteExpiredSessions()
#6 src/XF/Job/Cron.php(37): XF\Cron\CleanUp::runHourlyCleanUp(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Manager.php(260): XF\Job\Cron->run(8)
#8 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#9 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)
#10 job.php(43): XF\Job\Manager->runQueue(false, 8)
#11 {main}

Request state​

array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(123) "https://palworldforums.net/resource...palworld-transfer-character-linux-pak-mods.8/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[ircforumlaricomtr]

You may find the following link useful for your question and answer.

XF 2.2 Thread 'MySQL query error [126]: xf_search_index.MYI is corrupt; try to repair it'

Jul 22, 2021

I got this error when I was on XenForo 2.2.6 Patch 1 (now I've upgraded to Patch 2):

Server error log
XF\Db\Exception: MySQL query error [126]: Index for table './.../xf_search_index.MYI' is corrupt; try to repair it src/XF/Db/AbstractStatement.php:228
Generated by: ... 20. Jul 2021 at 12:46
Stack trace
INSERT  INTO `xf_search_index` (`content_type`, `content_id`, `title`, `message`, `metadata`, `item_date`, `user_id`, `discussion_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE title = VALUES(title), message = VALUES(message), metadata = VALUES(metadata), item_date =...

• BassMan
• Replies: 4
• Forum: Troubleshooting and problems