Scheduled task generate_status_report failing

[alexpriestley-catalyst]

The task is currently failing on sites with very large databases:

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()