Page MenuHomePhabricator

Missing plwikisource_p.revision and plwikisource_p.page data on labs replica database
Closed, DuplicatePublic

Description

As this query shows:

https://quarry.wmflabs.org/query/19383

Revisions from 1147609 to 1147764 are missing from plwikisource_p.revision table in labs database.

They do not seem to be deleted, so some Quary queries report incomplete revision lists (or incorrect revision count) for specific pages, eg.:

https://quarry.wmflabs.org/query/19385

vs.

https://pl.wikisource.org/w/index.php?title=Strona:M._Arcta_s%C5%82ownik_ilustrowany_j%C4%99zyka_polskiego_-_Tom_1.djvu/732&action=history

can it be fixed?

Event Timeline

Ankry created this task.Jun 9 2017, 10:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 9 2017, 10:52 PM
bd808 renamed this task from Missing data on labs replica database to Missing plwikisource_p.revision data on labs replica database.Jun 9 2017, 11:14 PM
Ankry added a comment.Jun 10 2017, 5:57 AM

The revisions missing from plwikisource_p were created between 20160428113148 and 20160428122541.
page table entries created in the same period, eg.
https://pl.wikisource.org/w/index.php?title=Specjalna:Wk%C5%82ad/AkBot&dir=prev&offset=20160428110138&limit=130&target=AkBot
are also missing. (I checked few random from the above list - none is found in labs)

Ankry renamed this task from Missing plwikisource_p.revision data on labs replica database to Missing plwikisource_p.revision and plwikisource_p.page data on labs replica database.Jun 10 2017, 5:57 AM