Page MenuHomePhabricator
Create Task
Maniphest T273359

Schema change for renaming name_title_timestamp on archive table
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:https://gerrit.wikimedia.org/r/c/mediawiki/core/+/657957/5/maintenance/archives/patch-archive-rename-name_title_timestamp-index.sql
  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: NA

Progress

Related Objects

Event Timeline

Ladsgroup created this task.Jan 30 2021, 12:38 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 30 2021, 12:39 PM
Marostegui triaged this task as Medium priority.Feb 9 2021, 11:36 AM
Marostegui subscribed.

Nothing comes up on codesearch regarding forcing this index.

Marostegui claimed this task.Feb 15 2021, 7:58 AM
Marostegui added a project: DBA.
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.
Marostegui updated the task description. (Show Details)
Marostegui added a comment.EditedFeb 15 2021, 8:04 AM

Altered first db1098:3316 and will leave it for 24h to see if any errors show up
s6 progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1005
  • db2141
  • db2129
  • db2124
  • db2117
  • db2114
  • db2097
  • db2095
  • db2089
  • db2087
  • db2076
  • db1173
  • db1155
  • db1140
  • db1139
  • db1131
  • db1125
  • db1113
  • db1098
  • db1096
  • db1088
  • db1085
  • clouddb1019
  • clouddb1015
Marostegui updated the task description. (Show Details)Feb 15 2021, 8:05 AM
# for i in frwiki jawiki ruwiki; do echo $i; mysql.py -hdb1098:3316 $i -e "show create table archive\G" | grep title_timestamp ; done
frwiki
  KEY `ar_name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`)
jawiki
  KEY `ar_name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`)
ruwiki
  KEY `ar_name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`)
Stashbot added a comment.Feb 16 2021, 8:30 AM

Mentioned in SAL (#wikimedia-operations) [2021-02-16T08:30:56Z] <marostegui> Deploy schema change on s6 codfw - T273359

Marostegui updated the task description. (Show Details)Feb 16 2021, 12:00 PM
Stashbot added a comment.Feb 16 2021, 12:06 PM

Mentioned in SAL (#wikimedia-operations) [2021-02-16T12:06:06Z] <marostegui> Deploy schema change on s5 codfw - T273359

Marostegui updated the task description. (Show Details)Feb 16 2021, 12:08 PM
Marostegui added a comment.EditedFeb 16 2021, 12:26 PM

s5 eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1003
  • db1154
  • db1150
  • db1145
  • db1144
  • db1130
  • db1124
  • db1113
  • db1110
  • db1100
  • db1096
  • db1082
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)Feb 16 2021, 1:36 PM
Marostegui updated the task description. (Show Details)Feb 16 2021, 1:39 PM
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Feb 16 2021, 1:40 PM

Mentioned in SAL (#wikimedia-operations) [2021-02-16T13:40:31Z] <marostegui> Deploy schema change on s2 codfw - T273359

Marostegui updated the task description. (Show Details)Feb 16 2021, 1:41 PM
Marostegui added a comment.EditedFeb 16 2021, 1:54 PM

s2 eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1004
  • db1171
  • db1170
  • db1162
  • db1155
  • db1146
  • db1129
  • db1125
  • db1122
  • db1105
  • db1090
  • db1076
  • db1074
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)Feb 16 2021, 1:57 PM
Marostegui updated the task description. (Show Details)Feb 17 2021, 8:06 AM
Marostegui updated the task description. (Show Details)Feb 17 2021, 8:47 AM
Marostegui added a comment.EditedFeb 17 2021, 9:25 AM

s4 eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1004
  • db1160
  • db1155
  • db1150
  • db1149
  • db1148
  • db1147
  • db1146
  • db1145
  • db1144
  • db1143
  • db1142
  • db1141
  • db1138
  • db1125
  • db1121
  • clouddb1019
  • clouddb1015
Marostegui updated the task description. (Show Details)Feb 17 2021, 10:29 AM
Marostegui updated the task description. (Show Details)EditedFeb 17 2021, 11:20 AM

s8 eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1005
  • db1172
  • db1154
  • db1126
  • db1124
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • db1092
  • db1087
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)Feb 17 2021, 11:54 AM
Marostegui updated the task description. (Show Details)Feb 17 2021, 2:22 PM
Marostegui added a comment.EditedFeb 17 2021, 2:31 PM

s7 progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1003
  • db1174
  • db1170
  • db1155
  • db1136
  • db1127
  • db1125
  • db1116
  • db1101
  • db1098
  • db1090
  • db1086
  • db1079
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)Feb 17 2021, 2:45 PM
Marostegui updated the task description. (Show Details)Feb 22 2021, 7:46 AM
Marostegui added a comment.EditedFeb 22 2021, 8:16 AM

s1 eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1003
  • db1169
  • db1163
  • db1154
  • db1140
  • db1139
  • db1135
  • db1134
  • db1133
  • db1124
  • db1119
  • db1118
  • db1106
  • db1105
  • db1099
  • db1084
  • db1083
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Feb 22 2021, 8:16 AM
Marostegui updated the task description. (Show Details)Feb 22 2021, 9:34 AM
Stashbot added a comment.Feb 22 2021, 9:35 AM

Mentioned in SAL (#wikimedia-operations) [2021-02-22T09:35:42Z] <marostegui> Deploy schema change on s3 codfw master, there will be lag on s3 codfw - T273359

Marostegui updated the task description. (Show Details)Feb 22 2021, 9:50 AM
Marostegui added a comment.EditedFeb 22 2021, 9:56 AM

s3 progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1004
  • db1175
  • db1171
  • db1166
  • db1157
  • db1154
  • db1124
  • db1123
  • db1112
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Feb 22 2021, 9:56 AM
Marostegui added a comment.Feb 25 2021, 6:24 AM

Started on s3 master - will take around 15h

Ladsgroup added a comment.Feb 25 2021, 6:25 AM

Thank you so much!

Marostegui closed this task as Resolved.Feb 26 2021, 5:52 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