Page MenuHomePhabricator
Create Task
Maniphest T195193

Schema change for ct_tag_id field to change_tag
Closed, ResolvedPublic
Actions

Description

After T190444: Add index on rc_namespace, rc_title, rc_timestamp on recentchanges table It would be great to apply this change

From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes:

  1. ALTERs to run: https://gerrit.wikimedia.org/r/#/c/432632/5/maintenance/archives/patch-change_tag-tag_id.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: ?
  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: Tested in beta cluster
  6. if the data should be made available on the labs replicas and/or dumps: Yes, data in this table is public (unless the wiki is private which we don't replicate at all)

This column will be empty and we won't write to it immediately

Schema change progress:

  • wikitech
    • labswiki (done by Reedy)
    •  labtestwiki (done by Reedy)

Details

SubjectRepoBranchLines +/-
db-eqiad.php: Depool db1077operations/mediawiki-configmaster+7 -7
db-eqiad.php: Depool db1123operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1078operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1101:3317operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1098:3317operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1090:3317operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1079operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1094operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1086operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1087operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1109operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1092operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1104operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1101:3318operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1099:3318operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1076operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1074operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1090:3312operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1105:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1103:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1122operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1106operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1080operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1119operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1067operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1114operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1083operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1105:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1089operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1099:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1121operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1091operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1084operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1081operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1103:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1097:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1113:3316operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1088operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1085operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1093operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1098:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1096:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1110operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1100operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1097:3315operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1082operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1096:3315operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1113:3315operations/mediawiki-configmaster+4 -4
db-codfw.php: Depool db2066operations/mediawiki-configmaster+1 -1
db-codfw.php: Depool db2084:3315operations/mediawiki-configmaster+6 -6
db-codfw.php: Depool db2038operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db2089:3315operations/mediawiki-configmaster+6 -6
db-codfw.php: Depool db2059operations/mediawiki-configmaster+3 -3
Show related patches Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
gerritbot added a comment.Jun 28 2018, 3:00 PM

Change 442869 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1101:3318

https://gerrit.wikimedia.org/r/442869

Stashbot added a comment.Jun 28 2018, 3:01 PM

Mentioned in SAL (#wikimedia-operations) [2018-06-28T15:01:53Z] <marostegui> Deploy schema change on db1101:3318 T191316 T192926 T89737 T195193

gerritbot added a comment.Jun 29 2018, 4:55 AM

Change 443022 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1104

https://gerrit.wikimedia.org/r/443022

gerritbot added a comment.Jun 29 2018, 5:00 AM

Change 443022 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1104

https://gerrit.wikimedia.org/r/443022

Stashbot added a comment.Jun 29 2018, 5:02 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-29T05:02:02Z] <marostegui> Deploy schema change on db1104 T191316 T192926 T89737 T195193

gerritbot added a comment.Jun 29 2018, 10:15 AM

Change 443067 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1092

https://gerrit.wikimedia.org/r/443067

gerritbot added a comment.Jun 29 2018, 10:18 AM

Change 443067 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1092

https://gerrit.wikimedia.org/r/443067

Stashbot added a comment.Jun 29 2018, 10:20 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-29T10:20:01Z] <marostegui> Deploy schema change on db1092 T191316 T192926 T89737 T195193

• Vvjjkkii renamed this task from Schema change for ct_tag_id field to change_tag to alcaaaaaaa.Jul 1 2018, 1:08 AM
• Vvjjkkii removed Marostegui as the assignee of this task.
• Vvjjkkii raised the priority of this task from Medium to High.
• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).
• Vvjjkkii updated the task description. (Show Details)
• Vvjjkkii removed subscribers: Aklapper, gerritbot.
Marostegui renamed this task from alcaaaaaaa to Schema change for ct_tag_id field to change_tag".Jul 1 2018, 6:51 PM
Marostegui claimed this task.
Marostegui lowered the priority of this task from High to Medium.
Marostegui removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)
Marostegui added subscribers: Aklapper, GerritBot.
gerritbot added a comment.Jul 2 2018, 4:50 AM

Change 443345 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1087

https://gerrit.wikimedia.org/r/443345

gerritbot added a comment.Jul 2 2018, 4:56 AM

Change 443345 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1109

https://gerrit.wikimedia.org/r/443345

Stashbot added a comment.Jul 2 2018, 4:59 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-02T04:59:10Z] <marostegui> Deploy schema change on db1109 T191316 T192926 T89737 T195193

matej_suchanek renamed this task from Schema change for ct_tag_id field to change_tag" to Schema change for ct_tag_id field to change_tag.Jul 2 2018, 7:54 AM
gerritbot added a comment.Jul 2 2018, 9:07 AM

Change 443379 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1092

https://gerrit.wikimedia.org/r/443379

gerritbot added a comment.Jul 2 2018, 9:13 AM

Change 443379 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1087

https://gerrit.wikimedia.org/r/443379

Stashbot added a comment.Jul 2 2018, 9:24 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-02T09:24:00Z] <marostegui> Deploy schema change on db1087 with replication, this will generate lag on s8 on labs T191316 T192926 T89737 T195193

Stashbot added a comment.Jul 2 2018, 12:49 PM

Mentioned in SAL (#wikimedia-operations) [2018-07-02T12:49:28Z] <marostegui> Deploy schema change on s7 codfw master (db2040) with replication, this will generate lag on s7 codfw T191316 T192926 T89737 T195193

Marostegui updated the task description. (Show Details)Jul 2 2018, 3:35 PM
Stashbot added a comment.Jul 2 2018, 3:38 PM

Mentioned in SAL (#wikimedia-operations) [2018-07-02T15:38:26Z] <marostegui> Deploy schema change on dbstore1002:s7 T191316 T192926 T89737 T195193 T197459

Stashbot mentioned this in T197459: Optimize logging table.Jul 2 2018, 3:38 PM
Marostegui added a comment.EditedJul 2 2018, 3:42 PM

s7 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • db1125
  • dbstore1002
  • db1079
  • db1086
  • db1090
  • db1094
  • db1098
  • db1101
  • db1062
Marostegui updated the task description. (Show Details)Jul 2 2018, 3:42 PM
Stashbot added a comment.Jul 3 2018, 4:27 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T04:27:19Z] <marostegui> Deploy schema change on s2 primary master db1066 T191316 T192926 T195193

gerritbot added a comment.Jul 3 2018, 4:36 AM

Change 443537 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1086

https://gerrit.wikimedia.org/r/443537

gerritbot added a comment.Jul 3 2018, 4:38 AM

Change 443537 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1086

https://gerrit.wikimedia.org/r/443537

Stashbot added a comment.Jul 3 2018, 4:40 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T04:40:21Z] <marostegui> Deploy schema change on db1086 T191316 T192926 T89737 T195193 T197459

Marostegui updated the task description. (Show Details)Jul 3 2018, 5:04 AM
Stashbot added a comment.Jul 3 2018, 5:04 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T05:04:44Z] <marostegui> Deploy schema change on s8 primary master db1071 T191316 T192926 T195193

gerritbot added a comment.Jul 3 2018, 5:22 AM

Change 443544 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1094

https://gerrit.wikimedia.org/r/443544

gerritbot added a comment.Jul 3 2018, 5:25 AM

Change 443544 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1094

https://gerrit.wikimedia.org/r/443544

Stashbot added a comment.Jul 3 2018, 5:26 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T05:26:33Z] <marostegui> Deploy schema change on db1094 T191316 T192926 T89737 T195193 T197459

gerritbot added a comment.Jul 3 2018, 6:08 AM

Change 443547 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1079

https://gerrit.wikimedia.org/r/443547

gerritbot added a comment.Jul 3 2018, 6:13 AM

Change 443547 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1079

https://gerrit.wikimedia.org/r/443547

Stashbot added a comment.Jul 3 2018, 6:14 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T06:14:24Z] <marostegui> Deploy schema change on db1079 with replication, this will generate lag on s7 on labsdb hosts T191316 T192926 T89737 T195193 T197459

gerritbot added a comment.Jul 3 2018, 7:09 AM

Change 443554 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1090:3317

https://gerrit.wikimedia.org/r/443554

gerritbot added a comment.Jul 3 2018, 7:12 AM

Change 443554 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1090:3317

https://gerrit.wikimedia.org/r/443554

Stashbot added a comment.Jul 3 2018, 7:13 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T07:13:34Z] <marostegui> Deploy schema change on db1090:3317 T191316 T192926 T89737 T195193 T197459

Marostegui updated the task description. (Show Details)Jul 3 2018, 7:25 AM
gerritbot added a comment.Jul 3 2018, 9:08 AM

Change 443577 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1098:3317

https://gerrit.wikimedia.org/r/443577

gerritbot added a comment.Jul 3 2018, 9:12 AM

Change 443577 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1098:3317

https://gerrit.wikimedia.org/r/443577

Stashbot added a comment.Jul 3 2018, 9:13 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T09:13:13Z] <marostegui> Deploy schema change on db1098:3317 T191316 T192926 T89737 T195193 T197459

Stashbot added a comment.Jul 3 2018, 9:59 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T09:58:59Z] <marostegui> Deploy schema change on s3 codfw primary master (db2043) with replication, this will generate lag on s3 codfw T191316 T192926 T89737 T195193 T197459

Marostegui updated the task description. (Show Details)Jul 3 2018, 12:59 PM
Stashbot added a comment.Jul 3 2018, 1:19 PM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T13:19:35Z] <marostegui> Deploy schema change on dbstore1002:s3 T191316 T192926 T89737 T195193

Marostegui added a comment.EditedJul 3 2018, 1:24 PM

s3 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • dbstore1002
  • db1124
  • db1077
  • db1078
  • db1123
  • db1075
Marostegui updated the task description. (Show Details)Jul 3 2018, 1:27 PM
Marostegui added a comment.Jul 3 2018, 4:07 PM

s3 is always messy, the databases that already have this changed applied as they were created before the merge and thus need to be excluded from this alter:

bnwikivoyage
idwikimedia
pmswikisource
pswikivoyage
sahwikiquote
gerritbot added a comment.Jul 4 2018, 4:53 AM

Change 443763 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1101:3317

https://gerrit.wikimedia.org/r/443763

gerritbot added a comment.Jul 4 2018, 4:57 AM

Change 443763 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1101:3317

https://gerrit.wikimedia.org/r/443763

Stashbot added a comment.Jul 4 2018, 4:59 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-04T04:59:02Z] <marostegui> Deploy schema change on db1101:3317 T191316 T192926 T89737 T195193

gerritbot added a comment.Jul 4 2018, 7:53 AM

Change 443782 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1078

https://gerrit.wikimedia.org/r/443782

gerritbot added a comment.Jul 4 2018, 7:58 AM

Change 443782 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1078

https://gerrit.wikimedia.org/r/443782

Stashbot added a comment.Jul 4 2018, 8:00 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-04T08:00:16Z] <marostegui> Deploy schema change on db1078 T191316 T192926 T89737 T195193

gerritbot added a comment.Jul 4 2018, 8:49 AM

Change 443791 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1123

https://gerrit.wikimedia.org/r/443791

gerritbot added a comment.Jul 4 2018, 8:52 AM

Change 443791 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1123

https://gerrit.wikimedia.org/r/443791

Stashbot added a comment.Jul 4 2018, 8:54 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-04T08:54:03Z] <marostegui> Deploy schema change on db1123 T191316 T192926 T89737 T195193

gerritbot added a comment.Jul 4 2018, 10:35 AM

Change 443815 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1077

https://gerrit.wikimedia.org/r/443815

gerritbot added a comment.Jul 4 2018, 10:38 AM

Change 443815 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1077

https://gerrit.wikimedia.org/r/443815

Stashbot added a comment.Jul 4 2018, 10:46 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-04T10:46:34Z] <marostegui> Deploy schema change on db1077 with replication, this will generate lag on labs s3 T191316 T192926 T89737 T195193

daniel unsubscribed.Jul 4 2018, 11:33 AM
Stashbot added a comment.Jul 5 2018, 4:42 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-05T04:42:04Z] <marostegui> Deploy schema change on s7 primary master (db1062) T191316 T192926 T195193

Marostegui updated the task description. (Show Details)Jul 5 2018, 5:27 AM
Stashbot added a comment.Jul 5 2018, 5:29 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-05T05:29:07Z] <marostegui> Deploy schema change on s3 primary master (db1075) T191316 T192926 T195193

Marostegui updated the task description. (Show Details)Jul 5 2018, 6:03 AM
Marostegui added a comment.Jul 5 2018, 6:07 AM

This is all done.
I am not closing this task because s1 master is still pending and will be failed over the 18th July (T197069) to a host that already have the schema change, once that is failed over, I will close this task.

Ladsgroup added a comment.Jul 5 2018, 10:34 AM

Thank you!

Stashbot added a comment.Jul 18 2018, 7:25 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-18T07:25:33Z] <marostegui> Deploy schema change on db1052 - https://phabricator.wikimedia.org/T191316 https://phabricator.wikimedia.org/T192926 https://phabricator.wikimedia.org/T89737 https://phabricator.wikimedia.org/T195193

Marostegui added a comment.Jul 18 2018, 11:02 AM

db1052 was failed over today and now got the schema change so this is all done.

Marostegui closed this task as Resolved.Jul 18 2018, 11:03 AM
Marostegui updated the task description. (Show Details)
Reedy reopened this task as Open.Jul 21 2018, 10:21 PM
Reedy subscribed.

Looks like labswiki was forgotten about. Causing T200139

Possibly labtestwiki too?

Do other schema changes get applied there?

Reedy closed this task as Resolved.Jul 21 2018, 10:29 PM
Marostegui updated the task description. (Show Details)Jul 22 2018, 5:59 AM
Marostegui mentioned this in T200140: Ensure labswiki and labtestwiki are up to date with MW schema changes.Jul 22 2018, 6:09 AM
Ladsgroup closed subtask T199818: Replicate ct_tag_id to labs as Resolved.Aug 10 2018, 12:39 PM
Marostegui mentioned this in T202904: advisorswiki is not in any s?.dblist.Aug 28 2018, 7:37 AM
Stashbot added a comment.Aug 28 2018, 7:41 AM

Mentioned in SAL (#wikimedia-operations) [2018-08-28T07:41:56Z] <marostegui> Deploy schema change on s3:advisorswiki - T202904 https://phabricator.wikimedia.org/T195193

Marostegui added a comment.Sep 27 2018, 8:43 AM

labtestwiki wasn't done. I just did it.

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:41 PM
Aklapper edited subscribers, added: gerritbot; removed: GerritBot.May 16 2023, 10:18 AM
Restricted Application added a project: Performance-Team. · View Herald TranscriptMay 16 2023, 10:18 AM
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