Page MenuHomePhabricator

Purging a category should update the count of its subcategories
Open, Needs TriagePublicBUG REPORT

Description

Steps to replicate the issue (include links if applicable):

What happens?:

  • Subcategory counts don't update when viewing the category

What should have happened instead?:

  • Subcategory counts should update

Software version (skip for WMF-hosted wikis like Wikipedia):

Other information (browser name/version, screenshots, etc.):

  • Purging the subcategory doesn't work either
  • I assume you'd have to null edit some of the subcategory pages to force this update?
  • Is there a way we can just have purging the category update this instead? Maybe with some kind of timeout or subcategory limit or something to keep it from being too expensive?

image.png (854×617 px, 63 KB)

Event Timeline

The parent category is https://en.wikipedia.org/wiki/Category:Speedy_deletion, not https://en.wikipedia.org/wiki/Category:Candidates_for_speedy_deletion

Category:Candidates_for_speedy_deletion uses PAGESINCATEGORY to show the number, which uses the counts when the page gets parsed.

The count "2" is correct after purge at the moment, at least the replica shows there are two entries in the links table

MariaDB [enwiki_p]> select cl_from from categorylinks where cl_to = 'Candidates_for_speedy_deletion_as_hoaxes';
+----------+
| cl_from  |
+----------+
| 74085646 |
| 74092710 |
+----------+
2 rows in set (0.002 sec)

MariaDB [enwiki_p]> select * from page where page_id in ( 74085646 , 74092710 );
Empty set (0.002 sec)

The next run to delete such pageids is at the first day of next month

https://gerrit.wikimedia.org/g/operations/puppet/+/d682f3dbc18f06ad84be2b14ea08b6e949926307/modules/profile/manifests/mediawiki/maintenance/refreshlinks/periodic_job.pp#7