templatelinks table on enwiki is missing entries
Open, StalledPublic


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;




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


bzimport added a project: MediaWiki-Templates.Via ConduitNov 22 2014, 2:57 AM
bzimport added a subscriber: Unknown Object (MLST).
bzimport set Reference to bz61953.
Mr.Z-man created this task.Via LegacyFeb 26 2014, 3:54 PM
Anomie added a comment.Via ConduitFeb 27 2014, 3:24 PM

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.

Mr.Z-man added a comment.Via ConduitFeb 27 2014, 3:45 PM

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)

Anomie added a comment.Via ConduitFeb 27 2014, 6:08 PM

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.

Aklapper added a subscriber: Aklapper.Via WebApr 9 2015, 1:20 PM

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

Anomie added a comment.Via WebApr 9 2015, 2:05 PM

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".Via WebApr 9 2015, 8:37 PM
Aklapper lowered the priority of this task from "High" to "Low".

Add Comment