Page MenuHomePhabricator

Orphaned entries in categorylinks
Open, Needs TriagePublic

Description

On plwiki there are some orphaned entries in table categorylinks. Category is empty and these pages are not in this category anymore. Probably it is releated with page moving, redirects, tagging redirects for deletion, moving over redirects.

https://quarry.wmflabs.org/query/31908

Event Timeline

Wargo created this task.May 23 2019, 8:40 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 23 2019, 8:40 AM
Marostegui edited projects, added MediaWiki-General; removed DBA.May 23 2019, 8:45 AM
Marostegui added a subscriber: Marostegui.

So I can confirm this has the same results in production, so consistency across labs and production is the same, which was my initial concern.
Not sure what is the fix for this, but I am not sure we DBAs can act on it, as it seems more wiki related.

Can you give more details on what needs to be done?

Wargo added a comment.May 23 2019, 8:56 AM

Can you give more details on what needs to be done?

Entries about these pages (linked in categorylinks) should not exists because these pages were removed from this category. So MediaWiki code for categorylinks update not always working after decategorisation.

Thanks, let's tag MediaWiki-Database to see if the Core Platform Team can check it out

This might be caused by T221980. It seems that in general, neither categorylinks table rows nor recentchanges entries are correctly deleted when a page is deleted to make way for a move from another title.

JJMC89 added a subscriber: JJMC89.Fri, Jul 12, 3:58 AM