859943 - Mozillians database cleanup: Delete abandoned/incomplete accounts

Status: VERIFIED FIXED

(Participation Infrastructure :: Phonebook, defect)

Description

[Justin Crawford [:hoosteeno] [:jcrawford]]

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.

Comment 2

[Justin Crawford [:hoosteeno] [:jcrawford]]

Sancus requested additional time to review this bug & code. Bumping to next release.

Comment 3

[[github robot]]

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.

Comment 4

[Justin Crawford [:hoosteeno] [:jcrawford]]

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

Comment 5

[Giorgos Logiotatidis [:giorgos]]

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.

Comment 6

[Justin Crawford [:hoosteeno] [:jcrawford]]

That's great news!

I vote to enable it on prod.

Comment 7

[Matt Brandt [:mbrandt]]

+1

Comment 8

[Giorgos Logiotatidis [:giorgos]]

Job is active on prod.

Comment 9

[Matt Brandt [:mbrandt]]

Can this be marked verified? Do we have reports showing this is successfully running as expected?

Comment 10

[William Reynolds [:williamr]]

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.

Comment 11

[Matt Brandt [:mbrandt]]

Many thanks willimar! yay