Randomized quiz with "last attempt" enabled does not record the score correctly
First I want to say that I did some research in moodle bug tracker and this is different from the "quiz problem with build on last attempt and random question" reported as MDL-8958 and so on. We are currently running Moodle 1.5.4+ with our customized codes, and this was reported by a professor. I have created some screenshots here. Basically the quiz (Mini Test 7) was setup with Grading method set to "Last attempt". If you login as a student, in one view you actually see the score (10/10) correctly (/mod/quiz/view.php?id=41558), however, if you view the score from another view (/mod/quiz/index.php?id=41558), then it shows that you got 9/10 for your Mini Test 7. The gradebook would also show 9/10 too. Is this a known issue and got fixed in Moodle 1.8? What is the moodle bug tracker # and the fix for this issue? many thanks!
Re: Randomized quiz with "last attempt" enabled does not record the score correctly
Re: Randomized quiz with "last attempt" enabled does not record the score correctly
Re: Randomized quiz with "last attempt" enabled does not record the score correctly
$Id: index.php,v 1.23.2.1 2005/06/04 08:30:48 gustav_delius Exp
Was this issue addressed in another moodle bug tracker ticket that you know of? Many thanks!
Re: Randomized quiz with "last attempt" enabled does not record the score correctly
We tried to manually lock the mdl_quiz_attempts table and was able to reproduce this issue. So I think it might be related to our MySQL database server that when it was serving many concurrent users (and many students are taking the same quiz AT the same time), somehow the mdl_quiz_attempts table got temporarily locked and therefore generated that error. But we need more tests to verify this theory.
Just curious, Tim and other people who has big moodle installation out there, what is your DB server hardware/software configuration? Did anyone ever experience this type of quiz issues that might be caused by datbase performance issues? If so, could you please share this information with us? Also, for MySQL, is there any known issues that would cause a table got temporarily locked up? Thanks!