-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
3.3.3
-
MOODLE_33_STABLE
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()