We are still a little behind with updates- we are using Webwork version 2.2 or earlier (??).
Anyhow, one of our courses has stopped working.
Our server crashed on Monday night. On Tuesday morning I had to manually restart the machine. After that, in this one course only, the classlist editor showed only a truncated list of students, and returned the following error:
--------------
Tue Feb 10 14:13:52 2009
Warning messages
DBD::mysql::st execute failed: Got error 127 from storage engine at
/opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 227.
Error messages
DBD::mysql::st execute failed: Got error 127 from storage engine at
/opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 227.
Call stack
The information below can help locate the source of the problem.
in WeBWorK::DB::Schema::SQL::gets called at line 202 of
/opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm
in WeBWorK::DB::Schema::SQL::get called at line 648 of
/opt/webwork/webwork2/lib/WeBWorK/DB.pm
in WeBWorK::DB::getKey called at line 1537 of
/opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/UserList.pm
in WeBWorK::ContentGenerator::Instructor::UserList::recordEditHTML called at line 1702 of
/opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/UserList.pm
in WeBWorK::ContentGenerator::Instructor::UserList::printTableHTML called at line 537 of
/opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/UserList.pm
in WeBWorK::ContentGenerator::Instructor::UserList::body called at line 152 of
/opt/webwork/webwork2/lib/WeBWorK/Template.pm
in WeBWorK::Template::template called at line 480 of
/opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
in WeBWorK::ContentGenerator::content called at line 188 of
/opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
in WeBWorK::ContentGenerator::go called at line 338 of /opt/webwork/webwork2/lib/WeBWorK.pm
Request information
MethodGETURI/webwork2/MAT258-Bradley/instructor/users/HTTP Headers
Keep-Alive 300
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.8) Gecko/20071008
Firefox/2.0.0.8
---------------------------
Today, it has become impossible to login to the course itself.
After the login screen, it returns the following error:
---------------------------
Warning messages
DBD::mysql::st execute failed: Can't open file: 'MAT258-Bradley_key.MYI' (errno: 145) at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 227.
Error messages
DBD::mysql::st execute failed: Can't open file: 'MAT258-Bradley_key.MYI' (errno: 145) at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 227.
Call stack
The information below can help locate the source of the problem.
in WeBWorK::DB::Schema::SQL::gets called at line 202 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm
in WeBWorK::DB::Schema::SQL::get called at line 648 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm
in WeBWorK::DB::getKey called at line 593 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
in WeBWorK::Authen::check_session called at line 379 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
in WeBWorK::Authen::verify_normal_user called at line 227 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
in WeBWorK::Authen::do_verify called at line 150 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
in WeBWorK::Authen::verify called at line 275 of /opt/webwork/webwork2/lib/WeBWorK.pm
--------------------------------
Sorry for the long post. Any thoughts on how to fix the problem would be most appreciated!
Andy
Hi Andy,
I think most of the information your looking for is here:
http://dev.mysql.com/doc/refman/5.0/en/repair.html
(this is the documentation for mysql 5.0. If you're running a different version you can click the appropriate link on the left of the page)
Based on running perror on the error codes you quote, it's indicating that the table was marked as crashed and needs to be repaired. The page above describes how to repair the table. The instructions seem pretty straightforward, though I've never had to do this myself. I would also suggest backing up your database before you try any of this.
I think most of the information your looking for is here:
http://dev.mysql.com/doc/refman/5.0/en/repair.html
(this is the documentation for mysql 5.0. If you're running a different version you can click the appropriate link on the left of the page)
Based on running perror on the error codes you quote, it's indicating that the table was marked as crashed and needs to be repaired. The page above describes how to repair the table. The instructions seem pretty straightforward, though I've never had to do this myself. I would also suggest backing up your database before you try any of this.
Thanks so much Danny,
Your link did the trick.
For the record, here's exactly what I did.
cd /var/lib/mysql/
Inside here, the webwork/ directory was not readable to me. Hence:
sudo chmod 775 webwork/
cd webwork/
sudo myisamchk -r -q MAT258-Bradley_key.MYI
Also, this link has instructions for backing up the database:
http://www.roseindia.net/mysql/mysql_backup_restore.shtml
I followed the directions before doing the above, but I got
an error because of the corrupted table I was hoping to fix.
So in the end I just fixed the problem as above without backing anything up. Luckily it all works fine now.
Thanks again,
Andy
Your link did the trick.
For the record, here's exactly what I did.
cd /var/lib/mysql/
Inside here, the webwork/ directory was not readable to me. Hence:
sudo chmod 775 webwork/
cd webwork/
sudo myisamchk -r -q MAT258-Bradley_key.MYI
Also, this link has instructions for backing up the database:
http://www.roseindia.net/mysql/mysql_backup_restore.shtml
I followed the directions before doing the above, but I got
an error because of the corrupted table I was hoping to fix.
So in the end I just fixed the problem as above without backing anything up. Luckily it all works fine now.
Thanks again,
Andy