WeBWorK Main Forum

MariaDB Error

MariaDB Error

by Trevor Saunderson -
Number of replies: 3

I am hoping someone can help us with an error we are receiving when a large number of students try to simultaneously access a WeBWorK assessment via an LTI link in Brightspace (Desire2Learn).   

The error is as follows (and the exact is attached):

 DBD::MariaDB::st execute failed: Incorrect key file for table './webwork/MA100labs_F22_key.MYI'; try to repair it at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 891

We think it is a load error but it is only happening (so far) for a select number of courses - not all of them.  Does anyone have any thoughts on how to rectify this or what the issue may be?

For background,  we just upgraded to 2.16 over the summer from 2.13 (where we never encountered this error).  It's running on Redhat (RHEL 8) and at any one moment in time we could have upwards of 150 students clicking on a link within a minute or two time frame.




Attachment SQLError.png
In reply to Trevor Saunderson

Re: MariaDB Error

by Trevor Saunderson -
I should add that we have successfully repaired the database with sudo myisamchk -r and the problem still persists.
In reply to Trevor Saunderson

Re: MariaDB Error

by Danny Glin -

A quick Google search for that error suggested that it might be related to insufficient disk space. Have you checked both the tmp partition and the car partition?

When you get the error message is it only affecting the _key table for the affected courses, or do you see it with other tables as well?