-
Bug
-
Resolution: Fixed
-
Minor
-
4.2, 4.2.6, 4.3.2
-
2
-
Team Hedgehog 2024 Sprint 1.1, Team Hedgehog 2024 Sprint 1.2, Team Hedgehog 2024 Sprint 1.3
Course Overview Block for a user with 300+ course enrolments is throwing "Failed to load resource: the server responded with a status of 500" error. (out of memory)
Issue has been tracked back to "core_course_get_enrolled_courses_by_timeline_classification" and more specifically to https://github.com/moodle/moodle/blob/MOODLE_402_STABLE/course/classes/external/course_summary_exporter.php#L96-L99 which is fetching the course summary of every course a user is enrolled in. Course summary could contain html, images, long text, etc. and should not really be fetched by the query to populate the course overview block for users due to performance implications.
When we commented out course_summary_exporter.php#L96-L99 the course overview block loads without an error and within couple of seconds after cache purge.
We also checked all the course summaries in the database and deleted all course summaries that contained any type of html which also made the courses to load but it was taking 20-30 seconds to load all courses after a cache purge.
- has a non-specific relationship to
-
MDL-76174 Performance impact on course_overview block and my/courses.php
-
- Closed
-
- has been marked as being related by
-
MDL-81304 Still very poor performance on my/courses.php
-
- Open
-
- is blocked by
-
MDL-76723 Exporters read structure for format fields produces invalid 'required'
-
- Closed
-
-
MDL-80201 \core\external\exporter::export() does not recognise the 'default' attribute for the format property
-
- Closed
-
- Testing discovered
-
MDL-80201 \core\external\exporter::export() does not recognise the 'default' attribute for the format property
-
- Closed
-