IntegrityError raised deleting a series

[Diogo Matsubara]

OOPS-93c9602da4a55064c5b25f5db810f54b IntegrityError: update or delete on table "milestone" violates foreign key constraint "bugtask__product__milestone__fk" on table "bugtask"
DETAIL: Key (product,id)=(28142,35309) is still referenced from table "bugtask".

Raised deleting this series: https://launchpad.net/akiban-tools/halo/+delete

[Curtis Hovey (sinzui)]

I wonder if there is another bug relationship that the delete rules are not aware of. The milestone is removed from the bugs before the milestone is deleted. The code even knows that conjoined masters need to be deleted.

    def _deleteMilestone(self, milestone):
        """Delete a milestone and unlink related objects."""
        self._unsubscribe_structure(milestone)
        for bugtask in self._getBugtasks(milestone):
            if bugtask.conjoined_master is not None:
                Store.of(bugtask).remove(bugtask.conjoined_master)
            else:
                bugtask.milestone = None
        for spec in self._getSpecifications(milestone):
            spec.milestone = None
        self._deleteRelease(milestone.product_release)
        milestone.destroySelf()

[Steve Kowalik (stevenk)]

I don't think there is another bug relationship. The _getBugtasks() method limits the bugtasks returned to ones the user can see by using BugTaskSearchParams(user=self.user) -- if there are other bugtasks with the milestone set, the OOPS as seen will be raised.

[Launchpad QA Bot (lpqabot)]

Fixed in stable r16014 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/16014>.