Buenas a todos,
Realicé la migración de mi moodle hacia mi servidor todo funciona bien pero cuando voy a realizar copias de seguridad de los cursos aparece un error "Error al leer la base de datos", ya he verificado en estos foros y no encuentro una solución que me ayude.
A continuacion agrego el log del modo debug de desarrollador:
Warning: Error while sending QUERY packet. PID=47336 in /home/postgrados/public_html/lib/dml/mysqli_native_moodle_database.php on line 1197
Error al leer de la base de datos
Más información sobre este error Debug info: M SQL server has gone away
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 => '4d9be4486dc27fda6e314632e01985e8', )]
Error code: dmlreadexception
Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1198 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 2006 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 136 of /backup/util/ui/backup_ui.class.php: call to backup_controller- >execute_plan()
line 142 of /backup/backup.php: call to backup_ui->execute()
Fatal error: Uncaught exception 'ddl_change_structure_exception' with message 'DDL sql execution error' in
/home/postgrados/public_html/lib/dml/moodle_database.php:492 Stack trace: #0
/home/postgrados/public_html/lib/dml/mysqli_native_moodle_database.php(1023): moodle_database->query_end(false) #1
/home/postgrados/public_html/lib/ddl/database_manager.php(77): mysqli_native_moodle_database->change_database_structure(Array, Array) #2
/home/postgrados/public_html/lib/ddl/database_manager.php(332): database_manager->execute_sql_arr(Array, Array) #3
/home/postgrados/public_html/lib/dml/moodle_temptables.php(140): database_manager->drop_table(Object(xmldb_table)) #4
/home/postgrados/public_html/lib/dml/moodle_database.php(405): moodle_temptables->dispose() #5
/home/postgrados/public_html/lib/dml/mysqli_native_moodle_database.php(571): moodle_database->dispose() #6
/home/postgrados/public_html/lib/dml/moodle_database.php(160): mysqli_native_moodle_database->dispose() #7 [internal function]:
moodle_database->__destruct() #8 {main in /home/postgrados/public_html/lib/dml/moodle_database.php on line 49
Quiero saber si puedo arreglarlo dado que tengo información que no quiero perder.