Page MenuHomePhabricator
Create Task
Maniphest T302660

Adjust the field type of renameuser_queue timestamp columns to fixed binary on wmf wikis
Closed, ResolvedPublic
Actions

Description

Apply parts of T300576 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralAuth/+/762531/3/db_patches/patch-renameuser_queue-timestamp.sql
  2. Where to run those changes: centralauth databases (s7)
  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 cluster is 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

Related Objects

Event Timeline

Umherirrender created this task.Feb 26 2022, 7:24 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 26 2022, 7:24 AM
Stashbot added a comment.Feb 26 2022, 1:24 PM

Mentioned in SAL (#wikimedia-releng) [2022-02-26T13:24:48Z] <zabe> apply T302660 on deployment-prep centralauth databases

Umherirrender triaged this task as Lowest priority.Feb 26 2022, 3:34 PM
Zabe subscribed.Feb 26 2022, 3:43 PM
Zabe updated the task description. (Show Details)Feb 26 2022, 8:33 PM
Marostegui moved this task from Triage to Ready on the DBA board.Mar 7 2022, 6:08 AM
Marostegui closed this task as Resolved.Mar 7 2022, 6:31 AM
Marostegui claimed this task.
Marostegui subscribed.

As this table is really small I have executed this directly on the master with replication enabled.

dbstore1003.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2150.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2122.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2121.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2120.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2118.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2108.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2098.codfw.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2095.codfw.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2087.codfw.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2086.codfw.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db2077.codfw.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1181.eqiad.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1174.eqiad.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1171.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1170.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1158.eqiad.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1155.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1136.eqiad.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1127.eqiad.wmnet:3306
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1101.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
db1098.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
clouddb1021.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
clouddb1018.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
clouddb1014.eqiad.wmnet:3317
  `rq_requested_ts` binary(14) DEFAULT NULL,
  `rq_completed_ts` binary(14) DEFAULT NULL,
  KEY `rq_requested_ts` (`rq_requested_ts`)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL