Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-34251

Cron task never finishes. Gets to line 'Looking for quiz overdue quiz attempts between Wednesday, 31 December 1969, 6:00 PM...' then never advances

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.3.1
    • 2.2.5, 2.3.2
    • Quiz
    • MOODLE_23_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • Hide

      1. Running the unit tests should be sufficient.

      2. You could also do a basic test of attempting a quiz, and regrading, say, just to make sure there are no regressions caused by these changes.

      Show
      1. Running the unit tests should be sufficient. 2. You could also do a basic test of attempting a quiz, and regrading, say, just to make sure there are no regressions caused by these changes.

    Description

      Related to http://tracker.moodle.org/browse/MDL-34109

      Cron script runs, but gets stuck at 'Looking for quiz overdue quiz attempts'. Checking SQL server, the cron is executing the following statements in an endless loop:

      SELECT q.*, qc.contextid
      FROM moodle.mdl_question q
      JOIN moodle.mdl_question_categories qc ON q.category = qc.id
      WHERE q.id = '4549'
      (1 row returned)

      SELECT * FROM moodle.mdl_question_hints WHERE questionid = '4549' ORDER BY id ASC
      (0 rows returned)

      SELECT * FROM moodle.mdl_question_multichoice WHERE question = '4549'.
      (1 row returned)

      SELECT * FROM moodle.mdl_question_answers WHERE question = '4549' ORDER BY id ASC
      (4 rows returned)

      Running https://github.com/moodle/moodle/blob/master/mod/quiz/cronlib.php#L91 by hand yields 140 records, so this isn't a huge database

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              fireoxx74 Ben Steeples
              Dan Poltawski Dan Poltawski
              Dan Poltawski Dan Poltawski
              Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Sep/12