https://bugzilla.wikimedia.org/show_bug.cgi?id=57642
--- Comment #14 from Christian Thiele <ap...@apper.de> --- Replication for dewiki works again, flaggedpages seems to be correct, too. But there are still missing revisions in the revision table: I don't know if these are the six million stated above (SELECT (SELECT count(*) FROM revision)+(SELECT count(*) FROM archive); vs. Special:Statistics), but there are missing revisions. Examples: 125050920 - https://de.wikipedia.org/?oldid=125050920 MariaDB [dewiki_p]> SELECT * FROM revision WHERE rev_id=125050920; Empty set (0.04 sec) Same for 125087630 and 125137961. These are all revisions from December 2nd or December 6th. MariaDB [dewiki_p]> SELECT count(*) FROM page WHERE page_namespace=0; +----------+ | count(*) | +----------+ | 2782237 | +----------+ 1 row in set (0.73 sec) MariaDB [dewiki_p]> SELECT count(*) FROM page, revision WHERE -> page_latest=rev_id AND page_namespace=0; +----------+ | count(*) | +----------+ | 2781856 | +----------+ 1 row in set (22.13 sec) These two numbers should be the same. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
