Rows missing from enwiki_p on s1, c1
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Anomie
	Sep 20 2014, 10:42 AM

Description

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

Version: unspecified
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=72226
https://bugzilla.wikimedia.org/show_bug.cgi?id=71176
https://bugzilla.wikimedia.org/show_bug.cgi?id=70711

Details

Reference: bz71084

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:59 AM

• bzimport added a project: Toolforge.

• bzimport set Reference to bz71084.

Anomie created this task.Sep 20 2014, 10:42 AM

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)