Closed Bug 859945 Opened 12 years ago Closed 11 years ago

Mozillians database cleanup: Delete empty groups

Categories

(Participation Infrastructure :: Phonebook, defect)

Product:
Participation Infrastructure
Component:
Phonebook
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: hoosteeno, Assigned: giorgos)

References

Details

We should delete user-created (not functional areas or restricted or internal) groups that have no members. This could be done as part of a daily/weekly batch process or it could be triggered when group membership reaches 0. If we choose the triggered approach we should run a one-time job to delete existing 0-member groups. Please request a full database backup before deploying this code to production for its first run.
Assignee: nobody → giorgos
Status: NEW → ASSIGNED
Target Milestone: --- → 2013-05-02
Commits pushed to master at https://github.com/mozilla/mozillians https://github.com/mozilla/mozillians/commit/3b2d101c16a144609b720d62e75897c558cc3381 [fix bug 859945] Task to delete empty groups. https://github.com/mozilla/mozillians/commit/561d2e967e8d6b89e97a83459045e2003c81689b Merge pull request #459 from glogiotatidis/859945 [fix bug 859945] Task to delete empty groups.
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
For the moment QA is blocked from testing until bug 867791 is remedied.
Depends on: 867791
Target Milestone: 2013-05-02 → 2013-05-09
Target Milestone: 2013-05-09 → 2013-05-02
Reopening: Looking at https://mozillians.allizom.org/admin/groups/group/ I see groups that have a member count of zero. Should these groups have been deleted?
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Target Milestone: 2013-05-02 → ---
mean to say (comment 4): s/zero/non-zero/ Looking at https://mozillians.allizom.org/admin/groups/group/ I see groups that have a member count of non-zero. Should these groups have been deleted?
I added a job to delete empty groups and skills every day on stage. Let's check tomorrow if it was successful.
Status: REOPENED → RESOLVED
Closed: 12 years ago → 12 years ago
Resolution: --- → FIXED
On second thought, re-opening this as a note to add the same job on prod when we verify it on stage.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Depends on: 877315
Depends on: 699530
Job is active on prod.
Status: REOPENED → RESOLVED
Closed: 12 years ago → 11 years ago
Resolution: --- → FIXED
QA verified on stage and prod -- I see no groups with count less than 1
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.