Page MenuHomePhabricator
Create Task
Maniphest T270053

Increase size of content_models.model_id
Closed, ResolvedPublic
Actions

Description

(Part of T230428: Migrate tables.sql to abstract schema)

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/619155/5/maintenance/archives/patch-content_models-model_id.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: Yes, data in this table is public

This field previously was SMALLINT, it should be INT now.

Related Objects

Event Timeline

Ladsgroup created this task.Dec 13 2020, 7:27 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 13 2020, 7:27 PM
LSobanski added a subscriber: LSobanski.Dec 14 2020, 10:21 AM
LSobanski triaged this task as Medium priority.Dec 14 2020, 10:23 AM
LSobanski moved this task from Triage to Ready on the DBA board.
Marostegui claimed this task.Dec 16 2020, 10:27 AM
Marostegui moved this task from Ready to In progress on the DBA board.Mon, Jan 4, 8:53 AM
Marostegui updated the task description. (Show Details)Mon, Jan 4, 8:55 AM

This schema change cannot be done ONLINE as it changes the datatype of the column. However, the table looks small enough (at least on enwiki) that it can be applied directly on the master with replication enabled.

Marostegui added a comment.Mon, Jan 4, 8:57 AM

@Ladsgroup looks good?:

mysql:root@localhost [labtestwiki]> show create table content_models\G
*************************** 1. row ***************************
       Table: content_models
Create Table: CREATE TABLE `content_models` (
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_name` varbinary(64) NOT NULL,
  PRIMARY KEY (`model_id`),
  UNIQUE KEY `model_name` (`model_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=binary
Marostegui updated the task description. (Show Details)Mon, Jan 4, 8:57 AM
Ladsgroup added a comment.Mon, Jan 4, 9:20 AM

LGTM

Marostegui added a comment.Mon, Jan 4, 9:22 AM

Thanks I will deploy it to s6 and let it run for a couple of days to make sure nothing strange comes up.

Marostegui added a comment.Mon, Jan 4, 9:38 AM

s6 is done, let's see if we find issues:

# /home/marostegui/section s6 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port ruwiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1005.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2141.codfw.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2129.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2124.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2117.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2114.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2097.codfw.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2095.codfw.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2089.codfw.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2087.codfw.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2076.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1140.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1139.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1131.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1125.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1113.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1098.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1096.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1093.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1088.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1085.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1019.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1015.eqiad.wmnet:3316
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Mon, Jan 4, 9:38 AM
Marostegui updated the task description. (Show Details)Mon, Jan 4, 9:50 AM
Marostegui updated the task description. (Show Details)Tue, Jan 5, 6:37 AM
Marostegui added a comment.Tue, Jan 5, 6:39 AM

s5 is done:

# /home/marostegui/section s5 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port dewiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1003.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2139.codfw.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2137.codfw.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2128.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2123.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2113.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2111.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2099.codfw.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2094.codfw.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2089.codfw.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2075.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1154.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1150.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1145.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1144.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1130.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1124.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1113.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1110.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1100.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1096.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1082.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1020.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1016.eqiad.wmnet:3315
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Tue, Jan 5, 6:39 AM
Marostegui added a comment.Tue, Jan 5, 6:43 AM

wikitech done:

root@db1128.eqiad.wmnet[labswiki]> ALTER TABLE /*_*/content_models
    ->   MODIFY model_id INT AUTO_INCREMENT NOT NULL;
Query OK, 9 rows affected (0.006 sec)
Records: 9  Duplicates: 0  Warnings: 0
Marostegui updated the task description. (Show Details)Tue, Jan 5, 6:44 AM
Marostegui updated the task description. (Show Details)Thu, Jan 7, 7:29 AM

s4 done

# /home/marostegui/section s4 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port commonswiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1004.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2140.codfw.wmnet:3306
ERROR 2002 (HY000): Can't connect to MySQL server on 'db2140.codfw.wmnet' (115)
db2139.codfw.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2138.codfw.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2137.codfw.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2136.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2119.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2110.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2106.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2099.codfw.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2095.codfw.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2090.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2073.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1150.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1149.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1148.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1147.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1146.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1145.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1144.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1143.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1142.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1141.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1138.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1125.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1121.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1081.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1019.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1015.eqiad.wmnet:3314
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Thu, Jan 7, 7:31 AM
Stashbot added a comment.Thu, Jan 7, 12:24 PM

Mentioned in SAL (#wikimedia-operations) [2021-01-07T12:24:21Z] <marostegui> Deploy schema change on s2 primary master with replication T270053

Marostegui updated the task description. (Show Details)Thu, Jan 7, 12:40 PM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Thu, Jan 7, 12:43 PM

s2 done

# /home/marostegui/section s2 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port nlwiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1004.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2138.codfw.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2126.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2125.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2108.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2107.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2104.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2098.codfw.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2095.codfw.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2088.codfw.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1155.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1146.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1129.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1125.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1122.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1105.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1095.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1090.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1076.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1074.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1018.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1014.eqiad.wmnet:3312
  `model_id` int(11) NOT NULL AUTO_INCREMENT,

s8 done

#  /home/marostegui/section s8 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port wikidatawiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1005.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2100.codfw.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2094.codfw.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2091.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2086.codfw.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2085.codfw.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2084.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2083.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2082.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2081.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2080.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2079.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1154.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1126.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1124.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1116.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1114.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1111.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1109.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1104.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1101.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1099.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1092.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1087.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1020.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1016.eqiad.wmnet:3318
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Thu, Jan 7, 12:44 PM
Marostegui added a comment.Thu, Jan 7, 1:35 PM

s7 done

# /home/marostegui/section s7 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port eswiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1003.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2122.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2121.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2120.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2118.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2100.codfw.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2095.codfw.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2087.codfw.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2086.codfw.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2077.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1136.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1127.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1125.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1116.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1101.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1098.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1094.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1090.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1086.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1079.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1018.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1014.eqiad.wmnet:3317
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Thu, Jan 7, 1:35 PM

s1 done

# /home/marostegui/section s1 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port enwiki -e "show create table content_models\G" | grep "model_id" | grep "AUTO"; done
labsdb1012.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1011.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1010.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
labsdb1009.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
dbstore1003.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2141.codfw.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2130.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2116.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2112.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2103.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2102.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2097.codfw.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2094.codfw.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2092.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2088.codfw.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2085.codfw.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2072.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db2071.codfw.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1154.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1140.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1139.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1135.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1134.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1133.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1124.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1119.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1118.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1106.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1105.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1099.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1089.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1084.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
db1083.eqiad.wmnet:3306
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1017.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
clouddb1013.eqiad.wmnet:3311
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
Marostegui updated the task description. (Show Details)Thu, Jan 7, 1:39 PM

I have started the schema change on s3 - it will take around 8h to complete

Marostegui closed this task as Resolved.Fri, Jan 8, 5:48 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