XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Component/s: moodle.org
    • Labels:
      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

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: