Following a particular nasty crash yesterday afternoon (WW 2 / mysql ran out of memory again), in one of our WW 1.9 courses a student has had their database entry corrupted and we get the error....
Error: in dataMunger.pl:
Can't find record with psvn = 143819
in the database
I found this in the archives...
http://wwrk.maa.org/moodle/mod/forum/discuss.php?d=1597
but it doesn't discuss what to do if the psvn exists in the db but is corrupt.
Looking at...
http://webwork.rochester.edu/docs/docs/courseadmin/describescripts.html
It looks like rebuildProbSetDBfromPSVNlog.pl should do what I want it to do, but since the psvn exists, it doesn't recreate it.
Am I right in assuming I'll have to shut down outside access, copy the scoring files, answer files, etc, to a safe place, delete the problem set, and then rebuild it from the psvnlog file?
Any help would be greatly appreciated.
Fuzzy
WW 1.9 - Can't find record with psvn = 143819 in the database
by Fuzzy Rogers - Number of replies: 2
In reply to Fuzzy Rogers
Re: WW 1.9 - Can't find record with psvn = 143819 in the database
by Fuzzy Rogers -
On a test server I figured out I can score the problem set and delete it and rebuild it with the same seeds. Is there a way I can 'inject' the .sco files into the system?
Also, on the production server the professor caused more havoc by attempting to edit the due date for the corrupted problem set. Now there's an empty, non-existent problem set called 'Set' that's only visible to 'professors'. It causes the professor page to come up RED with warnings like...
Compiler warnings:
* Use of uninitialized value in hash element at /usr/local/webwork/system/scripts/DBglue8.pl line 768.
##More details:
-------- main::getAllProbSetNumbersHash called at /usr/local/webwork/system/cgi/cgi-scripts/profLogin.pl line 102
--------------------------------------
* Use of uninitialized value in hash element at /usr/local/webwork/system/scripts/DBglue8.pl line 768.
##More details:
-------- main::getAllProbSetNumbersHash called at /usr/local/webwork/system/cgi/cgi-scripts/profLogin.pl line 102
This fake problem set can't be deleted. Here's the error:
Error: DBglue: getAllProbSetKeysForSet: Can't find index for set number
Help?!
Fuzzy
Also, on the production server the professor caused more havoc by attempting to edit the due date for the corrupted problem set. Now there's an empty, non-existent problem set called 'Set' that's only visible to 'professors'. It causes the professor page to come up RED with warnings like...
Compiler warnings:
* Use of uninitialized value in hash element at /usr/local/webwork/system/scripts/DBglue8.pl line 768.
##More details:
-------- main::getAllProbSetNumbersHash called at /usr/local/webwork/system/cgi/cgi-scripts/profLogin.pl line 102
--------------------------------------
* Use of uninitialized value in hash element at /usr/local/webwork/system/scripts/DBglue8.pl line 768.
##More details:
-------- main::getAllProbSetNumbersHash called at /usr/local/webwork/system/cgi/cgi-scripts/profLogin.pl line 102
This fake problem set can't be deleted. Here's the error:
Error: DBglue: getAllProbSetKeysForSet: Can't find index for set number
Help?!
Fuzzy
In reply to Fuzzy Rogers
Re: WW 1.9 - Can't find record with psvn = 143819 in the database
by Arnold Pizer -
Hi Fuzzy,
It's been a long time since I last used WW 1.9 but you shouldn't have to do anything with the .sco files (assuming the old .sco files are still in place). When the students work on a problem which they worked on, their new scores will be appended to the .sco files. When the set is past the due date, the set should be scored using the .sco files (there is an option or script to do this --- I don't recall which). Obviously you can test this on your test server.
Arnie
It's been a long time since I last used WW 1.9 but you shouldn't have to do anything with the .sco files (assuming the old .sco files are still in place). When the students work on a problem which they worked on, their new scores will be appended to the .sco files. When the set is past the due date, the set should be scored using the .sco files (there is an option or script to do this --- I don't recall which). Obviously you can test this on your test server.
Arnie