As part of T146591: Add a primary key to l10n_cache this index should have been dropped but it exists in these hosts:
{ "l10n_cache lc_lang_key index-mismatch-prod-extra": { "s1": [ "db1089.eqiad.wmnet" ], "s2": [ "db1122.eqiad.wmnet", "db1090.eqiad.wmnet" ], "s6": [ "db1131.eqiad.wmnet", "db1093.eqiad.wmnet" ], "s7": [ "db1094.eqiad.wmnet" ] } }
Please make sure that other parts of the schema change (like adding PK) is already done there.
| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Resolved | Ladsgroup | T104459 Detect object, schema and data drifts between mediawiki HEAD, production masters and replicas | ||
| Resolved | • Marostegui | T250056 lc_lang_key index is lingering in production | ||
| · · · |
s1 fixed - they extra KEY only existed on db1089 and dbstore1003:3311:
root@cumin1001:/home/marostegui# ./section s1 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port enwiki -e "show create table l10n_cache\G" | egrep "PRIMARY|KEY" | grep -v ENGINE ; done labsdb1012.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) labsdb1011.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) labsdb1010.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) labsdb1009.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) dbstore1003.eqiad.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db2130.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2116.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2112.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2103.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2097.codfw.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db2094.codfw.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db2092.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2088.codfw.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db2085.codfw.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db2072.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db2071.codfw.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1139.eqiad.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db1134.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1124.eqiad.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db1119.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1118.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1107.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1106.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1105.eqiad.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db1099.eqiad.wmnet:3311 PRIMARY KEY (`lc_lang`,`lc_key`) db1089.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1083.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`) db1080.eqiad.wmnet:3306 PRIMARY KEY (`lc_lang`,`lc_key`)