Page MenuHomePhabricator
Create Task
Maniphest T192926

Schema change to drop archive.ar_text and archive.ar_flags
Closed, ResolvedPublic
Actions

Description

I'm not applying Schema-change-in-production to this change per the advice "Other 'cleanup' schema changes (e.g. a column that is stopped being used but it is not blocking code). While those are real schema changes, if they don't block code deployments, just use the DBA tag to avoid prioritizing them over those that are actual blockers."

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

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/393929/14/maintenance/archives/patch-drop-ar_text.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: After 1.32.0-wmf.1 or later is deployed and Toolforge views are updated. No other time constraints.
  4. If the schema change is backwards compatible: Yes. As of 1.32.0-wmf.1 these columns are no longer used.
  5. If the schema change has been tested already on some of the test/beta wikis: Yes.
  6. if the data should be made available on the labs replicas and/or dumps: No new data is being added. Toolforge views need to be updated to remove reference to ar_flags, see T189141: Change `archive` view to no longer expose `ar_flags`

Schema change progress:

Details

SubjectRepoBranchLines +/-
filtered_tables: Remove ar_text and ar_flagsoperations/puppetproduction+0 -2
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 27 2018, 5:06 AM

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

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

Stashbot added a comment.Jun 27 2018, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T05:08:44Z] <marostegui> Deploy schema change on db1090:3312 T191316 T192926 T89737 T195193

gerritbot added a comment.Jun 27 2018, 8:26 AM

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

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

gerritbot added a comment.Jun 27 2018, 8:30 AM

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

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

Stashbot added a comment.Jun 27 2018, 8:33 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T08:32:59Z] <marostegui> Stop replication on db1074 to remove triggers from db1125 - T192926

Stashbot added a comment.Jun 27 2018, 8:35 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T08:35:26Z] <marostegui> Deploy schema change on db1074 with replication, this will generate lag on s2 on labsdb T191316 T192926 T89737 T195193

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

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

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

gerritbot added a comment.Jun 27 2018, 10:22 AM

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

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

Stashbot added a comment.Jun 27 2018, 10:24 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T10:24:09Z] <marostegui> Deploy schema change on db1076 T191316 T192926 T89737 T195193

Stashbot added a comment.Jun 27 2018, 11:26 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T11:26:52Z] <marostegui> Deploy schema change on s8 codfw master (db2045) with replication, this will generate lag on s8 codfw T191316 T192926 T89737 T195193

Marostegui updated the task description. (Show Details)Jun 27 2018, 4:38 PM
Stashbot added a comment.Jun 27 2018, 4:39 PM

Mentioned in SAL (#wikimedia-operations) [2018-06-27T16:39:23Z] <marostegui> Deploy schema change on dbstore1002:s8 T191316 T192926 T89737 T195193

Marostegui added a comment.EditedJun 28 2018, 4:37 AM

s8 eqiad progress

  • dbstore1002
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • db1109
  • db1104
  • db1124
  • db1101
  • db1099
  • db1092
  • db1087
  • db1071
Marostegui updated the task description. (Show Details)Jun 28 2018, 4:39 AM
gerritbot added a comment.Jun 28 2018, 4:42 AM

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

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

gerritbot added a comment.Jun 28 2018, 4:44 AM

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

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

Stashbot added a comment.Jun 28 2018, 4:46 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-28T04:46:19Z] <marostegui> Deploy schema change on db1099:3318 T191316 T192926 T89737 T195193

gerritbot added a comment.Jun 28 2018, 2:57 PM

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

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

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

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

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:17 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-02T09:17:20Z] <marostegui> Stop replication on db1087 to drop triggers on db1124 - T192926

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

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

Mentioned in SAL (#wikimedia-operations) [2018-07-02T12:50:46Z] <marostegui> Stop replication on db2077 to remove triggers from db2095 - T192926

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:41 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

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

Mentioned in SAL (#wikimedia-operations) [2018-07-03T06:16:20Z] <marostegui> Stop replication on db1079 to drop triggers on db1125:s7 - T192926

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

Marostegui added a comment.Jul 3 2018, 9:42 AM

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
Stashbot added a comment.Jul 3 2018, 9:56 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-03T09:56:47Z] <marostegui> Stop replication on db2094:3313 to replace triggers - T192926

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:57 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
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:42 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-04T10:42:21Z] <marostegui> Stop replication on db1077 to drop triggers on db1124:3313 - T192926

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

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.

Marostegui moved this task from In progress to Blocked external/Not db team on the DBA board.Jul 5 2018, 6:07 AM
gerritbot added a comment.Jul 12 2018, 9:44 AM

Change 437432 merged by Marostegui:
[operations/puppet@production] filtered_tables: Remove ar_text and ar_flags

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

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 closed this task as Resolved.Jul 18 2018, 9:41 AM
Marostegui updated the task description. (Show Details)

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

Marostegui mentioned this in T200140: Ensure labswiki and labtestwiki are up to date with MW schema changes.Jul 22 2018, 6:09 AM
Stashbot added a comment.Jul 23 2018, 8:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-23T08:21:16Z] <marostegui> Apply schema change T192926 to labswiki and labstestwiki T200140

CCicalese_WMF moved this task from Watching to Done on the Multi-Content-Revisions board.Jul 27 2018, 10:13 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:46 AM

Mentioned in SAL (#wikimedia-operations) [2018-08-28T07:46:21Z] <marostegui> Deploy schema change on s3:advisorswiki - T202904 T192926

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:41 PM
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