Last modified: 2011-01-25 01:49:22 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T20488, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 18488 - Run refreshCategoryCounts.php on all WMF wikis
Run refreshCategoryCounts.php on all WMF wikis
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
All All
: Normal enhancement with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
: shell
Depends on: 17155
Blocks: 16660
  Show dependency treegraph
Reported: 2009-04-16 20:10 UTC by Happy-melon
Modified: 2011-01-25 01:49 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Adds a new maintenance script refreshCategoryCounts.php (4.04 KB, patch)
2009-04-16 20:10 UTC, Happy-melon

Description Happy-melon 2009-04-16 20:10:56 UTC
Created attachment 6031 [details]
Adds a new maintenance script refreshCategoryCounts.php

Following bug17155, the category population counts on WMF wikis aren't getting any *more* inaccurate, but they also aren't getting any more correct.  A maintenance script needs to be run to refresh the cat_pages, cat_subcats and cat_files fields of the category table.  I *think* that /maintenance/populateCategory.php would work, but that's not really what it was designed for, and it's certainly not the most efficient way of doing it.  I've adapted it into a new script.  So the "patch need-review" keywords are for someone to check that I haven't made some silly mistake on the patch, and commit it to svn.  Then the "shell" is for someone to run it on all WMF wikis.  If Simetrical did his job properly (:D) it should be easy on the servers.
Comment 1 Max Semenik 2010-05-10 15:49:47 UTC
Maintenance script committed in r66140
Comment 2 Roan Kattouw 2010-05-12 14:08:08 UTC
I've run this script on all wikis except Commons over the past 2 days. Attempting to run it on Commons during peak time results in a database deadlock error before it even gets to 1000 categories, presumably because there's so much category-related activity going on on Commons. I will see about running it at a quieter time.
Comment 3 Roan Kattouw 2010-05-13 11:29:47 UTC
Made a modification suggested by Aryeh Gregor and ran the script on Commons this morning (UTC). Completed with only a single deadlock error.

Note You need to log in before you can comment on or make changes to this bug.