Page MenuHomePhabricator

templatelinks table on enwiki is missing entries
Closed, DeclinedPublic

Description

API result showing problem

I've only noticed this on Articles for Deletion log pages, but I haven't actually looked anywhere else:

As of the time I'm writing this, [[Wikipedia:Articles for deletion/Log/2014 February 18]] has 62 AFD subpages transcluded on it. However, the templatelinks table only has 12!

MariaDB [enwiki_p]> SELECT tl_title FROM templatelinks WHERE tl_from=41936498 AND tl_namespace=4;
+------------------------------------------------------------------+

tl_title

+------------------------------------------------------------------+

Articles_for_deletion/Ambrose_nshala
Articles_for_deletion/Internet_ethics
Articles_for_deletion/Jerry_Lewis_(Totally_Spies!_character)
Articles_for_deletion/John_Dealtry
Articles_for_deletion/Man_Meat_Fire
Articles_for_deletion/Richard_Horowitz
Articles_for_deletion/Rob_Honeycutt
Articles_for_deletion/Robert_Torto
Articles_for_deletion/Salming_Sports
Articles_for_deletion/Stacy_Blackman
Articles_for_deletion/Sunny_Ozell
Articles_for_deletion/The_Music_of_Nashville:_Season_2,_Volume_1

+------------------------------------------------------------------+
12 rows in set (0.03 sec)

And it's not just Labs, the API gives the same result (see attachment)


Version: 1.23.0
Severity: normal

Attached:

templatelinks.png (655×990 px, 79 KB)

Details

Reference
bz61953

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:57 AM
bzimport set Reference to bz61953.
bzimport added a subscriber: Unknown Object (MLST).

Those results appear to correspond to https://en.wikipedia.org/w/index.php?oldid=595982708, from 04:55, 18 February 2014, despite the 68 revisions since.

I see that as of now all 62 AFD subpages are listed both in templatelinks on Tool Labs, and on all the slave DBs in eqiad, and via the API https://en.wikipedia.org/w/api.php?action=query&titles=Wikipedia:Articles%20for%20deletion/Log/2014%20February%2018&prop=templates&tlnamespace=4&tllimit=max.

I don't see anything obvious that would have caused this, or that would have fixed it when the 68 actual edits to the page between 04:55, 18 February 2014 and 15:54, 26 February 2014 didn't.

Note that this has apparently been an ongoing issue on these pages for several weeks now. The first report of a problem was on Feb 12 - https://en.wikipedia.org/w/index.php?title=User_talk:Mr.Z-man&oldid=597237433#closeAFD_stopped_relisting (the script in question uses the API's list=embeddedin to find the log page for AFD subpages)

If you find a page that's currently exhibiting this bug, and particularly if it's still doing it after an edit to the page, please ping me if I'm on IRC (user anomie) so I can try to investigate while it's happening.

Is this still a problem? Is this still high priority?

If it's still a problem, it's stalled on no one having any idea what's causing it, how to reproduce it, or even what to try logging to get more data.

Aklapper changed the task status from Open to Stalled.Apr 9 2015, 8:37 PM
Aklapper lowered the priority of this task from High to Low.

No reply by original reporter - assuming this is obsolete. Please reopen if it's still reproducible and provide an URL to reproduce.