Page MenuHomePhabricator
Create Task
Maniphest T282373

Schema change for dropping default of user_touched
Closed, ResolvedPublic
Actions

Description

Part of T42626: Standardise type of timestamp database fields (MySQL) and T230428: Migrate tables.sql to abstract schema

  1. ALTERs to run: ALTER TABLE user ALTER user_touched DROP DEFAULT;
  2. Where to run those changes: all.dblist
  3. When to run those changes: At 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: Tested in beta cluster.
  6. if the data should be made available on the labs replicas and/or dumps: This column is being replicated to beta cluster AFAIK

Progress:

  • labswiki
  • labtestwiki

Related Objects

Event Timeline

Ladsgroup created this task.May 9 2021, 11:52 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 9 2021, 11:52 AM
Ladsgroup added projects: DBA, Schema-change-in-production.May 9 2021, 11:52 AM
LSobanski assigned this task to Marostegui.May 10 2021, 6:17 PM
LSobanski triaged this task as Medium priority.
LSobanski moved this task from Triage to Pending comment on the DBA board.
LSobanski subscribed.

Assigning to Manuel to confirm if this can go into Ready.

Marostegui removed Marostegui as the assignee of this task.EditedMay 11 2021, 5:24 AM
Marostegui moved this task from Pending comment to Ready on the DBA board.
Marostegui subscribed.

Yes, this can be done anytime. It doesn't require master swaps, it is an online change (metadata locking can arise though)

Marostegui claimed this task.May 21 2021, 6:17 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.EditedMay 21 2021, 6:27 AM

Altered db2089:3316 to leave it for a few days to make sure all is good

s6 progress

  • dbstore1005
  • db2141
  • db2129
  • db2124
  • db2117
  • db2114
  • db2095
  • db2089
  • db2087
  • db2076
  • db1180
  • db1173
  • db1168
  • db1165
  • db1155
  • db1140
  • db1139
  • db1131
  • db1113
  • db1098
  • db1096
  • clouddb1021
  • clouddb1019
  • clouddb1015
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.May 21 2021, 6:28 AM
Marostegui moved this task from Ready to In progress on the DBA board.
Marostegui added a comment.May 24 2021, 12:28 PM

Altered db1098:3316, leaving it for a few days before going for the whole section.

Marostegui updated the task description. (Show Details)May 25 2021, 10:13 AM
Marostegui updated the task description. (Show Details)May 25 2021, 10:27 AM
Marostegui updated the task description. (Show Details)May 25 2021, 10:33 AM
Marostegui added a comment.EditedMay 26 2021, 4:50 AM

s2 eqiad

  • dbstore1004
  • db1182
  • db1171
  • db1170
  • db1162
  • db1156
  • db1155
  • db1146
  • db1129
  • db1122
  • db1105
  • db1102
  • clouddb1021
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)May 26 2021, 4:56 AM
Marostegui updated the task description. (Show Details)May 26 2021, 4:58 AM
Marostegui updated the task description. (Show Details)May 26 2021, 9:48 AM
Marostegui added a comment.EditedMay 27 2021, 6:47 AM

s5 eqiad

  • dbstore1003
  • db1161
  • db1154
  • db1150
  • db1145
  • db1144
  • db1130
  • db1113
  • db1110
  • db1100
  • db1096
  • clouddb1021
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)May 27 2021, 6:53 AM
Marostegui updated the task description. (Show Details)May 27 2021, 7:15 AM
Marostegui updated the task description. (Show Details)May 27 2021, 8:47 AM
Marostegui added a comment.May 27 2021, 8:56 AM

s7 eqiad

  • dbstore1003
  • db1181
  • db1174
  • db1170
  • db1158
  • db1155
  • db1136
  • db1127
  • db1116
  • db1101
  • db1098
  • clouddb1021
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)May 27 2021, 9:07 AM
Marostegui updated the task description. (Show Details)Jun 1 2021, 11:40 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jun 1 2021, 12:23 PM

s8 eqiad

  • dbstore1005
  • db1178
  • db1177
  • db1172
  • db1167
  • db1154
  • db1126
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • clouddb1021
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)Jun 1 2021, 12:24 PM
Marostegui updated the task description. (Show Details)Jun 1 2021, 12:29 PM
Marostegui added a comment.EditedJun 2 2021, 5:01 AM

s4 eqiad

  • dbstore1004
  • db1160
  • db1155
  • db1150
  • db1149
  • db1148
  • db1147
  • db1146
  • db1145
  • db1144
  • db1143
  • db1142
  • db1141
  • db1138
  • db1121
  • clouddb1021
  • clouddb1019
  • clouddb1015
Marostegui updated the task description. (Show Details)Jun 2 2021, 11:42 AM
Marostegui updated the task description. (Show Details)Jun 3 2021, 9:09 AM
Marostegui added a comment.EditedJun 3 2021, 9:23 AM

s1 eqiad

  • dbstore1003
  • db1184
  • db1169
  • db1164
  • db1163
  • db1154
  • db1140
  • db1139
  • db1135
  • db1134
  • db1133
  • db1119
  • db1118
  • db1106
  • db1105
  • db1099
  • clouddb1021
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Jun 3 2021, 9:23 AM
Stashbot mentioned this in T282372: Schema change for dropping default of page_touched.Jun 3 2021, 9:38 AM

Mentioned in SAL (#wikimedia-operations) [2021-06-03T09:38:47Z] <marostegui> Deploy schema change on s3 codfw master (with replication) - T282373 T282372 T282371

Stashbot mentioned this in T282371: Schema change for dropping default of ar_timestamp.Jun 3 2021, 9:38 AM
Marostegui updated the task description. (Show Details)Jun 3 2021, 10:08 AM
Marostegui added a comment.EditedJun 3 2021, 10:17 AM

s3 eqiad

  • dbstore1004
  • db1179
  • db1175
  • db1171
  • db1166
  • db1157
  • db1154
  • db1123
  • db1112
  • db1102
  • clouddb1021
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Jun 3 2021, 12:29 PM
Marostegui closed this task as Resolved.Jun 4 2021, 11:19 AM
Marostegui updated the task description. (Show Details)

All done

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 · Credits