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

AJAX Marking - Hanging MySQL querry locks database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 2.2.2
    • Block: AJAX Marking
    • None
    • MOODLE_22_STABLE

      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.

            mattgibson Matt Gibson (Inactive)
            joseph.jacelone Joseph Jacelone
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.