Page MenuHomePhabricator

Run updateCollation.php on the Wikimedia Incubator
Closed, ResolvedPublic

Description

Once T315551 is closed and deployed, we must run php updateCollation.php --force on the Wikimedia Incubator in concordance with the hook manual.

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).