Page MenuHomePhabricator

pl_from index still lingers in random hosts
Closed, ResolvedPublic

Description

I've got this:

    "pagelinks pl_from index-mismatch-prod-extra": {
	        "s4": [
	            "db1141.eqiad.wmnet",
	            "db1121.eqiad.wmnet",
	            "db1148.eqiad.wmnet"
	        ],
	        "s6": [
	            "db1098.eqiad.wmnet",
	            "db1096.eqiad.wmnet"
	        ]
	    }

It's likely similar to T252126: tl_from index on templatelinks is lingering in production and leftover from T174509: Drop now redundant indexes from pagelinks and templatelinks

Related Objects

Event Timeline

Marostegui triaged this task as Medium priority.Jun 30 2020, 4:43 AM
Marostegui moved this task from Triage to Backlog on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2020-06-30T04:56:29Z] <marostegui> Remove plfrom from db1096:3316 and db1098:3316 - T256684

db1096:3316 and db1098:3316 had pl_from on jawiki and ruwiki - I have removed them.

Mentioned in SAL (#wikimedia-operations) [2020-06-30T04:57:59Z] <marostegui> remove pl_from index from db1141, db1121, db1148 - T256684

Marostegui claimed this task.

Remove from s4:

root@cumin1001:~# for i in db1141 db1121 db1148; do mysql.py -h$i commonswiki -e "show create table pagelinks\G" | grep -i UNIQUE ; done
root@cumin1001:~#