Hello!
I've got error reading database when trying to delete course.
Here's the debug:
SELECT count(r.repositoryid)
FROM mdl_files f
LEFT JOIN mdl_files_reference r
ON r.id = f.referencefileid
JOIN mdl_backup_ids_temp bi
ON f.id = bi.itemid
WHERE bi.backupid = ?
AND bi.itemname = 'filefinal'
[array (
0 => '0d907b30492199dd25dd7fd3de20d733',
)]
Error code: dmlreadexception
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1175 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1558 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
- line 1631 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
- line 1841 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
- line 522 of /backup/util/dbops/backup_controller_dbops.class.php: call to moodle_database->count_records_sql()
- line 1997 of /backup/moodle2/backup_stepslib.php: call to backup_controller_dbops::backup_includes_file_references()
- line 34 of /backup/util/plan/backup_execution_step.class.php: call to backup_store_backup_file->define_execution()
- line 181 of /backup/util/plan/base_task.class.php: call to backup_execution_step->execute()
- line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
- line 120 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
- line 322 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
- line 121 of /admin/tool/recyclebin/classes/category_bin.php: call to backup_controller->execute_plan()
- line 185 of /admin/tool/recyclebin/lib.php: call to tool_recyclebin\category_bin->store_item()
- line 4823 of /lib/moodlelib.php: call to tool_recyclebin_pre_course_delete()
- line 67 of /course/delete.php: call to delete_course()
I have max_allowed_packet = 2048M and max_execution_time = 600. Also tried to modify mysqli_native_moodle_database and changing @@default_storage to @@storage. Nothing helps