| Marostegui added a comment. |
In T206743#4661943, @Addshore wrote:Which means there are ~9433 pages that now probably have the wrong page_latest, for example:
We are fixing that by recloning the hosts (T206743#4658362) from codfw, which have the correct data:
See how db1099 and db1101 already have the good data.
root@neodymium:/home/marostegui# ./section s8 | while read host port; do echo $host; mysql.py -h$host:$port wikidatawiki -BN -e "select page_id, page_title, page_latest from page where page_id = 99480;";done labsdb1011.eqiad.wmnet 99480 Q97215 737776142 labsdb1010.eqiad.wmnet 99480 Q97215 737776142 labsdb1009.eqiad.wmnet 99480 Q97215 737776142 dbstore2001.codfw.wmnet 99480 Q97215 745463455 dbstore1002.eqiad.wmnet 99480 Q97215 737776142 db2094.codfw.wmnet 99480 Q97215 745463455 db2086.codfw.wmnet 99480 Q97215 745463455 db2085.codfw.wmnet 99480 Q97215 745463455 db2083.codfw.wmnet 99480 Q97215 745463455 db2082.codfw.wmnet 99480 Q97215 745463455 db2081.codfw.wmnet 99480 Q97215 745463455 db2080.codfw.wmnet 99480 Q97215 745463455 db2079.codfw.wmnet 99480 Q97215 745463455 db2045.codfw.wmnet 99480 Q97215 745463455 db1124.eqiad.wmnet 99480 Q97215 737776142 db1116.eqiad.wmnet 99480 Q97215 745463455 db1109.eqiad.wmnet 99480 Q97215 737776142 db1104.eqiad.wmnet 99480 Q97215 737776142 db1101.eqiad.wmnet 99480 Q97215 745463455 db1099.eqiad.wmnet 99480 Q97215 745463455 db1092.eqiad.wmnet 99480 Q97215 737776142 db1087.eqiad.wmnet 99480 Q97215 737776142 db1071.eqiad.wmnet 99480 Q97215 737776142
The idea with the quick was to get some rows in place, rather than have no rows.
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
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
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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
