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

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMon, Jun 29, 7:51 PM
Reedy renamed this task from imagelinks has index mismtach on s8 to imagelinks has index mismatch on s8.Mon, Jun 29, 8:10 PM
Marostegui moved this task from Triage to Backlog on the DBA board.Tue, Jun 30, 4:43 AM
Marostegui triaged this task as Medium priority.Tue, Jun 30, 4:52 AM
Marostegui updated the task description. (Show Details)Tue, Jun 30, 5:07 AM
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)Tue, Jun 30, 5:12 AM

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

Marostegui updated the task description. (Show Details)Tue, Jun 30, 5:14 AM

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
Marostegui added a comment.EditedTue, Jun 30, 5:16 AM

eqiad progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1005
  • db1126
  • db1124
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • db1092
  • db1087
Marostegui closed this task as Resolved.Mon, Jul 6, 11:35 AM
Marostegui claimed this task.
Marostegui updated the task description. (Show Details)

All done