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

$CFG contains several 'show_sumofgrades_upgrade' entries

    XMLWordPrintable

    Details

    • Workaround:
      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.
    • Affected Branches:
      MOODLE_31_STABLE

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                roperto Daniel Thee Roperto
                Participants:
                Component watchers:
                Matteo Scaramuccia, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Matteo Scaramuccia, Jake Dallimore, Jun Pataleta
              • Votes:
                4 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: