Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-17623 Summary of Violated Foreign Key Constraints from 700+ Moodles
  3. MDL-17628

Work out why the gradebook is creating so many foreign key violations

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Won't Do
    • 1.9.3
    • None
    • Gradebook
    • None
    • MOODLE_19_STABLE

    Description

      From Dan's data:

      Moodles Affected Average Percentage rows affected Table Key Total Violated Rows Total Rows
      325 25.6 grade_items_history courseid 16896 106381
      220 31.9 grade_grades_history usermodified 130823 1009017
      202 36.5 grade_grades usermodified 88713 450475
      168 12.7 grade_items_history categoryid 11137 94977

      Work out where these are coming from, and see if we can devise an automated clean-up on upgrade.

      Attachments

        Issue Links

          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-51694 Deleting user causes exception when a grade_grades row has no corresponding grade_items row

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              Unassigned Unassigned
              timhunt Tim Hunt
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: