Ao tentar realizar o backup de um curso, obtive o erro dmlreadexception (quando habilitado o debug, mostrado abaixo). Acompanhando as principais Threads acerca do erro dml_read_exception, como visto neste link, é necessário aumentar o valor da variável max_allowed_packet. Contudo, meu moodle está hospedado em servidores Hostinger, em que o SQL SET GLOBAL max_allowed_packet=... para maiores valores é proibido. A saber, o limite de upload do Moodle está configurado para o máximo do site (e permitido pelo servidor), com 128MB (upload_max_filesize e post_max_size). O que me parece estranho, uma vez que o conteúdo do curso é disposto de livros, contendo apenas imagens e textos (portanto dificilmente excedendo a cota de 128MB). Como realizar o backup desse curso? Segue o relatório de erros:
Warning: mysqli::query(): MySQL server has gone away in /home/u117604571/public_html/ava/lib/dml/mysqli_native_moodle_database.php on line 1244
Warning: mysqli::query(): Error reading result set's header in /home/u117604571/public_html/ava/lib/dml/mysqli_native_moodle_database.php on line 1244
Debug info: MySQL server has gone away
SELECT COUNT(*)
FROM ovmv_backup_ids_temp b
JOIN ovmv_user u ON u.id = b.itemid
WHERE b.backupid = ?
AND b.itemname = 'userfinal'
AND u.mnethostid != ?
[array (
0 => '438df9f4db79d701ad0be287e1f5a29b',
1 => '1',
)]
Error code: dmlreadexception
Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1245 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1571 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1854 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 1823 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 322 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 146 of /backup/backup.php: call to backup_ui->execute()