Page MenuHomePhabricator

lc_lang_key index is lingering in production
Closed, ResolvedPublic

Description

As part of T146591: Add a primary key to l10n_cache this index should have been dropped but it exists in these hosts:

{
	"l10n_cache lc_lang_key index-mismatch-prod-extra": {
	        "s1": [
	            "db1089.eqiad.wmnet"
	        ],
	        "s2": [
	            "db1122.eqiad.wmnet",
	            "db1090.eqiad.wmnet"
	        ],
	        "s6": [
	            "db1131.eqiad.wmnet",
	            "db1093.eqiad.wmnet"
	        ],
	        "s7": [
	            "db1094.eqiad.wmnet"
	        ]
	 }
}

Please make sure that other parts of the schema change (like adding PK) is already done there.

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 TranscriptApr 13 2020, 9:03 AM
Ladsgroup updated the task description. (Show Details)Apr 13 2020, 9:04 AM
Marostegui moved this task from Triage to In progress on the DBA board.

s1 fixed - they extra KEY only existed on db1089 and dbstore1003:3311:

root@cumin1001:/home/marostegui# ./section s1 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port enwiki -e "show create table l10n_cache\G" | egrep "PRIMARY|KEY" | grep -v ENGINE ; done
labsdb1012.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
labsdb1011.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
labsdb1010.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
labsdb1009.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
dbstore1003.eqiad.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2130.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2116.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2112.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2103.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2097.codfw.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2094.codfw.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2092.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2088.codfw.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2085.codfw.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2072.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db2071.codfw.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1139.eqiad.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1134.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1124.eqiad.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1119.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1118.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1107.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1106.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1105.eqiad.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1099.eqiad.wmnet:3311
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1089.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1083.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)
db1080.eqiad.wmnet:3306
  PRIMARY KEY (`lc_lang`,`lc_key`)

s6 fixed for: db1093, db1131, db1139:3316, dbstore1005:3316

s7 fixed, only db1094 had the index (on all the wikis)

Marostegui closed this task as Resolved.Apr 13 2020, 9:34 AM

s2 fixed: dbstore1004:3312, db1140:3312, db1122:3312, db1090:3312,