Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

by Mathew Gancarz -
Number of replies: 4
Picture of Core developers

Hi everyone, I did a search to see if this has been reported before but could not find something similar as the words 'quiz review' brought up several thousand posts. This Monday I got a ton of errors in the apache logs, with the message. I've replaced the IP Address and user name below to anonymize.

[Mon Sep 01 18:31:44 2014] [error] [client x.x.x.x] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/web/<sitename>/lib/dml/mysqli_native_moodle_database.php on line 384, referer: http://<sitename>/mod/quiz/review.php?attempt=117###

I cross checked our activity logs around the same time frame, and found huge number of log entries, for one user, doing the final quiz review for an exam in one of our courses.

I've reached out to them to try to find out what they saw on their end (if they were somehow mashing the refresh button or something else), but was curious to see if anyone had seen something like this before?

The user was able to complete the exam, and it looks like this only happened at the final submit step, as there are normal quiz attempts logged at normal time intervals before this.

The last normal actions logged before the spam were:

Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz close attempt Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz view summary Final Exam


Then after the Quiz close attempt, it's 6 pages of the below. I've copied/pasted only one page.

Time IP address User full name Action Information
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:32 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Mon 1 September 2014, 6:31 PM x.x.x.x User Name 1 quiz review Final Exam
Average of ratings: -
In reply to Mathew Gancarz

Re: Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Cat sat on the student's keyboard, including the F5 key? (This really happened once with an OU student. I can't remember what lead us to believe what sounds like a feeble excuse.)

Alternatively, some sort of web browser or network glitch that caused the request to be endlessly repeated.

If you can get any information from the student, that is likely to be your best source.

In reply to Tim Hunt

Re: Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

by Mathew Gancarz -
Picture of Core developers

Thank you Tim, I was suspecting something like that also, I guess stuck keys do happen occasionally. Will let you know if I hear something interesting back smile

In reply to Mathew Gancarz

Re: Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

by Mathew Gancarz -
Picture of Core developers

So this is interesting.. this weekend I had the same thing happen with another student, this with posting to a forum. The result is about 360 identical forum posts.. Haven't heard back from the first student yet on what happened, however this is a different student, so I'm hoping they may relay what happened.

In reply to Mathew Gancarz

Re: Huge number of Quiz Review page loads logged from one user, overloaded MySQL max connections

by Mathew Gancarz -
Picture of Core developers

Unfortunately all this student had said was that their computer froze up when they posted it. Still hoping to see if anyone else has seen something similar, but this may end up belonging in another forum, since it may not be specific to the quiz activity.