https://bugzilla.wikimedia.org/show_bug.cgi?id=29687
Dan Bolser <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Dan Bolser <[email protected]> 2011-07-06 09:28:06 UTC --- I debugged this a bit with TimStarling, but the results are still a bit confusing. It seems that MediaWiki is corrupting the page_touched field! I recently imported the data for this wiki from MW 1.11 (using MySQL dump 10.13 Distrib 5.1.56) into MW 1.17 (using MySQL 4.1.22-standard-log). Since that import, I touched a couple of pages (guess which?) and discovered this problem with the site map. Since reporting the two problem pages, I ran a process that touched many pages, and here is the state of the page_touched field: mysql> select page_touched, count(*) from mb_page group by page_touched limit 20; +----------------+----------+ | page_touched | count(*) | +----------------+----------+ | 2.01107052046E | 606 | | 2.01107052047E | 1179 | | 2.01107052048E | 1116 | | 2.01107052049E | 1255 | | 2.01107052092E | 2 | | 2.01107052094E | 1 | | 2.01107052095E | 1 | | 2.01107052096E | 5 | | 2.01107052097E | 275 | | 2.01107052098E | 132 | | 2.01107052227E | 2 | | 2.01107052229E | 1 | | 2.0110705223E+ | 1 | | 20070810130314 | 1 | | 20090609211125 | 1 | | 20100315174918 | 1 | | 20110705214006 | 1 | +----------------+----------+ 17 rows in set (0.01 sec) With help from TimStarling, I checked the data in my import 'dump' file, and concluded that it looks fine. I re-imported the dump, and it looked fine in the database (no 'corruption' like the above). I then followed the 1.17 DB update procedure (first using the GUI and then again using the CLI), and both looked fine (no corruption). Then I 'recovered' the correct page_touched field using the update (to keep my changes post import). Then I edited a page, and saw the same corruption! Before edit: mysql> select * from mb_page where page_title = "Main_Page"; +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | 4792 | 0 | Main_Page | | 93887 | 0 | 0 | 0.940133380737 | 20090811074455 | 15093 | 1069 | +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ 2 rows in set (0.01 sec) After edit: mysql> select * from mb_page where page_title = "Main_Page"; +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | 4792 | 0 | Main_Page | | 93888 | 0 | 0 | 0.940133380737 | 2.01107060996E | 15097 | 1074 | +---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ 2 rows in set (0.02 sec) As I said, in the interim I had touched many pages. Going to Google Webmaster Tools, I now see many errors! Seems pretty clear, now that I've set it out, that MW 1.17 (+ extensions) is borking the page_touched field on this version of MySQL, leading to an error in the sitemap. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
