Page MenuHomePhabricator
Create Task
Maniphest T282371

Schema change for dropping default of ar_timestamp
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 archive ALTER ar_timestamp 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: I think archive is not replicated to labs at all.

Progress:

  • labswiki
  • labtestwiki

Related Objects

Event Timeline

Ladsgroup created this task.May 9 2021, 11:49 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 9 2021, 11:49 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:23 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:59 AM
• Marostegui updated the task description. (Show Details)May 26 2021, 9:48 AM
• Marostegui added a comment.EditedMay 27 2021, 6:48 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:08 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:02 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
Stashbot mentioned this in T282373: Schema change for dropping default of user_touched.

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

• 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:30 PM
• Marostegui closed this task as Resolved.Jun 4 2021, 5:06 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