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

Course Restore Failure if cron is triggered during restore

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.6.5
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
    • Affected Branches:
      MOODLE_26_STABLE

      Description

      Hi,

      We have been scratching our heads over the last week trying to debug a large number of course restore failures.

      Basically, due to some accidental course deletions, we were restoring about 40 courses from a backup of the system before the courses were deleted.

      We were able to extract the courses archives into our running production system. Constantly getting SQL failures similar to MDL-46651

      After all sorts of testing and experimentation, we determined that courses would restore with 100% success rate if we disabled cron during the restore. These courses were all of a reasonable size and took from 20 minutes to 5 hours to restore.

      Our suggestion is that there is some mechanism for halting cron during course restores. There is a bit of thought involved here as you don't want to:

      • kill cron when it is in progress
      • lock cron "off" in the instance that course restore process dies

      Welcome input and thoughts?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              andrew.boag Andrew Boag
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              7 Vote for this issue
              Watchers:
              15 Start watching this issue

                Dates

                Created:
                Updated: