Page MenuHomePhabricator

imagelinks has index mismatch on s8
Closed, ResolvedPublic

Description

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

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

Reedy renamed this task from imagelinks has index mismtach on s8 to imagelinks has index mismatch on s8.Jun 29 2020, 8:10 PM

Mentioned in SAL (#wikimedia-operations) [2020-06-30T05:13:45Z] <marostegui> Deploy schema change on s8 codfw - T256680

codfw done:

# /home/marostegui/section s8 | grep codfw | while read host port; do echo "$host:$port" ; mysql.py -h$host:$port wikidatawiki -e "show create table imagelinks\G" | egrep UNIQUE  ; done
db2100.codfw.wmnet:3318
db2094.codfw.wmnet:3318
db2091.codfw.wmnet:3306
db2086.codfw.wmnet:3318
db2085.codfw.wmnet:3318
db2084.codfw.wmnet:3306
db2083.codfw.wmnet:3306
db2082.codfw.wmnet:3306
db2081.codfw.wmnet:3306
db2080.codfw.wmnet:3306
db2079.codfw.wmnet:3306

eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1005
  • db1126
  • db1124
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • db1092
  • db1087
Marostegui claimed this task.
Marostegui updated the task description. (Show Details)

All done