Once T315551 is closed and deployed, we must run php updateCollation.php --force on the Wikimedia Incubator in concordance with the hook manual.
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Lucas_Werkmeister_WMDE | T315552 Run updateCollation.php on the Wikimedia Incubator | |||
Resolved | Feature | jhsoby | T315551 Sort pages in the Wikimedia Incubator by real page title (without prefix) |
Event Timeline
I scheduled a two-hour window for running the maintenance script tomorrow. (Hopefully it won’t take that long.)
Now that the code change was deployed, mwscript updateCollation.php incubatorwiki --dry-run --force says that “671309 rows would be updated so far”; at 10000 rows per minute (docs), that would take slightly over an hour.
Note to self: probably run the script with PHP=php7.4? Or try a dry run with PHP 7.4 vs. 7.2 and see how the rows to update differ. (I suspect the few thousand rows to update before the change was backported – see T315551#8258867 – might be due to that.)
With PHP=php7.2, the script claims 671269 rows to upgrade, compared to 671334 under PHP=php7.4… that’s not really what I expected, but I think it still makes some sense. I’ll run the maintenance script under PHP 7.4 so it matches the majority of web requests now.
Mentioned in SAL (#wikimedia-operations) [2022-09-27T14:11:52Z] <Lucas_WMDE> BEGIN lucaswerkmeister-wmde@mwmaint1002:~$ PHP=php7.4 mwscript updateCollation.php incubatorwiki --force # T315552
Mentioned in SAL (#wikimedia-operations) [2022-09-27T14:25:06Z] <Lucas_WMDE> END lucaswerkmeister-wmde@mwmaint1002:~$ PHP=php7.4 mwscript updateCollation.php incubatorwiki --force # T315552, 710183 rows done
For future reference, that’s about 50000 rows processed per minute in production, five times as fast as documented (the documentation isn’t specific to production, so, fair enough).