Page MenuHomePhabricator
Create Task
Maniphest T67448

Dropping rc_cur_time on wmf databases
Closed, ResolvedPublic
Actions

Description

A schema change was merged to master, which should be done also on wmf production servers. Maybe can be done together with T51191.

Schema Change:

All wikis
tables: recentchanges
changes: Dropping rc_cur_time

gerrit change I48989aceec31019f0b6c98aaeafaf60e975244df

Version: unspecified
Severity: minor

ALTER to run: ALTER TABLE /*$wgDBprefix*/recentchanges DROP COLUMN rc_cur_time;

Progress:

s1

  • eqiad
  • codfw

s2

s3

s4

s5

s6

s7

s8

wikitech

  • eqiad
  • codfw

Details

Reference
bz65448

Related Objects
Search...

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 3:20 AM
bzimport added projects: Wikimedia-General-or-Unknown, Schema-change.
bzimport set Reference to bz65448.
Krenair removed Springle as the assignee of this task.Oct 4 2015, 2:53 AM
Krenair added a subscriber: Krenair.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 4 2015, 2:53 AM
• Marostegui moved this task from Triage to Next on the DBA board.Jul 11 2018, 3:03 PM
• Marostegui moved this task from Next to In progress on the DBA board.Aug 7 2018, 8:43 AM
• Marostegui moved this task from Backlog to In progress on the Blocked-on-schema-change board.
Stashbot added a subscriber: Stashbot.Aug 7 2018, 9:57 AM

Mentioned in SAL (#wikimedia-operations) [2018-08-07T09:57:44Z] <marostegui> Deploy schema change on db2075 - T67448 T114117 T5119

gerritbot added a subscriber: gerritbot.Aug 7 2018, 10:10 AM

Change 450934 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] filtered_tables: Remove unused columns

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

• Marostegui added a comment.Aug 7 2018, 10:19 AM

I have removed the column from db2075 (codfw - s5) and I am going to leave it like that for a few days, to make sure nothing writes to that column. If that happens replication will break and we'll know.

• Marostegui added a comment.EditedAug 20 2018, 8:36 AM
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore2001
  • dbstore1002
  • db2094
  • db2089
  • db2084
  • db2075 T67448#4483976
  • db2066
  • db2059
  • db2052
  • db2038
  • db1124
  • db1113
  • db1110
  • db1102
  • db1100
  • db1097
  • db1096
  • db1082
  • db1070
Stashbot added a comment.Aug 22 2018, 12:15 PM

Mentioned in SAL (#wikimedia-operations) [2018-08-22T12:15:37Z] <marostegui> Deploy schema change on db1070 (s5 primary master) - T67448 T114117 T51191

• Marostegui updated the task description. (Show Details)EditedAug 22 2018, 2:21 PM

s6 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1125
  • db1113
  • db1098
  • db1096
  • db1093
  • db1088
  • db1085
  • db1061
• Marostegui added a comment.EditedAug 23 2018, 11:02 AM

s2 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1125
  • db1122
  • db1105
  • db1103
  • db1095
  • db1090
  • db1076
  • db1074
  • db1066
• Marostegui updated the task description. (Show Details)EditedAug 24 2018, 3:05 PM

s8 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1124
  • db1109
  • db1104
  • db1101
  • db1099
  • db1092
  • db1087
  • db1071
• Marostegui added a comment.EditedAug 28 2018, 5:05 AM

s4 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1125
  • db1121
  • db1103
  • db1102
  • db1097
  • db1091
  • db1084
  • db1081
  • db1068
Stashbot added a comment.Aug 29 2018, 5:55 AM

Mentioned in SAL (#wikimedia-operations) [2018-08-29T05:55:26Z] <marostegui> Deploy schema change on db1073 (labswiki) - T114117 T51191 T67448

• Marostegui added a comment.EditedSep 3 2018, 1:19 PM

s7 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1125
  • db1101
  • db1098
  • db1094
  • db1090
  • db1086
  • db1079
  • db1062
• Marostegui updated the task description. (Show Details)EditedSep 4 2018, 12:40 PM

s3 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1124
  • db1123
  • db1095
  • db1078
  • db1077
  • db1075
gerritbot added a comment.Sep 4 2018, 12:44 PM

Change 450934 merged by Marostegui:
[operations/puppet@production] filtered_tables: Remove unused columns

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

Stashbot added a comment.Sep 14 2018, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2018-09-14T07:49:20Z] <marostegui> Deploy schema change on s4 eqiad master (db1068) - T67448 T114117 T51191

Stashbot added a comment.Sep 17 2018, 5:28 AM

Mentioned in SAL (#wikimedia-operations) [2018-09-17T05:28:00Z] <marostegui> Deploy schema change on s1 eqiad master (db1067) - T67448 T114117 T51191

• Marostegui changed the task status from Open to Stalled.Oct 24 2018, 9:55 AM
• Marostegui changed the task status from Stalled to Open.
• Marostegui changed the task status from Open to Stalled.
• Marostegui moved this task from In progress to Next on the DBA board.
Pppery updated the task description. (Show Details)Oct 26 2018, 9:34 PM
• Marostegui changed the task status from Stalled to Open.Nov 12 2018, 9:09 AM
Stashbot added a comment.Nov 12 2018, 9:12 AM

Mentioned in SAL (#wikimedia-operations) [2018-11-12T09:12:41Z] <marostegui> Deploy schema change on db2048 (s1 codfw master) (replication will be stopped) - T67448

• Marostegui moved this task from Next to In progress on the DBA board.Nov 12 2018, 9:19 AM
• Marostegui closed this task as Resolved.Nov 12 2018, 9:34 AM
• Marostegui updated the task description. (Show Details)
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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