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

Quiz duplication slow

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 3.4.6
    • Fix Version/s: None
    • Component/s: Questions
    • Labels:
      None
    • Affected Branches:
      MOODLE_34_STABLE

      Description

      A user is experiencing extremely slow performance for quiz duplication. It appears it is due to the fact that the duplicate activity function creates a backup of ALL the questions in the course question bank, regardless if they are used in the specified quiz or not. These are not random questions, but rather Embed Cloze questions. Since this question type embeds additional questions, there are considerably more question records in the database than number of questions in the question bank.

      In addition, we are unable to restore this course due to the size of the question bank now.

      We began looking at exporting the question bank categories in hopes of being able to move the course content to a new course in the future. However, we receive an error when trying to export a question bank category with 31 questions in the main category and 27 questions in the subcategories.

      Each individual category can be exported successfully, but the parent category export generates this error:

      06-Mar-2019 14:56:19 America/New_York] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) in /var/www/html/lib/dml/mysqli_native_moodle_database.php on line 1249
      [06-Mar-2019 14:56:19 America/New_York] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 16384 bytes) in /var/www/html/lib/classes/session/manager.php on line 539
      [06-Mar-2019 14:56:19 America/New_York] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 12288 bytes) in Unknown on line 0
      [06-Mar-2019 14:56:19 America/New_York] PHP Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time in Unknown on line 0
      [06-Mar-2019 14:56:19 America/New_York] PHP Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time in Unknown on line 0
      [06-Mar-2019 14:56:19 America/New_York] PHP Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time in Unknown on line 0

      Is there any hope of modifying the duplicate function so that it only backups and restores the questions/categories used in the quiz? Currently is presenting a usability issue for our faculty, and in the future it will become a big problem when attempting to backup and restore these courses in future semesters.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                timhunt Tim Hunt
                Reporter:
                meltonml Michelle Melton
                Participants:
                Component watchers:
                Tim Hunt, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: