Yes, the two courses are larger. They both have links to uploaded files and they also have a 150+ question test bank.
I deleted all the temp files and folders in moodledata/temp/backup/. I ran a manual backup with full debugging on and got the following errors.
Error reading from database
Debug info: MySQL server has gone away
SELECT count(r.repositoryid)
FROM mea_files f
LEFT JOIN mea_files_reference r
ON r.id = f.referencefileid
JOIN mea_backup_ids_temp bi
ON f.id = bi.itemid
WHERE bi.backupid = ?
AND bi.itemname = 'filefinal'
[array (
0 => '00a8cf04a06c8847f6072f538f16c561',
)]
Error code: dmlreadexception
Stack trace:
- line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 945 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1346 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
- line 1419 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
- line 1590 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
- line 429 of /backup/util/dbops/backup_controller_dbops.class.php: call to moodle_database->count_records_sql()
- line 1593 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 153 of /backup/util/plan/base_task.class.php: call to backup_execution_step->execute()
- line 163 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
- line 110 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
- line 309 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
- line 111 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()
- line 89 of /backup/backup.php: call to backup_ui->execute()
Debug info: MySQL server has gone away
SELECT
bi.id,
bp.id AS blockpositionid,
bi.blockname,
bi.parentcontextid,
bi.showinsubcontexts,
bi.pagetypepattern,
bi.subpagepattern,
bi.defaultregion,
bi.defaultweight,
COALESCE(bp.visible, 1) AS visible,
COALESCE(bp.region, bi.defaultregion) AS region,
COALESCE(bp.weight, bi.defaultweight) AS weight,
bi.configdata
, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
FROM mea_block_instances bi
JOIN mea_block b ON bi.blockname = b.name
LEFT JOIN mea_block_positions bp ON bp.blockinstanceid = bi.id
AND bp.contextid = ?
AND bp.pagetype = ?
AND bp.subpage = ?
LEFT JOIN mea_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = 80)
WHERE
(bi.parentcontextid = ? OR (bi.showinsubcontexts = 1 AND bi.parentcontextid IN (?,?)))
AND bi.pagetypepattern IN (?,?,?,?)
AND (bi.subpagepattern IS NULL OR bi.subpagepattern = ?)
AND (bp.visible = 1 OR bp.visible IS NULL)
AND b.visible = 1
ORDER BY
COALESCE(bp.region, bi.defaultregion),
COALESCE(bp.weight, bi.defaultweight),
bi.id
[array (
0 => '15',
1 => 'backup-backup',
2 => '',
3 => '15',
4 => '3',
5 => '1',
6 => 'backup-backup',
7 => 'backup-backup-*',
8 => 'backup-*',
9 => '*',
10 => '',
)]
Error code: dmlreadexception
Stack trace:
- line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 903 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 604 of /lib/blocklib.php: call to mysqli_native_moodle_database->get_recordset_sql()
- line 1381 of /lib/pagelib.php: call to block_manager->load_blocks()
- line 847 of /lib/pagelib.php: call to moodle_page->starting_output()
- line 707 of /lib/outputrenderers.php: call to moodle_page->set_state()
- line 2190 of /lib/outputrenderers.php: call to core_renderer->header()
- line 366 of /lib/setuplib.php: call to core_renderer->fatal_error()
- line ? of unknownfile: call to default_exception_handler()
Fatal error: Uncaught exception 'dml_read_exception' with message 'Error reading from database' in /home/elect103/public_html/lib/dml/moodle_database.php:407 Stack trace: #0 /home/elect103/public_html/lib/dml/mysqli_native_moodle_database.php(461): moodle_database->query_end(false) #1 /home/elect103/public_html/lib/ddl/sql_generator.php(230): mysqli_native_moodle_database->get_tables() #2 /home/elect103/public_html/lib/ddl/database_manager.php(104): sql_generator->table_exists(Object(xmldb_table)) #3 /home/elect103/public_html/lib/ddl/database_manager.php(310): database_manager->table_exists(Object(xmldb_table)) #4 /home/elect103/public_html/lib/dml/moodle_temptables.php(131): database_manager->drop_table(Object(xmldb_table)) #5 /home/elect103/public_html/lib/dml/moodle_database.php(333): moodle_temptables->dispose() #6 /home/elect103/public_html/lib/dml/mysqli_native_moodle_database.php(416): moodle_database->dispose() #7 /home/elect103/public_html/lib/dml/moodle_database.php(143): mysqli_native_moodle_database->dispose( in /home/elect103/public_html/lib/dml/moodle_database.php on line 407
I have not tried changing the my.cnf file yet. I will try that tonight during our maintenance time window.
Thank you Ken for your help thus far.
--Sam
