Closed Bug 1060578 Opened 10 years ago Closed 10 years ago

Delete AMO spam users

Categories

(Data & BI Services Team :: DB: MySQL, task)

task
Not set
normal

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: jorgev, Assigned: scabral)

Details

(Whiteboard: [data: data quality])

+++ This bug was initially created as a clone of Bug #1024626 +++ It looks like our new spam filters are working very well. However, there are a few accounts remaining that we can't delete and were created before the filters were put in place: https://addons.mozilla.org/user/service-solahart-jakarta-selatan-cp-6281388311903 https://addons.mozilla.org/user/heatersolahart https://addons.mozilla.org/user/solahartpemanas The deletion docs are here: https://mana.mozilla.org/wiki/display/SYSADMIN/How+to+delete+AMO+spam+users Hopefully we won't need to ask for this again in the future :)
Assignee: server-ops-database → scabral
I can't seem to find the last user, https://addons.mozilla.org/en-US/firefox/user/solahartpemanas/ - not on the website and not in the users table. The other 2 users have ids of 11001190 and 10972058. I will proceed to delete the entries for them as the documentation notes.
The delete statements and their results: mysql> delete cs.* from collection_subscriptions cs join collections c on cs.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 20 rows affected (0.00 sec) mysql> delete from collection_subscriptions where user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete cv.* from collections_votes cv join collections c on cv.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 46 rows affected (0.00 sec) mysql> delete from collections_votes where user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete sacc.* from stats_addons_collections_counts sacc join collections c on sacc.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 48 rows affected (0.00 sec) mysql> delete scc.* from stats_collections_counts scc join collections c on scc.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 14 rows affected (0.00 sec) mysql> delete sc.* from stats_collections sc join collections c on sc.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 64 rows affected (0.01 sec) mysql> delete cu.* from collections_users cu join collections c on cu.collection_id = c.id where c.author_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete from collections_users where user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete from collections where author_id in (10972058,11001190); Query OK, 47 rows affected (0.24 sec) mysql> delete laum.* from log_activity_user_mkt laum join log_activity_mkt lam on lam.id = laum.activity_log_id where lam.user_id in (10972058,11001190); Query OK, 0 rows affected (0.01 sec) mysql> delete from log_activity_mkt where user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete from addons_users where user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete from users where id in (10972058,11001190); Query OK, 2 rows affected (1.28 sec) mysql> delete from auth_user where id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete un.* from users_notifications un where un.user_id in (10972058,11001190); Query OK, 0 rows affected (0.01 sec) mysql> delete au.* from abuse_reports au where au.user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete laum.* from log_activity_user_mkt laum where laum.user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete fu.* from file_uploads fu where fu.user_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec) mysql> delete ar.* from abuse_reports ar where ar.reporter_id in (10972058,11001190); Query OK, 0 rows affected (0.00 sec)
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Thanks!
Status: RESOLVED → VERIFIED
Whiteboard: [data quality]
Whiteboard: [data quality] → [data: data quality]
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.