Changing product and component, this is a WMF issue

Not sure what the cl_timestamp key has to do with anything. Wikimedia appears to be missing patch-categorylinksindex.sql, from bug 10280. That is, it has an index called cl_sortkey already, but it is (cl_to,cl_sortkey) instead of (cl_to,cl_sortkey,cl_from).

(In reply to comment #2)

Not sure what the cl_timestamp key has to do with anything. Wikimedia appears
to be missing patch-categorylinksindex.sql, from bug 10280. That is, it has an
index called cl_sortkey already, but it is (cl_to,cl_sortkey) instead of
(cl_to,cl_sortkey,cl_from).

Yeah, that's probably what I meant; the cl_timestamp thing must've been a mistake.

mhershberger wrote:

Unassigning default assignments. http://article.gmane.org/gmane.science.linguistics.wikipedia.technical/54734

Most probably fixed in r83814 and following commits.

• This bug has been marked as a duplicate of bug 27965 ***

(In reply to comment #5)

Most probably fixed in r83814 and following commits.

• This bug has been marked as a duplicate of bug 27965 ***

You sure? the issues don't sound that related to me.

We should have now this:

CREATE INDEX /*i*/cl_sortkey ON /*_*/categorylinks (cl_to,cl_type,cl_sortkey,cl_from);

in production, otherwise it would have problems with not using the index.

Paging a sorted categorylinks was pretty broken here anyway.

(In reply to comment #7)

We should have now this:

CREATE INDEX /*i*/cl_sortkey ON /*_*/categorylinks
(cl_to,cl_type,cl_sortkey,cl_from);

in production, otherwise it would have problems with not using the index.

Paging a sorted categorylinks was pretty broken here anyway.

Good point.