Uploaded image for project: 'Moodle Community Sites'
  1. Moodle Community Sites
  2. MDLSITE-5469

moodle.org problems

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • High
    • Resolution: Done
    • moodle.org
    • None

    Description

      Some hours ago moodle.org has started experiencing problems, unable to serve requests.

      It has been detected that this query is getting minutes (2500 seconds) to complete:

      SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance FROM context ctx WHERE id IN (SELECT contextid
      		 
                        FROM comments
      		 
                       WHERE component = 'assignsubmission_comments'
      		 
                             AND commentarea = 'submission_comments'
      		 
                             AND userid = '2438070')

      The query seems to come from the privacy stuff, more exactly:

      https://github.com/moodle/moodle/blob/master/mod/assign/submission/comments/classes/privacy/provider.php#L64

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDLSITE-5529 moodle.org forum notification emails not being sent

          • Low - Cosmetic problems, nice-to-have features
          • Resolved

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDLSITE-5498 Learn Moodle data requests stuck on pre-processing

          • Low - Cosmetic problems, nice-to-have features
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-62601 Processing deletion request by a user deleted meanwhile - throws exception

          • Major - Major loss of function, incorrect output
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-62602 Data requests stuck on pre-processing

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-62619 Improve performance of get_contexts_for_userid

          • Major - Major loss of function, incorrect output
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-62621 Comments table in db has no indexes

          • Major - Major loss of function, incorrect output
          • Closed

          Activity

            People

              mudrd8mz David Mudrák (@mudrd8mz)
              stronk7 Eloy Lafuente (stronk7)
              Aurelie Soulier
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: