According to T174509: Drop now redundant indexes from pagelinks and templatelinks, this index should not exist anymore but the drift reporter says two hosts in s6 still have this:
...
"templatelinks tl_from index-mismatch-prod-extra": {
"s6": [
"db1098.eqiad.wmnet",
"db1096.eqiad.wmnet"
]
},
...| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Open | None | T104459 Automate the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves | ||
| Resolved | Marostegui | T252126 tl_from index on templatelinks is lingering in production | ||
| · · · |
Fixed:
root@cumin1001:/home/marostegui# for i in frwiki jawiki ruwiki; do echo $i; mysql.py -hdb1096:3316 $i -e "show create table templatelinks\G" | grep UNIQUE;done frwiki jawiki ruwiki root@cumin1001:/home/marostegui# for i in frwiki jawiki ruwiki; do echo $i; mysql.py -hdb1098:3316 $i -e "show create table templatelinks\G" | grep UNIQUE;done frwiki jawiki ruwiki
Sorry, it is still happening on s4:
{ "templatelinks tl_from index-mismatch-prod-extra": { "s4": [ "db1141.eqiad.wmnet", "db1121.eqiad.wmnet", "db1148.eqiad.wmnet" ] } }
Done! Thanks for reporting
root@cumin1001:/home/marostegui# for i in db1141 db1121 db1148; do echo $i; mysql.py -h$i commonswiki -e "show create table templatelinks\G" | grep UNIQUE;done db1141 db1121 db1148