Sessions table crashes often

Software Support
1

Hello all,
our journal’s database is crashing much more often than before, due to a problem in the sessions table. This has happened once a day during last week. Here is the error:

ojs_db.sessions     check     warning     Table is marked as crashed
ojs_db.sessions     check     warning     1 client is using or hasn't closed the table prope...
ojs_db.sessions     check     error     Record at pos: 952416 is not remove-marked
ojs_db.sessions     check     error     record delete-link-chain corrupted
ojs_db.sessions     check     error     Corrupt

and after repairing I get:

repair warning Number of rows changed from 2867 to 2866

Do you know why this is happening? we are using OJS 2.4.8 on a linux-based server.

Best,
Ali

2

Hi @alirezaaa,

I suspect this is an effect of your MySQL configuration – there may be more information in your MySQL error log.

Regards,
Alec Smecher
Public Knowledge Project Team