[MDL-17623] Summary of Violated Foreign Key Constraints from 700+ Moodles - Moodle Tracker

XML

Word

Printable

Details

Type: Task
Status: Closed
Priority: Major
Resolution: Won't Do
Affects Version/s: 2.0
Fix Version/s: None
Component/s: Database SQL/XMLDB
Labels:
- triaged
Environment:
MySQL, 1.9.3

Database:

MySQL
Affected Branches:
MOODLE_20_STABLE

Description

I have run the report testing for violated foreign key constraints on all our 730+ production moodles.

I've collated all the violated constrains using (http://cvs.moodle.org/contrib/tools/devtools/xmldb_refintegreport.php) and then aggregated all the data from all the moodles and produced a summary report which is attached.

As you can see the grade-book is the major offender here.

This data is from quite a wide cross section of sites, from heavy users upgraded from external hosts on < Moodle 1.4, to brand new installs on 1.9.3. (All are now on 1.9.3).

230ish didn't have any violated constraints at all

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

violated_foreign_key_contraints.csv
3 kB
13/Dec/08 5:15 PM

Issue Links

has been marked as being related by

MDL-30799 META: Enable foreign keys in the database schema

Open

will be (partly) resolved by

MDL-17579 mod quiz lib.php should call delete_attempt from questionlib.php

Closed

Sub-Tasks

1.	Investigate why overrides are not being cleaned up when a context is deleted	Closed	Tim Hunt
2.	Check allow_override and allow_assign are cleaned up properly when a role is deleted	Closed	Dan Poltawski
3.	Work out why the gradebook is creating so many foreign key violations	Closed	Unassigned
4.	Workout why we are getting foreign key violations on mnet_host.applicationid	Closed	Penny Leach
5.	get_users in datalib includes unconfirmed users by default. This is dangerous and all uses should be reviewed, then the default changed.	Closed	Unassigned
6.	Investigate violations of forum_posts.discussion	Closed	Unassigned
7.	Investigate violations of groups_members.groupid	Closed	Unassigned
8.	Work out why answers are not being deleted when questions are	Open	Unassigned
9.	Where do the violations qusetion state into -> question come from?	Open	Unassigned
10.	Investigate violations of questions.modifiedby/questions.createdby	Closed	Tim Hunt

Activity

People

Assignee:: Unassigned

Reporter:: Dan Poltawski

Participants:: Brendan Heywood, Dan Poltawski, Eloy Lafuente (stronk7), Matt Porritt, Petr Skoda, Tim Hunt

Component watchers:: David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 13/Dec/08 5:15 PM

Updated:: 02/Dec/22 7:54 AM

Resolved:: 02/Dec/22 7:54 AM