Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3614

AJAX Marking - Hanging MySQL querry locks database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.2
    • Fix Version/s: None
    • Component/s: Block: AJAX Marking
    • Labels:
      None
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      When adding the AJAX Marking Block to a course the following query begins to run and then locks MySQL:

      87176 online_admin 10.99.1.120:51039 online_moodle Query 111 Sending data SELECT countwrapperquery.id AS courseid,
      countwrapperquery.itemcount,
      countwrapperquery.timestamp,

      When the process is killed it restarts itself. To replicate the issue we do the following:

      1] Create a course.
      2] Assign yourself the role of Teacher (default) in the course.
      3] Add the AJAX Marking Block
      4] Check MySQL process list for the query.
      5] Attempt to kill this query.

      The only way to remove the block from the course is to hit the remove icon in conjunction with killing the process in MySQL.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: