Debug info: MySQL server has gone away
INSERT INTO mdl_backup_controllers (backupid,operation,type,itemid,format,interactive,purpose,userid,status,execution,executiontime,checksum,controller,timecreated,timemodified) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => 'd86268a945dca889a4e91acc13ed1782',
1 => 'backup',
2 => 'course',
3 => 2,
4 => 'moodle2',
5 => 1,
6 => 10,
7 => '2',
8 => 500,
9 => 1,
10 => 0,
11 => 'fd9695337d95be6a31527db7f4cb9a28',
12 => 'TzoxNzoiYmFja3... (over 1.3 million characters removed from here)... MTE6IgAqAGNoZWNrc3VtIjtzOjMyOiJmZDk2OTUzMzdkOTViZTZhMzE1MjdkYjdmNGNiOWEyOCI7fQ==',
13 => 1327582412,
14 => 0,
)]
Stack trace:
line 397 of \lib\dml\moodle_database.php: dml_write_exception thrown
line 893 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 935 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
line 69 of \backup\util\dbops\backup_controller_dbops.class.php: call to mysqli_native_moodle_database->insert_record()
line 312 of \backup\controller\backup_controller.class.php: call to backup_controller_dbops::save_controller()
line 137 of \backup\util\ui\base_ui.class.php: call to backup_controller->save_controller()
line 91 of \backup\backup.php: call to base_ui->save_controller()
Error reading from database
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 mdl_block_instances bi
JOIN mdl_block b ON bi.blockname = b.name
LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id
AND bp.contextid = ?
AND bp.pagetype = ?
AND bp.subpage = ?
LEFT JOIN mdl_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 => '21',
1 => 'backup-backup',
2 => '',
3 => '21',
4 => '20',
5 => '1',
6 => 'backup-backup',
7 => 'backup-backup-*',
8 => 'backup-*',
9 => '*',
10 => '',
)]
Stack trace:
line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 768 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 599 of \lib\blocklib.php: call to mysqli_native_moodle_database->get_recordset_sql()
line 1205 of \lib\pagelib.php: call to block_manager->load_blocks()
line 720 of \lib\pagelib.php: call to moodle_page->starting_output()
line 607 of \lib\outputrenderers.php: call to moodle_page->set_state()
line 2026 of \lib\outputrenderers.php: call to core_renderer->header()
line 328 of \lib\setuplib.php: call to core_renderer->fatal_error()
line ? of unknownfile: call to default_exception_handler()
Fatal error: Exception thrown without a stack frame in Unknown on line 0
Then only thing that stands out for me is the value in the first query to mdl_backup_controllers for column controller (12 =>) there were over 1.3 million characters in that field. What is this field and could it be the source of my problems?
When I came in this morning and tried it again it returned this same error except at the very top of the page it included a line that it had received a packet larger than the set max_allowed_packet size, which at the time was 10MB. First and last time I've seen this message. I increased it to 32MB and then 64MB, both times got the same error above. I reduced it to 20, 16, 12, back to 10 and then to 1MB and always get the same error now.
Any insight from this community as to what is going on here or how to solve this issue would be much appreciated. Thanks in advance.