Page MenuHomePhabricator

Add primary key and drop unique index on cn_notice_languages on wmf wikis
Closed, ResolvedPublic

Description

Apply T312270 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralNotice/+/817879/3/sql/mysql/patch-cn_notice_languages-unique-to-pk.sql
  2. Where to run those changes: centralnotice
  3. When to run those changes: any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta already running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Due to a bug in the schema change generator (T314138) the DROP + ALTER should be rewritten to be atomic:

alter table cn_notice_languages drop key nl_notice_id_language, ADD  PRIMARY KEY (nl_notice_id, nl_language);

Event Timeline

Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Ready on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2023-01-04T14:10:07Z] <marostegui> dbmaint deploy schema change on s7 T326225

Mentioned in SAL (#wikimedia-operations) [2023-01-04T14:10:57Z] <marostegui> dbmaint deploy schema change on s7 eqiad T326225