Error reading from database Backup During

Error reading from database Backup During

by Yunus Akarsu -
Number of replies: 3

Hello

During a backup course i can see error message below. I changed my packet allow size 512M


Debug info: MySQL server has gone away

SELECT COUNT(*)

FROM lrn_backup_ids_temp b

JOIN lrn_user u ON u.id = b.itemid

WHERE b.backupid = ?

AND b.itemname = 'userfinal'

AND u.mnethostid != ?

[array (

0 => '867c29f4176d2ad1319aab0eea74fcd1',

1 => '1',

)]

Error code: dmlreadexception

×Stack trace:

line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown

line 1247 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()

line 1587 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()

line 1660 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()

line 1870 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()

line 477 of /backup/util/dbops/backup_controller_dbops.class.php: call to moodle_database->count_records_sql()

line 1835 of /backup/moodle2/backup_stepslib.php: call to backup_controller_dbops::backup_includes_mnet_remote_users()

line 88 of /backup/util/plan/backup_structure_step.class.php: call to backup_main_structure_step->define_structure()

line 181 of /backup/util/plan/base_task.class.php: call to backup_structure_step->execute()

line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()

line 119 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()

line 337 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()

line 136 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()

line 169 of /backup/backup.php: call to backup_ui->execute()

Average of ratings: -
In reply to Yunus Akarsu

Re: Error reading from database Backup During

by Ken Task -
Picture of Particularly helpful Moodlers

Version of Moodle is?   Are you using Moodle Networking in this course?

Suggestion ... due to what is seen/shared in debug ... make a backup of the course but make it *no user* (that would exclude MNet users) and if there is a resource in the course called 'userfinal' (assume that is a quiz/test) exclude that as well from the backup.

A quiz/test could be massive and thus requires a lot more resources when a backup is made (quiz bank).

'SoS', Ken

In reply to Ken Task

Re: Error reading from database Backup During

by Yunus Akarsu -
Hello Ken

Thanks for reply.

Im using moodle 3.7.2+

I dont use moodle networking in course

Course sie is very big Do you have any suggestions?

Thanks for help
In reply to Ken Task

Re: Error reading from database Backup During

by Yunus Akarsu -
This is Debug result "no user"
MySQL server has gone away
SELECT COUNT(*)
FROM lrn_backup_ids_temp b
JOIN lrn_user u ON u.id = b.itemid
WHERE b.backupid = ?
AND b.itemname = 'userfinal'
AND u.mnethostid != ?
[array (
0 => '3fe396d6f330c939e89493b25ad0332f',
1 => '1',
)]
Error code: dmlreadexception
×Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1247 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1587 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1660 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1870 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
line 477 of /backup/util/dbops/backup_controller_dbops.class.php: call to moodle_database->count_records_sql()
line 1835 of /backup/moodle2/backup_stepslib.php: call to backup_controller_dbops::backup_includes_mnet_remote_users()
line 88 of /backup/util/plan/backup_structure_step.class.php: call to backup_main_structure_step->define_structure()
line 181 of /backup/util/plan/base_task.class.php: call to backup_structure_step->execute()
line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
line 119 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
line 337 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
line 136 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()
line 169 of /backup/backup.php: call to backup_ui->execute()