[Wikidata-bugs] [Maniphest] [Commented On] T206743: S8 replication issues leading to rows missing during eqiad -> codfw switch (Was: "A few lexemes disappeared")

[Addshore]

Addshore added a comment.

Which means there are ~9433 pages that now probably have the wrong page_latest, for example:

MariaDB [wikidatawiki]> select page_id, page_title, page_latest from page where page_id = 99480;
+---------+------------+-------------+
| page_id | page_title | page_latest |
+---------+------------+-------------+
|   99480 | Q97215     |   737776142 |
+---------+------------+-------------+
1 row in set (0.00 sec)

MariaDB [wikidatawiki]> select rev_id from revision where rev_page = 99480 order by rev_id desc limit 2;
+-----------+
| rev_id    |
+-----------+
| 745463455 |
| 737776142 |
+-----------+
2 rows in set (0.00 sec)

These pages can be found with the following query:

SELECT DISTINCT rev_page, page_title, page_namespace, page_touched
FROM revision AS revision
INNER JOIN page AS page ON revision.rev_page = page.page_id
WHERE rev_id > 745452473 and rev_id < 745468910 and page_touched < 20181010151500
ORDER BY page_namespace, page_title;

TASK DETAIL

https://phabricator.wikimedia.org/T206743

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui, Addshore
Cc: Pigsonthewing, Nikerabbit, gerritbot, WMDE-leszek, jcrespo, mark, Stashbot, Nikki, Marostegui, daniel, TerraCodes, Liuxinyu970226, Addshore, Ladsgroup, Lea_Lacroix_WMDE, Lexicographical data, KaMan, CucyNoiD, Nandana, NebulousIris, Banyek, jijiki, Mringgaard, AndyTan, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Volans, Maathavan, Jonas, Johan, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Darkdadaah, TheDJ, Mbch331, Jay8g, Krenair, akosiaris

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs