Mozillians database cleanup: Delete abandoned/incomplete accounts

VERIFIED FIXED

Status

Participation Infrastructure
Phonebook
VERIFIED FIXED
5 years ago
4 years ago

People

(Reporter: hoosteeno, Assigned: giorgos)

Tracking

Details

This should be a daily job to delete accounts older than 7 days that have no profile information or only have an email address. Since "Full Name" is required when creating a profile, perhaps the presence of that field can be used as a filter(?).

Please request a full database backup before deploying this code to production for its first run.
Duplicate of this bug: 857422
(Assignee)

Updated

5 years ago
Assignee: nobody → giorgos
Status: NEW → ASSIGNED
(Assignee)

Updated

5 years ago
Depends on: 866106
Target Milestone: --- → 2013-05-02
Sancus requested additional time to review this bug & code. Bumping to next release.
Target Milestone: 2013-05-02 → 2013-05-09

Updated

5 years ago
Target Milestone: 2013-05-09 → ---

Comment 3

5 years ago
Commits pushed to master at https://github.com/mozilla/mozillians

https://github.com/mozilla/mozillians/commit/41ee01ddc35fecdb5a4653407b58c4e9f29ece4d
[fix bug 859943] Delete incomplete accounts automation.

https://github.com/mozilla/mozillians/commit/015869add6ebc7b5b7d7e3b3fed448e039284ecb
Merge pull request #458 from glogiotatidis/859943

[fix bug 859943] Delete incomplete accounts automation.

Updated

5 years ago
Status: ASSIGNED → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Reopening this bug. The code has landed on prod, but we have not activated it. In order to activate we need to...

1) Test that the code works as expected on staging. 
* does it delete all accounts it should?
* does it delete any accounts it shouldn't?

2) Activate a celery job in prod
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Depends on: 699530
(Assignee)

Comment 5

4 years ago
I verify that this works as expected on stage. Incomplete accounts that exist in our system for more than INCOMPLETE_ACC_MAX_DAYS get deleted every day.

Currently the setting is set to 7 days per comment #1.

Note that the job has to run once per day, doesn't make any sense to run it more often.
That's great news!

I vote to enable it on prod.
+1
(Assignee)

Comment 8

4 years ago
Job is active on prod.
Status: REOPENED → RESOLVED
Last Resolved: 5 years ago4 years ago
Resolution: --- → FIXED
Can this be marked verified? Do we have reports showing this is successfully running as expected?
Flags: needinfo?(williamr)
Flags: needinfo?(giorgos)
Verified on production.

Steps:
- Navigate to User Profiles and select the filters Vouched: No and Profile: Incomplete
- Check that any user profiles listed were created 7 days ago or less

Our database no longer has abandoned accounts and it is delighted about this.
Status: RESOLVED → VERIFIED
Flags: needinfo?(williamr)
Flags: needinfo?(giorgos)
Many thanks willimar! yay
You need to log in before you can comment on or make changes to this bug.