Page MenuHomePhabricator

sql dump schemata - imagelinks.il_backlinks_namespace and templatelinks.tl_backlinks_namespace should be reordered
Closed, DeclinedPublic

Description

0) Context

On 2015-04-10 three backlink indexes were reordered.
See https://gerrit.wikimedia.org/r/#/c/190774/.

  1. Problem

As of 2015-06-03, sql dumps show the wrong order for the following indexes:
o image.il_backlinks_namespace; and
o templatelinks.tl_backlinks_namespace.

This means that the database schema in the sql dumps (as of 2015-06) does not agree with maintenance/tables.sql (as of 2015-06).
See https://git.wikimedia.org/blob/mediawiki%2Fcore.git/HEAD/maintenance%2Ftables.sql.

  1. Requested action

Please reorder these two indexes for future sql dumps.

Event Timeline

wpmirrordev assigned this task to ArielGlenn.
wpmirrordev raised the priority of this task from to Needs Triage.
wpmirrordev updated the task description. (Show Details)
wpmirrordev added a subscriber: wpmirrordev.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 23 2015, 6:45 PM
Umherirrender closed this task as Declined.Jan 1 2018, 1:40 PM
Umherirrender added a subscriber: Umherirrender.

The dumps represented the current state of the database, so it is possible to have other size or other order of columns due to outstanding database maintenance. This is not a problem in a relation database management system.