2026-03-03 03:35:08 Debug info:
2026-03-03 03:35:08 The table '/rdsdbdata/tmp/#sql14d_80613bb_4' is full
2026-03-03 03:35:08 WITH
2026-03-03 03:35:08 cte_objects AS (
2026-03-03 03:35:08 SELECT o.contenthash, o.location
2026-03-03 03:35:08 FROM mdl_tool_objectfs_objects o
2026-03-03 03:35:08 WHERE o.location = ? ),
2026-03-03 03:35:08 cte_obj_files AS (
2026-03-03 03:35:08 SELECT f.contenthash, MAX(f.filesize) AS filesize
2026-03-03 03:35:08 FROM mdl_files f
2026-03-03 03:35:08 INNER JOIN cte_objects co ON f.contenthash = co.contenthash
2026-03-03 03:35:08 WHERE filesize > 0
2026-03-03 03:35:08 GROUP BY f.contenthash, f.filesize)
2026-03-03 03:35:08 SELECT COALESCE(COUNT(cof.contenthash),0) AS objectcount,
2026-03-03 03:35:08 COALESCE(SUM(cof.filesize),0) AS objectsum
2026-03-03 03:35:08 FROM cte_obj_files cof
2026-03-03 03:35:08 [array (
2026-03-03 03:35:08 0 => 2,
2026-03-03 03:35:08 )]
2026-03-03 03:35:08 Backtrace:
2026-03-03 03:35:08 * line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
2026-03-03 03:35:08 * line 1364 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
2026-03-03 03:35:08 * line 1687 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
2026-03-03 03:35:08 * line 92 of /admin/tool/objectfs/classes/local/report/location_report_builder.php: call to moodle_database->get_record_sql()
2026-03-03 03:35:08 * line 139 of /admin/tool/objectfs/classes/local/report/objectfs_report.php: call to tool_objectfs\local\report\location_report_builder->build_report()
2026-03-03 03:35:08 * line 47 of /admin/tool/objectfs/classes/task/generate_status_report.php: call to tool_objectfs\local\report\objectfs_report::generate_status_report()
2026-03-03 03:35:08 * line 410 of /lib/classes/cron.php: call to tool_objectfs\task\generate_status_report->execute()
2026-03-03 03:35:08 * line 208 of /lib/classes/cron.php: call to core\cron::run_inner_scheduled_task()
2026-03-03 03:35:08 * line 125 of /lib/classes/cron.php: call to core\cron::run_scheduled_tasks()
2026-03-03 03:35:08 * line 186 of /admin/cli/cron.php: call to core\cron::run_main_process()
The task is currently failing on sites with very large databases: