commonswiki_p corrupted

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

commonswiki_p corrupted

Platonides
Commons copy on s3, s4 and s6 are corrupted. The versions at s1 and s5
are not affected.

Test case:
mysql -h $server commonswiki_p -e "SELECT page_title FROM page where
page_id=21683917"

Good:
+------------------------------+
| page_title |
+------------------------------+
| Dworzec_główny_w_Gdyni.jpg |
+------------------------------+

Bad:
+----------------------+
| page_title |
+----------------------+
| Dworzec_główny.jpg |
+----------------------+

It looks like a range of statements from November 2012 weren't replicated.

Other tests are:

SELECT log_id, log_title, log_type, log_action FROM
logging_ts_alternative where log_namespace=6 AND
log_title='Dworzec_główny.jpg'"
The wrong copies don't have «| 48917341 | Dworzec_główny.jpg | move |
move |» (the other 7 entries appear in both)

SELECT rev_id, rev_timestamp, rev_comment FROM revision where
rev_page=21683917
The wrong copies don't have the last 4 revisions (all of them from
2012-11-03)

'Dworzec_główny_w_Gdyni_4.jpg', 'Dworzec_główny_w_Gdyni_3.jpg',
'Dworzec_główny_w_Gdyni_2.jpg' are similarly affected, shown as just
Dworzec_główny_0X.jpg in the wrong dbs.

Comparing the number of revisions per day, it seems to have fixed on
2013-11-04, with the 3 being the most noticeable (27746 revisions where
they should have been 53974), a difference of 80 revisions the previous
day, 200 on 2012-10-27...

It should be possible to just copy the db from s1.

s1 and s5 are probably sane due to the reimports on January and April.

As an unexpected thing, sql-s2 and sql-s7 don't have a commonswiki_p
copy. sql-s3 and sql-s6 don't have a commonswiki_p.revision table/view.

I created https://jira.toolserver.org/browse/TS-1667


_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette