[Treebase-guts] [ treebase-Bugs-2962228 ] Orphaned records and failure to delete related records

[SourceForge.net <no...@so...>]

Bugs item #2962228, was opened at 2010-03-02 17:26
Message generated for change (Tracker Item Submitted) made by sfrgpiel
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2962228&group_id=248804

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: data
Group: None
Status: Open
Priority: 8
Private: No
Submitted By: William Piel (sfrgpiel)
Assigned to: Mark Dominus (mjdominus)
Summary: Orphaned records and failure to delete related records

Initial Comment:
The database contains many orphaned objects. For example, under the Taxa tab, search on NCBI taxid 114498, then click either the Trees or Matrices tabs. This results in records even though none of them belong to an existing study. The problem is in part because trees and matrices don't actually get deleted properly: create a submission, upload trees or matrices, then delete the trees or matrices -- the only thing that is deleted is the linking record in the sub_matrix table. None of the column records, row records, or element records (etc) seem to get deleted. Youjun explained that the design of the matrix object does not allow the code to access the matrix rows (etc) for easy deletion. One possible solution is to include cascade-delete constraints on the tables so that deleting a matrix record automatically delete all related records without leaving behind any orphans.  At any rate, it behooves us to prevent the accumulation of orphans and to write data cleansers to get rid of the existing ones.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2962228&group_id=248804