Page MenuHomePhabricator
Create Task
Maniphest T188299

Schema change for refactored actor storage
Closed, ResolvedPublic
Actions

Description

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

  1. ALTERs to run: https://gerrit.wikimedia.org/r/#/c/380669/48/maintenance/archives/patch-actor-table.sql, minus the changes to the image table that are already being done per T187089#3966227
  2. Where to run those changes: all.dblist
  3. When to run those changes: No time constraint.
  4. If the schema change is backwards compatible: Yes. The new columns and tables won't be used until a feature flag is enabled.
  5. If the schema change has been tested already on some of the test/beta wikis: It has been auto-deployed to Beta. I haven't heard that it broke anything.
  6. if the data should be made available on the labs replicas and/or dumps: Treatment of replicas and dumps are the same.
  • All columns in the actor table can be made available without restriction. Rows must only be available if (1) actor_user refers to a visible row in the user table or (2) the row is publicly referenced from one of the _actor columns being added in this patch. Extensions converted to have _actor columns will eventually need to be added to that list. Note: From the MediaWiki side, this table should receive manly INSERTs, no UPDATEs, and DELETEs only due to potential maintenance. Also note {T91706}.
  • All columns in revision_actor_temp can be made available without restriction. Rows must only be available if the corresponding revision table row exists (join on revactor_rev = rev_id) and has (rev_deleted & 4) = 0. Note: From the MediaWiki side, this table should receive INSERTs and DELETEs but no UPDATEs.
  • All the _actor columns added to existing tables should be available under the same conditions as the corresponding _user or _user_text columns. These seem to be:
    • archive.ar_actor: Available when (ar_deleted & 4) = 0.
    • ipblocks.ipb_by_actor: Always available (whenever the row itself is).
    • image.img_actor: Always available.
    • oldimage.oi_actor: Available when (oi_deleted & 4) = 0.
    • filearchive.fa_actor: Available when (fa_deleted & 4) = 0.
    • recentchanges.rc_actor: Available when (rc_deleted & 4) = 0.
    • logging.log_actor: Available when (log_deleted & 4) = 0.

Schema change progress:

Details

SubjectRepoBranchLines +/-
db-eqiad.php: Depool db1083operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1106operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1119operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1105:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1119operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1114operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1089operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1099:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1067operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1080operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1109operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1104operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1087operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1101:3318operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1099:3318operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1104operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1092operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1078operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1077operations/mediawiki-configmaster+7 -7
db-eqiad.php: Depool db1123operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1090:3317operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1079operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1098:3317operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1101:3317operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1094operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1086operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1091operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1103:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1121operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1097:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1084operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1081operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1076operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1074operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1105:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1103:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1085operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1113:3316operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1098:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1088operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1093operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1096:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1110operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1082operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1113:3315operations/mediawiki-configmaster+6 -4
db-eqiad.php: Depool db1097:3315operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1100operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1096:3315operations/mediawiki-configmaster+6 -6
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
Stashbot added a comment.May 17 2018, 12:50 PM

Mentioned in SAL (#wikimedia-operations) [2018-05-17T12:50:30Z] <marostegui> Deploy schema change on s3 codfw primary master (db2043) this will generate lag on codfw - T191519 T188299 T190148

• Marostegui updated the task description. (Show Details)May 17 2018, 2:27 PM
• Marostegui updated the task description. (Show Details)EditedMay 18 2018, 5:28 AM

s3 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • dbstore1002
  • db1095
  • db1116
  • db1077
  • db1078
  • db1123
  • db1075
• Marostegui updated the task description. (Show Details)May 18 2018, 5:31 AM
Stashbot added a comment.May 18 2018, 5:33 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-18T05:33:25Z] <marostegui> Deploy schema change on dbstore1002:s3 - T191519 T188299 T190148

Stashbot added a comment.May 21 2018, 5:09 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-21T05:09:39Z] <marostegui> Deploy schema change on s7 primary master (db1062) - T191519 T188299 T1901482

gerritbot added a comment.May 21 2018, 5:35 AM

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

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

gerritbot added a comment.May 21 2018, 5:39 AM

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

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

Stashbot added a comment.May 21 2018, 5:40 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-21T05:40:56Z] <marostegui> Deploy schema change on db1123 - T191519 T188299 T1901482

• Marostegui updated the task description. (Show Details)May 21 2018, 7:47 AM
gerritbot added a comment.May 21 2018, 7:57 AM

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

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

gerritbot added a comment.May 21 2018, 8:00 AM

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

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

Stashbot added a comment.May 21 2018, 8:02 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-21T08:02:38Z] <marostegui> Deploy schema change on db1077 with replication, this will generate lags on labs - T191519 T188299 T1901482

gerritbot added a comment.May 22 2018, 5:03 AM

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

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

gerritbot added a comment.May 22 2018, 5:07 AM

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

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

Stashbot added a comment.May 22 2018, 5:10 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-22T05:10:33Z] <marostegui> Deploy schema change on db1078 - T191519 T188299 T1901482

Stashbot added a comment.May 22 2018, 7:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-22T07:21:26Z] <marostegui> Deploy schema change on s8 codfw master (db2045) with replication, this will generate lags on codfw - T191519 T188299 T190148

• Marostegui updated the task description. (Show Details)May 22 2018, 8:30 AM
• Marostegui added a comment.EditedMay 22 2018, 12:18 PM

s8 eqiad progress:

  • dbstore1002
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • db1095
  • db1109
  • db1104
  • db1116
  • db1101
  • db1099
  • db1092
  • db1087
  • db1071
Stashbot added a comment.May 23 2018, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-23T05:06:26Z] <marostegui> Deploy schema change on s3 primary master (db1075) - T191519 T188299 T190148

Stashbot added a comment.May 23 2018, 5:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-23T05:21:48Z] <marostegui> Deploy schema change on dbstore1002:s8 - T191519 T188299 T190148 T194273 T194270

Stashbot mentioned this in T194273: Clean up indexes of wb_terms table.May 23 2018, 5:21 AM
Stashbot mentioned this in T194270: Drop 'tmp1' index from wb_terms table in production.
gerritbot added a comment.May 23 2018, 5:35 AM

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

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

gerritbot added a comment.May 23 2018, 5:40 AM

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

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

Stashbot added a comment.May 23 2018, 5:43 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-23T05:43:48Z] <marostegui> Deploy schema change on db1092 - T191519 T188299 T190148 T194273 T194270

gerritbot added a comment.May 23 2018, 6:22 AM

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

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

gerritbot added a comment.May 23 2018, 6:36 AM

Change 434631 abandoned by Marostegui:
db-eqiad.php: Depool db1104

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

• Marostegui updated the task description. (Show Details)May 23 2018, 7:17 AM
• Marostegui updated the task description. (Show Details)May 23 2018, 8:11 AM
gerritbot added a comment.May 23 2018, 8:13 AM

Change 434640 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/434640

gerritbot added a comment.May 23 2018, 8:19 AM

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

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

Stashbot added a comment.May 23 2018, 8:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-23T08:21:11Z] <marostegui> Deploy schema change on db1099:3318 - T191519 T188299 T190148 T194270

gerritbot added a comment.May 23 2018, 9:24 AM

Change 434648 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/434648

gerritbot added a comment.May 23 2018, 9:28 AM

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

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

Stashbot added a comment.May 23 2018, 9:30 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-23T09:30:36Z] <marostegui> Deploy schema change on db1101:3318 - T191519 T188299 T190148 T194270

gerritbot added a comment.May 24 2018, 6:12 AM

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

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

gerritbot added a comment.May 24 2018, 6:16 AM

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

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

Stashbot added a comment.May 24 2018, 6:17 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T06:17:40Z] <marostegui> Deploy schema change on db1087, this will generate lag on labs on s8 - T191519 T188299 T190148 T194270

gerritbot added a comment.May 24 2018, 6:41 AM

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

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

gerritbot added a comment.May 24 2018, 6:45 AM

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

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

Stashbot added a comment.May 24 2018, 6:47 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T06:47:02Z] <marostegui> Deploy schema change on db1104 - T191519 T188299 T190148 T194270

gerritbot added a comment.May 24 2018, 7:30 AM

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

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

gerritbot added a comment.May 24 2018, 7:34 AM

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

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

Stashbot added a comment.May 24 2018, 7:36 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T07:36:27Z] <marostegui> Deploy schema change on db1109 - T191519 T188299 T190148 T194270

Stashbot added a comment.May 24 2018, 8:05 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T08:05:15Z] <marostegui> Deploy schema change on s8 primary master (db1071) - T191519 T188299 T190148 T194270

• Marostegui updated the task description. (Show Details)May 24 2018, 8:42 AM
Stashbot added a comment.May 24 2018, 8:45 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T08:45:55Z] <marostegui> Deploy schema change on s1 codfw primary master (db2048), this will generate lag on codfw - T191519 T188299 T190148

Stashbot added a comment.May 24 2018, 11:10 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T11:10:12Z] <marostegui> Deploy schema change on dbstore1002:s1 - T191519 T188299 T190148

• Marostegui updated the task description. (Show Details)EditedMay 24 2018, 11:11 AM

s1 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • db1095
  • dbstore1001
  • dbstore1002
  • db1116
  • db1080
  • db1083
  • db1089
  • db1119
  • db1067
  • db1106
  • db1099
  • db1114
  • db1105
  • db1052
gerritbot added a comment.May 24 2018, 11:13 AM

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

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

gerritbot added a comment.May 24 2018, 11:16 AM

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

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

Stashbot added a comment.May 24 2018, 11:19 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T11:19:07Z] <marostegui> Deploy schema change on db1080 - T191519 T188299 T190148

• Marostegui updated the task description. (Show Details)May 24 2018, 1:21 PM
gerritbot added a comment.May 24 2018, 1:27 PM

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

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

gerritbot added a comment.May 24 2018, 1:30 PM

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

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

Stashbot added a comment.May 24 2018, 1:33 PM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T13:33:15Z] <marostegui> Deploy schema change on db1067 - T191519 T188299 T190148

Stashbot added a comment.May 24 2018, 2:57 PM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T14:57:39Z] <marostegui> Deploy schema change on dbstore1001:s1 - T191519 T188299 T190148

gerritbot added a comment.May 24 2018, 4:01 PM

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

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

gerritbot added a comment.May 24 2018, 4:17 PM

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

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

Stashbot added a comment.May 24 2018, 4:19 PM

Mentioned in SAL (#wikimedia-operations) [2018-05-24T16:19:15Z] <marostegui> Deploy schema change on db1099:3311 - T191519 T188299 T190148

gerritbot added a comment.May 25 2018, 5:17 AM

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

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

gerritbot added a comment.May 25 2018, 5:21 AM

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

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

Stashbot added a comment.May 25 2018, 5:23 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-25T05:23:15Z] <marostegui> Deploy schema change on db1089 - T190148 T191519 T188299

gerritbot added a comment.May 25 2018, 6:52 AM

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

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

gerritbot added a comment.May 25 2018, 6:55 AM

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

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

Stashbot added a comment.May 25 2018, 6:57 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-25T06:57:14Z] <marostegui> Deploy schema change on db1114 - T190148 T191519 T188299

gerritbot added a comment.May 25 2018, 9:05 AM

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

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

gerritbot added a comment.May 25 2018, 9:08 AM

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

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

gerritbot added a comment.May 25 2018, 9:16 AM

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

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

gerritbot added a comment.May 25 2018, 9:18 AM

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

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

Stashbot added a comment.May 25 2018, 9:20 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-25T09:20:29Z] <marostegui> Deploy schema change on db1105:3311 - T190148 T191519 T188299

gerritbot added a comment.May 25 2018, 1:21 PM

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

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

gerritbot added a comment.May 25 2018, 1:25 PM

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

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

Stashbot added a comment.May 25 2018, 1:27 PM

Mentioned in SAL (#wikimedia-operations) [2018-05-25T13:27:20Z] <marostegui> Deploy schema change on db1119 - https://phabricator.wikimedia.org/T190148 https://phabricator.wikimedia.org/T191519 https://phabricator.wikimedia.org/T188299

gerritbot added a comment.May 28 2018, 5:18 AM

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

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

gerritbot added a comment.May 28 2018, 5:21 AM

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

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

Stashbot added a comment.May 28 2018, 5:23 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-28T05:23:36Z] <marostegui> Deploy schema change on db1106 with replication, this will generate lag on labs - T190148 T191519 T188299

gerritbot added a comment.May 28 2018, 7:26 AM

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

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

gerritbot added a comment.May 28 2018, 7:29 AM

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

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

Stashbot added a comment.May 28 2018, 7:31 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-28T07:31:32Z] <marostegui> Deploy schema change on db1083 - T190148 T191519 T188299

• Marostegui mentioned this in T195747: Create views for the schema change for refactored actor storage.EditedMay 28 2018, 9:10 AM
• Marostegui removed a project: Data-Services.

Only s1 master is now pending, which will be done probably on Wednesday EU morning.
I have created a different task for the labs views handling (T195747) as this task is a bit messy now with all the comments, commits etc.

Stashbot added a comment.May 30 2018, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2018-05-30T05:06:13Z] <marostegui> Deploy schema change on s1 primary master db1052 - T188299

• Marostegui closed this task as Resolved.May 30 2018, 9:11 AM
• Marostegui updated the task description. (Show Details)

All done.
Note there is still this ticket pending in regards to the actor storage refactoring: T187089

Anomie added a comment.May 30 2018, 6:51 PM

Thanks for reminding me about that, I might have forgotten that the image table was being done in that task rather than this one.

• Bstorm added a comment.May 30 2018, 7:12 PM

Are we at the point that I should deploy the change here? https://gerrit.wikimedia.org/r/#/c/431823 --presuming I fix the complaints from the jenkins-bot.

Anomie added a comment.May 30 2018, 7:14 PM

Probably not, since img_actor doesn't exist yet.

CCicalese_WMF moved this task from Watching to Done on the MediaWiki-Platform-Team-Archived (MWPT-Q4-Apr-Jun-2018) board.Jun 1 2018, 2:50 AM
gerritbot added a comment.Jul 2 2018, 4:30 PM

Change 431823 had a related patch set uploaded (by Bstorm; owner: Bstorm):
[operations/puppet@production] wiki replicas - prepare for refactored actor storage

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

• Marostegui mentioned this in T200140: Ensure labswiki and labtestwiki are up to date with MW schema changes.Jul 22 2018, 6:19 AM
• Bstorm closed subtask T195747: Create views for the schema change for refactored actor storage as Resolved.Sep 25 2019, 3:44 PM
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