--- Comment #2 from Ariel T. Glenn <> 2011-01-24 18:21:50 
UTC ---
I had a look at these.  I checked en wp carefully, and all of the incidents
that aren't pretty old, before a certain date in 2008 (i.e. rev 242099935 on,
and that's most of them) are moves.  It turns out that this is true for most
revs that I spot checked on the other projects as well.

So what happens with these moves?  There are two revisions with the same move
recorded in the log and the history; however three of them make it into the
revision table.

Here's a sample from en wp:

rev_id    | rev_page | rev_text_id | rev_comment 
398410443 | 11005908 |   399836293 | moved [[Wikipedia:Tutorial
(Editing)/sandbox]] to [[Wikipedia:Tutorial/Editing/sandbox]]...
398410417 | 11005908 |   399836293 | moved [[Wikipedia:Tutorial
(Editing)/sandbox]] to [[Wikipedia:Tutorial/Editing)/sandbox]]...

those show up in the history, and they are the "good" ones, as they have a page
id attached.  The "bad" one is

398410444 |        0 |   399843549 | moved [[Wikipedia:Tutorial
(Editing)/sandbox]] to [[Wikipedia:Tutorial/Editing/sandbox]]...

I looked at a number of these and they all display the same characteristics:

the third rev is the bad one, it has the same time stamp as the previous one,
and its text content is the redirect left behind by the move. 

Ie. the revision length of the bad one in the above is 48 and the text content
is #REDIRECT [[Wikipedia:Tutorial/Editing/sandbox]]
where the rev length of the other two revisions is 2806 and they contain the
actual page content.

This move issue is an outstanding issue, that is, it is not due to the master
slave issue we had recently or any of that, That's clear from the timestamps,
which in the above example well predate that outage.  In case someone might
think that the revision used to have the page id once upon a time and that the
corruption occurred later, I checked the history dumps from July and Sept of
last year for a couple of these revisions with earlier time stamps, and the two
good ones in each case appeared in the file but not the bad one.  That makes me
pretty sure this is a failure at the time of the move, and probably still a bug
in the code running now.

I hope that's enough information for someone who knows the innards of the
move/delete stuff to hazard a guess at the problem.

Configure bugmail:
------- 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

Reply via email to