Menu ▾ ▴

#200 Author records remain after last title is deleted

v1.0 (example)
closed-fixed
Ahasuerus
Editing (62)
5
2015-10-10
2011-01-16
Ahasuerus
No

Sometimes a record in canonical_author is not deleted when it's associated Title record is deleted. Running the following check against canonical_author:

mysql> select * from canonical_author where not exists (select * from titles where canonical_author.title_id = titles.title_id);

in the 2011-01-08 backup, we find 1586 records for non-existent titles. They are generally harmless except when there are no other title records for their associated author. When that happens, they prevent the author record from being auto-deleted.

Discussion

  • Ahasuerus

    Ahasuerus - 2012-09-14

    Note that this bug is related to Bug 3567491.

     

  • Ahasuerus

    Ahasuerus - 2012-11-03

    Note that this bug may be related to Bug 3315268.

     

  • Bill Longley

    Bill Longley - 2013-03-07

    Up to 2021 now. The vast majority seem to be artists.

     

  • Ahasuerus

    Ahasuerus - 2015-10-10
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,5 +1,5 @@
-Sometimes a record in canonical\_author is not deleted when it's associated Title record is deleted. Running the following check against canonical\_author:
+Sometimes a record in canonical_author is not deleted when it's associated Title record is deleted. Running the following check against canonical_author:

-mysql> select \* from canonical\_author where not exists \(select \* from titles where canonical\_author.title\_id = titles.title\_id\);
+mysql> select * from canonical_author where not exists (select * from titles where canonical_author.title_id = titles.title_id);

 in the 2011-01-08 backup, we find 1586 records for non-existent titles. They are generally harmless except when there are no other title records for their associated author. When that happens, they prevent the author record from being auto-deleted.
    • status: open --> closed-fixed
    • assigned_to: Ahasuerus
    • Group: --> v1.0 (example)
     

  • Ahasuerus

    Ahasuerus - 2015-10-10

    Patch 2015-152 fixed Bug 220 and deleted all dangling mapping entries. The fix should have resolved this problem, so I am closing this Bug. We'll revisit the issue in a few months to see if any new dangling records may have appeared.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB