461745 - Deleting a user in Bugzilla must change bugs or create referential integrity problems

Status: RESOLVED DUPLICATE of bug 453681

(Bugzilla :: Administration, task)

Description

[Philippe JAMET]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3
Build Identifier: 3.0

A bug record must not be impacted by the removal of a user.

When deleting users, bugs related to this user (reported by, or containing description provided by this user) becomes invalid: the database integrity is broken.

A bug is linked to a software project, removing a user from the project membership should not ever and ever impact on the integrity of the whole bug reports.

There is information in the Bugzilla Manual (paragraph 3.0.5). But one reads the information after the user deletion has been done. Restoring a valid  Bugzilla database is not a simple task.

The delete User fonction (or the Bugzilla internal structure) should be changed to forbid such an integrity break.


Reproducible: Always

Steps to Reproduce:
1. Delete a User
2. Examine bugs connected to this user (reported by, or containing description of comments entered by this user. Search for bug will not report bugs connected to this user.
3.
Actual Results:  
1. Delete a User
2. Examine bugs connected to this user (reported by, or containing description of comments entered by this user. Search for bug will not report bugs connected to this user.

Expected Results:  
Search for bug will not report bugs connected to this user.
Examining a bug reported by the user deleted (bug selected by its number) will show missing items:
  Reporter field: empty (not modifiable)
  Description or comment fields connected to this deleted user lost  

This behavior is not acceptable for a Defect Management System used in a context of Software Quality. Defect records must not be modified or destroyed by removing a user from the base.

Comment 1

[Frédéric Buclin]

There is a red box with a warning in it *before* you delete the user. The admin who deletes the user is responsible for the referential integrity problem if he ignores the warning. Anyway, in bug 453681, I hide the "Delete user" button if there are referential integrity problems, so an admin shouldn't pass this step anymore.