I found these drifts:
"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:
- s1 (doesn't have the fields)
- s2
- eqiad T250066#6224703
- codfw
- s3
- eqiad T250066#6234576
- codfw
- s4 (doesn't have the fields)
- s5
- eqiad T250066#6223160
- codfw
- s6
- eqiad T250066#6218350
- codfw
- s7
- eqiad T250066#6231128
- codfw
- s8 (doesn't have the fields)
- labswiki (doesn't have the fields)
- labtestwiki (doesn't have the fields)