I found these drifts:
```lang=json
"text old_comment field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_minor_edit field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_namespace field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_timestamp field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_timestamp index-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
]
},
"text old_title field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_title index-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
]
},
"text old_user field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
"text old_user_text field-mismatch-prod-extra": {
"s2": [
"db1122.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1105.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1074.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1082.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1130.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1093.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1094.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1098.eqiad.wmnet"
]
},
```
If I remember correctly, text table was split from revision table long time ago and that's why these extra fields still exist. (Double check please)
ALTER table required: `alter table text drop column if exists old_namespace, drop column if exists old_title, drop column if exists old_comment, drop column if exists old_user, drop column if exists old_user_text, drop column if exists old_timestamp, drop column if exists old_minor_edit, drop column if exists inverse_timestamp, drop key if exists old_title;`
Schema change progress:
[x] s1 (doesn't have the fields)
[] s2
** [] eqiad
** [x] codfw
[] s3
** [] eqiad
** [] codfw
[x] s4 (doesn't have the fields)
[x] s5
** [x] eqiad T250066#6223160
** [x] codfw
[x] s6
** [x] eqiad T250066#6218350
** [x] codfw
[] s7
** [] eqiad
** [] codfw
[x] s8 (doesn't have the fields)
[x] labswiki (doesn't have the fields)
[x] labtestwiki (doesn't have the fields)