Page MenuHomePhabricator

Extend iwlinks.iwl_prefix to VARBINARY(32)
Open, MediumPublic

Description

Following up T275242: iwlinks.iwl_prefix should be the same length as interwiki.iw_prefix

What: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/665454/5/maintenance/archives/patch-extend-iwlinks-iwl_prefix.sql

Where: All wikis

When: At DBA's leisure

Is backwards compatible: Yes

Has been tested already: Yes

Progress

  • s1
    • eqiad
    • codfw
  • s2
    • eqiad
    • codfw
  • s3
    • eqiad
    • codfw
  • s4
    • eqiad
    • codfw
  • s5
    • eqiad
    • codfw
  • s7
    • eqiad
    • codfw
  • s8
    • eqiad
    • codfw
  • labswiki
  • labtestwiki

Event Timeline

Marostegui triaged this task as Medium priority.Mar 11 2021, 7:20 AM
Marostegui moved this task from Ready to In progress on the DBA board.

Going to deploy this on s6 on a couple of hosts in eqiad. If all goes well, I will try to deploy it entirely on codfw, so I can do eqiad once the dc switchover has happened.

root@cumin1001:/home/marostegui# mysql.py -hdb1096:3316 frwiki -e "show create table iwlinks\G"
*************************** 1. row ***************************
       Table: iwlinks
Create Table: CREATE TABLE `iwlinks` (
  `iwl_from` int(10) unsigned NOT NULL DEFAULT 0,
  `iwl_prefix` varbinary(32) NOT NULL DEFAULT '',
  `iwl_title` varbinary(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`iwl_from`,`iwl_prefix`,`iwl_title`),
  KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`),
  KEY `iwl_prefix_from_title` (`iwl_prefix`,`iwl_from`,`iwl_title`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8

s6 eqiad progress

  • dbstore1005
  • db1180
  • db1173
  • db1168
  • db1165
  • db1155
  • db1140
  • db1131
  • db1113
  • db1098
  • db1096
  • clouddb1021
  • clouddb1019
  • clouddb1015

s6 is fully done - only pending the master which will be done once eqiad is passive.

Marostegui moved this task from In progress to Blocked on the DBA board.

codfw is entirely done - waiting for the DC switch to finish everything in eqiad.