MZMcBride wrote:
Can someone verify the integrity of the page table for me, please?
mzmcbride@willow:~$ sql enwiki_p;
mysql> select * from page where page_namespace = 6 and page_title = 'Hubble_Space_Telescope_picture_of_Betelgeuse.jpg'; Empty set (0.00 sec)
mysql> select * from page where page_namespace = 0 and page_title = 'Hexen:_Beyond_Heretic'; Empty set (0.00 sec)
Compare:
- http://enwp.org/File:Hubble_Space_Telescope_picture_of_Betelgeuse.jpg
- https://en.wikipedia.org/wiki/Hexen:_Beyond_Heretic
To me, this indicates that either the master has some very serious problem (unlikely) or that the Toolserver's copy of the database has become corrupt (much more likely). Can anyone verify my findings?
Re: the missing image ("Hubble Space ..."), I filed https://bugzilla.wikimedia.org/show_bug.cgi?id=35054.
The "Hexen" case needs further investigation.
MZMcBride