SUMO stage: run /scripts/clean_up_users.php

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
major
RESOLVED FIXED
8 years ago
3 years ago

People

(Reporter: paulc, Assigned: justdave)

Tracking

Details

(URL)

Attachments

(1 attachment)

(Reporter)

Description

8 years ago
We'd like to run a clean up script from /scripts/clean_up_users.php to take out some old users data.

Please run the script and paste the output here.

If QA passes, we're considering cronning this yearly.
(Reporter)

Updated

8 years ago
Blocks: 464087
(Reporter)

Updated

8 years ago
Severity: normal → major
[root@mrapp-stage02 support-stage.mozilla.com]# php scripts/clean_up_users.php 
Getting list of users to remove... PHP Fatal error:  Call to undefined function bcsub() in /data/www/support-stage.mozilla.com/scripts/clean_up_users.php on line 34

Fatal error: Call to undefined function bcsub() in /data/www/support-stage.mozilla.com/scripts/clean_up_users.php on line 34
Assignee: server-ops → justdave
(Reporter)

Comment 2

8 years ago
Created attachment 429558 [details] [diff] [review]
replace bcsub with round 

This replaces bcsub() with round(), which is more common. My bad, sorry.
Attachment #429558 - Flags: review?(laura)

Updated

8 years ago
Attachment #429558 - Flags: review?(laura) → review+
(Reporter)

Comment 3

8 years ago
r63490

justdave: after SVN picks up the changes, please try again. Thanks!
Just so people know I'm working on it... it didn't immediately crash this time, but it apparently takes a Really Long Time to run.  It's been going for a while, I'll paste it in here once it finishes.
and, it finished not long after I finally posted that.

[root@mrapp-stage02 support-stage.mozilla.com]# php scripts/clean_up_users.php 
Getting list of users to remove... done in 1.56 seconds.
Ignoring users from tiki_actionlog... done in 0.71 seconds.
Ignoring users from tiki_user_postings... done in 0.47 seconds.
Ignoring users from tiki_comments... done in 2.28 seconds.
Deleting from users_usergroups... done in 184.44 seconds.
Deleting from tiki_user_preferences... done in 978.94 seconds.
Deleting from users_users... done in 303.32 seconds.
Deleted 105569 users and a total of 3455232 rows.

Script executed in 1471.72 seconds.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.