XF 2.0 Board went down: AbstractStatement.php on line 212

[crazykgb]

No changes were made at all. The board just stopped working today with this message displayed for the front users.

Any fixing idea would be appreciated.

An exception occurred: [XF\Db\Exception] MySQL query error [126]: Index for table './xcf_1/xf_session.MYI' is corrupt; try to repair it in src/XF/Db/AbstractStatement.php on line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
4. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
5. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
6. XF\Session\Session->save() in src/XF/Pub/App.php at line 373
7. XF\Pub\App->complete() in src/XF/App.php at line 1934
8. XF\App->run() in src/XF.php at line 329
9. XF::runApp() in index.php at line 13

 

[Paul B]

Repair or truncate the session table using phpMyAdmin.

 

[crazykgb]

Thank you very much.

Any insight on why it happened and how to avoid this in the future?

 

[Paul B]

Typically it's due to server instability.

Your host will be best placed to investigate that.