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

Do not purge entire databasemeta cache when there are structure changes (esp temp tables).

    XMLWordPrintable

Details

    • MOODLE_29_STABLE, MOODLE_31_STABLE
    • MOODLE_31_STABLE
    • MDL-51374-master-new
    • Hide
      Pre-requisites

      This issue must be tested on all supported databases, so please be patient.

      Manual testing
      1. Upgrade from 3.0 to master, make sure you don't see any errors.
      2. Do multiple backup and restores, make sure you don't get errors and all data is properly restored on the destination course.
      3. Do an exploratory testing creating courses, users, course modules, enrol, anyway an overall testing: inserting, updating and deleting information on the database.
      4. Install plugins and remove plugins...
      5. Create a new install, you should install without any problems.
      6. Repeated steps above in the fresh install.
      Unit tests

      All unit tests should pass in all supported databases.

      Show
      Pre-requisites This issue must be tested on all supported databases, so please be patient. Manual testing Upgrade from 3.0 to master, make sure you don't see any errors. Do multiple backup and restores, make sure you don't get errors and all data is properly restored on the destination course. Do an exploratory testing creating courses, users, course modules, enrol, anyway an overall testing: inserting, updating and deleting information on the database. Install plugins and remove plugins... Create a new install, you should install without any problems. Repeated steps above in the fresh install. Unit tests All unit tests should pass in all supported databases.
    • 3.1 Sprint 5

    Description

      Reported as a part of MDL-49489 - the databasemeta cache is purged whenever a temp table is created. Perhaps it would be better to be more specific and purge only the affected table, or ignore purging the cache for temporary tables.

      Attachments

        Issue Links

          Activity

            People

              lameze Simey Lameze
              damyon Damyon Wiese
              Damyon Wiese Damyon Wiese
              David Monllaó David Monllaó
              Jun Pataleta Jun Pataleta
              Matteo Scaramuccia, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Raquel Ortega, Sara Arjona (@sarjona), Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              10 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                23/May/16