Run updateRestrictions.php on WMF cluster to migrate page_restrictions column to page_restrictions table.
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | Ladsgroup | T60674 Drop page.page_restrictions column from Wikimedia wikis | |||
Declined | None | T30751 prop=info&inprop=protection sometimes shows protection multiple times | |||
Open | None | T251411 page_restrictions field incomplete in current and historical dumps | |||
Resolved | Ladsgroup | T35334 Remove database column page.page_restrictions from MediaWiki core | |||
Resolved | Ladsgroup | T218446 Remove use of legacy page.page_restrictions field | |||
Resolved | Reedy | T166184 Run updateRestrictions.php on WMF wikis |
Event Timeline
Hi,
We (DBAs) assume this is just a heads up for us right? We do appreciate it! :-)
If you don't mind, once you are ready to run it, please update https://wikitech.wikimedia.org/wiki/Deployments so everyone is aware.
Thanks!
Should just be a jfdi one this.
enwiki has 4109... I can't imagine many wikis having many more rows to run
Mentioned in SAL (#wikimedia-operations) [2017-07-19T12:40:12Z] <Reedy> running foreachwiki updateRestrictions.php T166184
42634455 pages on enwiki, 4109 page_restrictions != "" pages.
Batch increased ten fold in https://gerrit.wikimedia.org/r/366289
TBH, I think the code should just be doing just be doing a where page_restrictions != "" and a limit of the batch size
Script is pretty slow, and I can't really see any reason for it to be quite so conservative.
It's somewhere halfway through enwiki, but it's been running for 5 hours :(