Empty = global exists but there are no attached accounts.
Mass delete the accounts and run migrateAccount-auto prior to T37707 and just after, and likely in late May to be sure.
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Maintenance script for deleting empty global accounts | mediawiki/extensions/CentralAuth | master | +132 -2 |
Related Objects
Related Objects
Event Timeline
Comment Actions
mysql:sul@dbstore1002 [centralauth]> select count(*) from globaluser left join localuser on gu_name=lu_name where lu_wiki is NULL; +----------+ | count(*) | +----------+ | 3689 | +----------+ 1 row in set (38 min 14.49 sec)
Comment Actions
Delete but also migrateAccount --auto over those username afterwards. In theory someone could lose their ownership of the global account, but it's still better than keeping the global account and having all local accounts renamed. :)
Comment Actions
Maybe check and make sure none of the local accounts have missing passwords before you delete, just in case the localuser table got messed up at some point.
Comment Actions
Yup yup to csteipp and Nemo_bis
@Legoktm we should do this twice, both just before and just after the SUL final migration script is run. Probably again in late May as well.
Comment Actions
Yup yup to csteipp and Nemo_bis
@Legoktm we should do this twice, both just before and just after the SUL final migration script is run. Probably again in late May as well.
Comment Actions
Change 202588 had a related patch set uploaded (by Anomie):
Maintenance script for deleting empty global accounts
Comment Actions
Change 202588 merged by jenkins-bot:
Maintenance script for deleting empty global accounts
Comment Actions
3675 global accounts were deleted, and 270 local accounts are now attached to a global.