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

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, 8:27 PM
Marostegui triaged this task as Medium priority.Tue, Jun 30, 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 closed this task as Resolved.Tue, Jun 30, 4:59 AM
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:~#