Describe the issue or problem
Since a few days we are having problems with PHP fatal errors informing us that the index of different tables is corrupt. At first it seemed to only be the sessions table, but now it is complaining about for example table user_settings and submission_search_object_keywords. We also get Integrity constraint violation: 1062 Duplicate entry for key ‘sessions_pkey’.
The site is still working but some requests give Server error 500.
Yesterday there was 5742 instances of the word “corrupt” in the error.log, and the day before 1140 instances.
This afternoon we dropped the sessions_pkey index and created a new one. There were none of the database index errors until three hours later. Then we got the same error messages about the sessions table.
Steps I took leading up to the issue
We did not do any changes to the system code this past week.
What application are you using?
OJS 3.3.0.15
We have session_check_ip = On
I guess this could be a pure database or hardware issue? But does anyone have any suggestions for what else we could check or do?