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 added a subscriber: LSobanski.

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 added a subscriber: Marostegui.

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