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

moodle throws deadlock dml error when editing due dates for assignments

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.3.3
    • Fix Version/s: None
    • Component/s: Report: Edit dates
    • Labels:
    • Affected Branches:
      MOODLE_33_STABLE

      Description

      When editing the due dates for an assignment in the editdate module moodle throws a dead lock error with debug as per below: This only seems to happen with the delete statement so i am guessing the module does an insert to update the change of dates.

      [05-Apr-2018 09:33:22 America/Chicago] Default exception handler: Error writing to database Debug: Deadlock found when trying to get lock; try restarting transaction
      DELETE FROM mdl_event WHERE modulename = ? AND instance = ? AND eventtype = ?
      [array (
        0 => 'assign',
        1 => '375017',
        2 => 'gradingdue',
      )]
      Error code: dmlwriteexception

      • line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 1616 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1916 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->delete_records_select()
      • line 1233 of /mod/assign/locallib.php: call to moodle_database->delete_records()
      • line 73 of /report/editdates/mod/assigndates.php: call to assign->update_calendar()
      • line 193 of /report/editdates/index.php: call to report_editdates_mod_assign_date_extractor->save_dates()[05-Apr-2018 09:33:22 America/Chicago] Default exception handler: Error writing to database Debug: Deadlock found when trying to get lock; try restarting transaction
        DELETE FROM mdl_event WHERE modulename = ? AND instance = ? AND eventtype = ?
        [array (
          0 => 'assign',
          1 => '375017',
          2 => 'gradingdue',
        )]
        Error code: dmlwriteexception
      • line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 1616 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1916 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->delete_records_select()
      • line 1233 of /mod/assign/locallib.php: call to moodle_database->delete_records()
      • line 73 of /report/editdates/mod/assigndates.php: call to assign->update_calendar()
      • line 193 of /report/editdates/index.php: call to report_editdates_mod_assign_date_extractor->save_dates()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              bmatthias Barry Matthias
              Participants:
              Component watchers:
              Votes:
              20 Vote for this issue
              Watchers:
              18 Start watching this issue

                Dates

                Created:
                Updated: