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

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.1
    • Fix Version/s: 2.2.5, 2.3.2
    • Component/s: Quiz
    • Labels:
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:
    • Pull Master Diff URL:

      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

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-34532 Error on selecting different attempts for quiz reports

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-34351 Bad questions can break overdue quiz cron

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is a regression caused by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-3030 Late quiz attempts should be closed automatically

          • Major - Major loss of function, incorrect output
          • Closed

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              fireoxx74 Ben Steeples
              Integrator:
              Dan Poltawski
              Tester:
              Dan Poltawski
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Sep/12