Not the answer you need?
Register and ask your own question!

Moodle dmlreadexception error: WSREP detected deadlock/conflict

Manuel Fraga CastroManuel Fraga Castro EntrantCurrent User Role Participant
Hello,

We are using 3 MySQL servers 5.7.18-15-57-log with Percona XtraDB Cluster (GPL), Release rel15, Revision 7693d6e, WSREP version 29.20, wsrep_29.20 as database cluster for Moodle 3.4.3+ (Build: 20180531)

We have set pxc strict mode to permissive, however we are getting this kind of errors:

Debug info: WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction
SELECT g.id,g.itemid,g.userid,g.rawgrade,g.rawgrademax,g.rawgrademin,g.rawscaleid,g.usermodified,g.finalgrade,g.hidden,g.locked,g.locktime,g.exported,g.overridden,g.excluded,g.timecreated,g.timemodified,g.aggregationstatus,g.aggregationweight
FROM mdl_grade_grades g, mdl_grade_items gi
WHERE gi.id = g.itemid AND gi.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ORDER BY g.userid
[array (
0 => 8470,
1 => 8471,
2 => 8472,
3 => 8473,
4 => 8474,
5 => 8475,
6 => 8476,
7 => 8477,
8 => 8478,
9 => 8482,
10 => 8483,
11 => 8484,
12 => 8485,
13 => 8486,
14 => 8487,
15 => 8494,
16 => 8495,
17 => 8549,
18 => 8551,
19 => 17168,
20 => 17169,
21 => '9058',
)]
Error code: dmlreadexception

Stack trace:
  • line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1163 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 516 of /lib/grade/grade_category.php: call to mysqli_native_moodle_database->get_recordset_sql()
  • line 737 of /lib/grade/grade_item.php: call to grade_category->generate_grades()
  • line 1256 of /lib/gradelib.php: call to grade_item->regrade_final_grades()
  • line 349 of /course/modlib.php: call to grade_regrade_final_grades()
  • line 176 of /course/modlib.php: call to edit_module_post_actions()
  • line 173 of /local/edinumen/course/modedit.php: call to add_moduleinfo()

Any advice to find the cause and fix the error?

Thanks in advance for the help
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.