Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-71073

core_course_search_courses web service can consume all php memory

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.8.8, 3.9.5, 3.10.2
    • Fix Version/s: None
    • Component/s: Caching, Course, Web Services
    • Labels:

      Description

      We have a site with 101,334 courses when doing the following actions in Moodle we get out of memory issues:

      1. Navigate to the global search page
      2. Expand the Filter section
      3. Click to open the Courses select

      Expected outcome: A list of courses is displayed

      Actual outcome: Eventually there is a JavaScript error and the Moodle session is killed (at least on out servers where we are using memcache sessions).

      I was able to do this on a user with a site level role that gave access to all courses.

      On our site this will also happen with any sufficiently broad search term for example a single letter. The only work around seems to be to paste in a full search term straight away into the course box so the number of courses found is reasonably small.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nmagill Neill Magill
              Reporter:
              nmagill Neill Magill
              Participants:
              Component watchers:
              Matteo Scaramuccia, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona), Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona), Juan Leyva, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: