Last modified: 2014-10-24 08:32:56 UTC
As can be seen from the following, at least the row for page_id=43871050 is missing from enwiki_p.page on s1 while it's present on s2, s4, and s5. tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h s1.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h s2.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43871050 2600 S2mtqnqvnkubl0g1 0 0 1 0.296643974044 20140919142659 19691231235959 626213539 1 NULL 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h s4.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43871050 2600 S2mtqnqvnkubl0g1 0 0 1 0.296643974044 20140919142659 19691231235959 626213539 1 NULL 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h s5.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43871050 2600 S2mtqnqvnkubl0g1 0 0 1 0.296643974044 20140919142659 19691231235959 626213539 1 NULL 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL
Since it seems we're moving from "s" names to "c", I tested those too: tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h c1.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h c2.labsdb enwiki_p page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model 43871050 2600 S2mtqnqvnkubl0g1 0 0 1 0.296643974044 20140919142659 19691231235959 626213539 1 NULL 43874575 2600 S2n8v8tnlfrk509z 0 0 1 0.256181787059 20140919185837 19691231235959 626243090 1 NULL tools.anomiebot@tools-login:~$ echo 'select * from enwiki_p.page where page_id in (43871050,43874575);' | mysql -h c3.labsdb enwiki_p ERROR 1045 (28000): Access denied for user 's51055'@'localhost' (using password: YES)
Sync in progress. Cause is not yet confirmed, with https://mariadb.atlassian.net/browse/MDEV-6551 a possibility. Very interested to hear if anyone observes this with recent (<1week) data.
