I've got this:
"imagelinks il_to index-uniqueness-mismatch": { "s8": [ "db1109.eqiad.wmnet", "db1087.eqiad.wmnet", "db1099.eqiad.wmnet", "db1111.eqiad.wmnet", "db1092.eqiad.wmnet", "db1101.eqiad.wmnet", "db1104.eqiad.wmnet", "db1114.eqiad.wmnet", "db1126.eqiad.wmnet" ] },
Core says:
CREATE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from);
It should not be unique.
ALTER needed:
ALTER TABLE imagelinks DROP KEY IF EXISTS il_to, ADD KEY IF NOT EXISTS `il_to` (`il_to`,`il_from`);
Progress:
- codfw
- eqiad