|Open||None||T169440 Pending global renames in need of sysadmin supervision (tracking)|
|Resolved||Legoktm||T176985 Global rename of CodeCat → Rua: supervision needed|
Yeah, that is what I was referring too, if there is any other way to see if it is actually doing something (as there is a large number of edits, it might be quite slow) or if it is stuck forever
Unfortunately there is nothing I can do as I am not familiar with this process. I just monitor the DB slaves to make sure there is no lag generated (and take measures to prevent it), but I don't really know how the process works underneath. You might need to ask around.
Maybe @Reedy happens to know something?
I saw that this query timed out on enwiktionary - on the logs:
SELECT log_timestamp FROM `logging` WHERE log_user_text = 'CodeCat' AND log_user = '21371' ORDER BY log_timestamp ASC
It is a pretty heavy query;
349238 rows in set (2.24 sec)
@MarcoAurelio and myself have been chatting on IRC
˜/tabbycat 19:16> marostegui: hi ˜/tabbycat 19:16> marostegui: with --group which is the output? ˜/marostegui 19:16> let me see ˜/tabbycat 19:17> I editted the message shortly after my bad sorry ˜/marostegui 19:17> tabbycat: https://phabricator.wikimedia.org/P6057 ? ˜/tabbycat 19:18> okay marostegui so there's no localRenameJobs queued ˜/tabbycat 19:18> there's a maintenance script to use to fix this ˜/tabbycat 19:18> let me check ˜/marostegui 19:18> thanks :) ˜/tabbycat 19:19> docs says we have to wait at least 3 hours before using it because failed jobs will restart themselves ˜/marostegui 19:19> ah ˜/tabbycat 19:19> I'm not sure we've to wait here since there's no job at all ˜/marostegui 19:20> No, i was checking db logs ˜/marostegui 19:20> to look for db errors for enwiktionary ˜/tabbycat 19:21> in any case: mwscript extensions/CentralAuth/maintenance/fixStuckGlobalRename.php --wiki=enwiktionary --logwiki=metawiki "CodeCat" "Rua" is the magic command to unstuck the rename job ˜/marostegui 19:21> shall we try it? /tabbycat 19:21> if legoktm approves ˜/tabbycat 19:22> (due to skipping the 3 hours limit) ˜/marostegui 19:22> let me update the ticket btw
After more chatting and checks @MarcoAurelio suggested:
mwscript extensions/CentralAuth/maintenance/fixStuckGlobalRename.php --wiki=enwiktionary --logwiki=metawiki --ignorestatus "CodeCat" "Rua"
This looks like unblocked the rename and it went thru enwiktionary and is progressing finely
However renames happening after en.wiktionary are leaving unnatached local accounts. @Legoktm suggest running after the rename has finished:
echo "Rua" >> ~/tmp.txt; mwscript extensions/CentralAuth/maintenance/attachAccount.php --wiki=metawiki ~/tmp.txt
We should check afterwards why the rename job failed even after running the maintenance script the first time and why this time the rename job left unnatached accounts as that's not something we'd like to happen :)
The command to attach the accounts didn't fix the issue:
root@terbium:~# cat /tmp/rua.txt Rua root@terbium:~# mwscript extensions/CentralAuth/maintenance/attachAccount.php --wiki=metawiki --userlist /tmp/rua.txt CentralAuth account attach for: Rua OK: Rua [2017-09-28 18:35:13] processed: 1 (4.0/sec); ok: 1 (100.0%); attached: 0 (0.0%); partial: 0 (0.0%); failed: 0 (0.0%); missing: 0 (0.0%); done.
˜/legoktm 21:23> the good news is that nothing is wrong with the account, just how it is displayed on Special:CentralAuth :) ˜/legoktm 21:23> for whatever reason lu_attached_method is set to NULL and not login or new or whatever
Everything is fixed after running the UPDATE below
˜/legoktm 21:28> !log mysql:wikiadmin@db1062 [centralauth]> UPDATE localuser SET lu_attached_method="new" WHERE lu_attached_method is NULL AND lu_name="Rua";