Change Details

I couldn't find any mention of this index but it exists in s8 only: ```lang=json "ipblocks ipb_parent_block_id_2 index-mismatch-prod-extra": { "s8": [ "db1109.eqiad.wmnet", "db1101.eqiad.wmnet", "db1126.eqiad.wmnet", "db1111.eqiad.wmnet", "db1099.eqiad.wmnet", "db1087.eqiad.wmnet", "db1092.eqiad.wmnet", "db1104.eqiad.wmnet" ] }, ``` That doesn't seem right.

I couldn't find any mention of this index but it exists in s8 only: ```lang=json "ipblocks ipb_parent_block_id_2 index-mismatch-prod-extra": { "s8": [ "db1109.eqiad.wmnet", "db1101.eqiad.wmnet", "db1126.eqiad.wmnet", "db1111.eqiad.wmnet", "db1099.eqiad.wmnet", "db1087.eqiad.wmnet", "db1092.eqiad.wmnet", "db1104.eqiad.wmnet" ] }, ``` That doesn't seem right. Progress: [] Codfw (to be done with replication) Eqiad: [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1005 [] db1126 [] db1124 [] db1116 [] db1111 [] db1109 [] db1104 [] db1101 [] db1099 [] db1092 [] db1087 To run: ``` alter table ipblocks drop index if exists ipb_parent_block_id_2; ```

I couldn't find any mention of this index but it exists in s8 only: ```lang=json "ipblocks ipb_parent_block_id_2 index-mismatch-prod-extra": { "s8": [ "db1109.eqiad.wmnet", "db1101.eqiad.wmnet", "db1126.eqiad.wmnet", "db1111.eqiad.wmnet", "db1099.eqiad.wmnet", "db1087.eqiad.wmnet", "db1092.eqiad.wmnet", "db1104.eqiad.wmnet" ] }, ``` That doesn't seem right. Progress: [] Codfw (to be done with replication) Eqiad: [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1005 [] db1126 [] db1124 [] db1116 [] db1111 [] db1109 [] db1104 [] db1101 [] db1099 [] db1092 [] db1087 To run: ``` alter table ipblocks drop index if exists ipb_parent_block_id_2; ```