Hi.
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?
MZMcBride
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
The missing image for Hubble_Space_Telescope_picture_of_Betelgeuse.jpg exists on commons and is pulled into enwiki.
I was able to find the Hexen page: grphack@willow:~$ mysql -h enwiki-p.rrdb.toolserver.org enwiki_p -e "SELECT * FROM page WHERE page_namespace = 0 and page_title = 'Hexen:_Beyond_Heretic'" +---------+----------------+-----------------------+-------------------+--------------+------------------+-------------+-------------------+----------------+-------------+----------+ | page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | +---------+----------------+-----------------------+-------------------+--------------+------------------+-------------+-------------------+----------------+-------------+----------+ | 13612 | 0 | Hexen:_Beyond_Heretic | | 120 | 0 | 0 | 0.821679617112204 | 20120308123616 | 480826930 | 12016 | +---------+----------------+-----------------------+-------------------+--------------+------------------+-------------+-------------------+----------------+-------------+----------+
-Aaron
On Thu, Mar 8, 2012 at 12:15 AM, MZMcBride z@mzmcbride.com wrote:
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_Tele scope_picture_of_Betelgeuse.jpghttp://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
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Hello, At Thursday 08 March 2012 19:40:16 DaB. wrote:
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?
the enwiki-copy on thyme is corrupt, like status.toolserver.org tells since a few days. If the copy of rosemary is corrupt too is unknown at the moment. I will request a fresh dump at the wmf, but this can take some time.
Sincerly, DaB.
DaB. wrote:
At Thursday 08 March 2012 19:40:16 DaB. wrote:
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?
the enwiki-copy on thyme is corrupt, like status.toolserver.org tells since a few days. If the copy of rosemary is corrupt too is unknown at the moment. I will request a fresh dump at the wmf, but this can take some time.
Thanks. I forgot to check there. :-)
MZMcBride
toolserver-l@lists.wikimedia.org