https://bugzilla.wikimedia.org/show_bug.cgi?id=17558
Summary: WMF servers missing part of cl_timestamp index, live
hack breaks list=categorymembers&cmsort=sortkey
Product: MediaWiki
Version: 1.14-svn
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: API
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected]
Depends on: 16012
The WMF servers have KEY `cl_timestamp` (`cl_to`,`cl_timestamp`) whereas
tables.sql has CREATE INDEX /*i*/cl_sortkey ON /*_*/categorylinks
(cl_to,cl_sortkey,cl_from) . The cl_from field in the index is needed to make
list=categorymembers&cmsort=sortkey non-lethal to the database servers, but
because it's not there on the WMF servers, WMF uses a live hack that breaks
paging for cmsort=sortkey completely.
The index should be updated on all WMF servers and the live hack removed.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
