XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • moodle.org
    • None

      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

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

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.