sql dump schemata - image.img_description and protected_titles.pt_reason fields should be resized
Closed, DeclinedPublic


0) Context

On 2015-03-11 all *_comment, *_description, and *_reason fields were resized.
Specifically, the data type tinyblob was replaced with varbinary(767).
See https://gerrit.wikimedia.org/r/#/c/191811/.

  1. Problem

As of 2015-06-03, sql dumps still show the wrong size for the following fields:
o image.img_description; and
o protected_titles.pt_reason.

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 resize these two fields for future sql dumps.

wpmirrordev updated the task description. (Show Details)
wpmirrordev raised the priority of this task from to Needs Triage.
wpmirrordev assigned this task to ArielGlenn.
wpmirrordev added a subscriber: wpmirrordev.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 23 2015, 6:31 PM

The schema change may not be applied to any wiki yet: T6715#1197407

Umherirrender closed this task as Declined.Jan 1 2018, 1:38 PM

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.