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

$CFG contains several 'show_sumofgrades_upgrade' entries

XMLWordPrintable

    • MOODLE_31_STABLE
    • Hide

      Run:

      SELECT * FROM mdl_config WHERE name LIKE 'show_sumofgrades_upgrade_%';

      If it seems sane, make the query a DELETE.

      This will remove the warning from all old courses before Moodle 2.8 that the sum of grades changes, which was so long ago that it probably does not matter anymore.

      Show
      Run: SELECT * FROM mdl_config WHERE name LIKE 'show_sumofgrades_upgrade_%'; If it seems sane, make the query a DELETE. This will remove the warning from all old courses before Moodle 2.8 that the sum of grades changes, which was so long ago that it probably does not matter anymore.

      There is a show_sumofgrades_upgrade_xxx for almost every course in a Moodle system.

      In one case, considering an instance that has tens of thousands of courses, the $CFG variable contains 13678 records.

      This leads to a cache entry with around 600KB which can have a great impact if you are not using a local caching server (ie multiple frontends).

      I am marking this as 'caching' as this is where I found the issue in my instance, but there is probably a root cause behind that which I haven't investigated yet.

      Notes: It was introduced as an upgrade to Moodle 2.8:
      https://github.com/moodle/moodle/commit/a9937aec06eecde600f81efe1ff2f53d86df0bf1#diff-31dc43dcda8223cb517dfb95643f2ee2R3917

            Unassigned Unassigned
            roperto Daniel Thee Roperto
            Votes:
            4 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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