Hey Adam,

I'd like to make sure I understand correctly. I propose the following three edit sequence.

{rev_id: 1, rev_timestamp: "20130911010101", parent_id: null}
{rev_id: 2, rev_timestamp: "20130911010101", parent_id: 1}
{rev_id: 3, rev_timestamp: "20130911011200", parent_id: ???}

Revisions #1 and #2 were saved in the same second (apparently #2 came after by a small fraction of a second). However, before #2 was saved, the edit pane was opened for creating revision #3. After 11 minutes, the third revisions is saved. Now my question is. What will its parent id be set to?

Thanks,

-Aaron

On Sat, Nov 9, 2013 at 8:38 PM, Oliver Keyes <okeyes@wikimedia.org> wrote:

Thanks!

On 9 November 2013 14:47, Toby Negrin <tnegrin@wikimedia.org> wrote:

Thanks Adam

On Nov 9, 2013, at 2:13 PM, Adam Wight <awight@wikimedia.org> wrote:

People doing revert analysis and stuff might be interested in this:
https://bugzilla.wikimedia.org/show_bug.cgi?id=56849

It turns out, for some time we have been failing to detect edit conflicts if the two page saves occur within one second of each other. The second save will silently overwrite the previous edit, because it derives from an earlier parent... but the parent_id recorded in the revision table will incorrectly point to the conflicting edit. So the edit will look like a reversion plus some editing.

G'luck!
-Adam

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

--
Oliver Keyes
Product Analyst
Wikimedia Foundation

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics