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

          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: