Run PopulateCentralId on metawiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Zabe
	Mar 29 2022, 11:09 PM

Project Tags

Referenced Files

None

Subscribers

Description

Can I trick anyone into running mwscript extensions/GlobalBlocking/maintenance/PopulateCentralId.php --wiki=metawiki?

I don't have the access to do it myself.

The script goes through all rows of the globalblocks table where gb_by_central_id is null and looks up the central id via CentralIdLookup (in this case this means CentralAuthIdLookup) and updates the row. The final result is that the gb_by_central_id is fully populated.

The script was added in https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GlobalBlocking/+/762493. If anyone has any functionality questions, please ask them to me.

Related Objects
Search...

Status	Subtype	Assigned	Task
Resolved	PRODUCTION ERROR	Zabe	T298707 "InvalidArgumentException: Blocker must be a local user" from GlobalBlocking
Resolved		Zabe	T299371 Migrate globalblocks table to use central ids instead of usernames
Resolved		Urbanecm	T305014 Run PopulateCentralId on metawiki

Event Timeline

Zabe created this task.Mar 29 2022, 11:09 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 29 2022, 11:09 PM

MarcoAurelio subscribed.Apr 4 2022, 4:25 PM

Zabe updated the task description. (Show Details)Apr 10 2022, 3:59 PM

Hello @Zabe, I can help here. Can we pair on this sometime this week? It'd be helpful if you can be around the time the script is started, so you can a) confirm the changes are correct b) help me should the script throw/otherwise break. Feel free to PM me over IRC to coordinate :).

Urbanecm claimed this task.Apr 11 2022, 8:40 PM

Restricted Application added a project: User-Urbanecm. · View Herald TranscriptApr 11 2022, 8:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T20:45:19Z] <urbanecm> [urbanecm@mwmaint1002 ~]$ mwscript extensions/GlobalBlocking/maintenance/PopulateCentralId.php --wiki=metawiki # START, T305014, running in a tmux under my account at mwmaint1002

Mentioned in SAL (#wikimedia-operations) [2022-04-11T21:02:38Z] <urbanecm> [urbanecm@mwmaint1002 ~]$ mwscript extensions/GlobalBlocking/maintenance/PopulateCentralId.php --wiki=metawiki # END, T305014

Done. Script was stopped in the middle, so output is split in half: P24464, P24465. Let me know if anything else's needed.

It appears no rows are left:

wikiadmin@10.64.16.83(centralauth)> select count(*) from globalblocks where gb_by_central_id is null;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.101 sec)

wikiadmin@10.64.16.83(centralauth)>

Resolving.

Run PopulateCentralId on metawikiClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Run PopulateCentralId on metawiki
Closed, ResolvedPublic
Actions

Related Objects
Search...