Page MenuHomePhabricator

Reimport wikidatawiki.{pagelinks,page} on labsdb1010
Open, MediumPublic

Description

Due to a recent crash on labsdb1010 (T233986#5527906) replication broke this week on wikidatawiki.pagelinks: T233986#5659184
I fixed that issue manually and ran a check against labsdb1011 and it has revealed more differences on pagelinks table.

This table should be reimported from labsdb1011 (or labsdb1012 as that one is only in use during the first days of the month).

I am also checking other main tables just in case there are more differences due to that crash.

Update: page table also has differences

Re-import progress:

  • page
  • pagelinks

Details

Related Gerrit Patches:
operations/puppet : productiondbproxy1011: Depool labsdb1010

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFri, Nov 15, 9:08 AM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Next on the DBA board.

I will try to do this next week using mydumper (the table is 91GB) - I will have labsdb1010 depooled during the re-import time.
We will probably have to drop+create the views I guess. We'll see.

Marostegui renamed this task from Reimport wikidatawiki.pagelinks on labsdb1010 to Reimport wikidatawiki.{pagelinks,page} on labsdb1010.Fri, Nov 15, 1:22 PM
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)Fri, Nov 22, 8:45 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-27T09:01:16Z] <marostegui> Stop replication on 1124:3318 to reimport wikidatawiki.page table on labsdb1010 - T238399

Change 554420 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy1011: Depool labsdb1010

https://gerrit.wikimedia.org/r/554420

Change 554420 merged by Marostegui:
[operations/puppet@production] dbproxy1011: Depool labsdb1010

https://gerrit.wikimedia.org/r/554420

Mentioned in SAL (#wikimedia-operations) [2019-12-04T07:09:30Z] <marostegui> Depool labsdb1010 to reimport wikidatawiki.page - T238399

wikidatawiki.page has been reimported from labsdb1012.
Views for that table have been recreated as well.

Marostegui updated the task description. (Show Details)Wed, Dec 4, 8:58 AM
Marostegui moved this task from Next to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2019-12-04T09:15:33Z] <marostegui> Reload labsdb1010 after reimporting wikidatawiki.page - T238399