Page MenuHomePhabricator

pl_from index still lingers in random hosts
Closed, ResolvedPublic


I've got this:

    "pagelinks pl_from index-mismatch-prod-extra": {
	        "s4": [
	        "s6": [

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 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 -h$i commonswiki -e "show create table pagelinks\G" | grep -i UNIQUE ; done